>>
>>You should have indexes on:
>>'koers_hist_tot.dat_krs',
>>'fondsen.fonds_cd',
>>'koers_hist_tot.fonds_cd'
>
>But if I index on fondsen it would take some time, so what is the use of this?

It's supposed to be done during database design, i.e. index already exists when you run query.