>Hi all,
>
>I have a query that I want to optimize with rushmore index:
>
>
>Select fondsen.*,koers_hist_tot.dat_krs;
>from fondsen;
>left outer join koers_hist_tot;
>on fondsen.fonds_cd = koers_hist_tot.fonds_cd;
>where koers_hist_tot.dat_krs = dat_e_bkp
>
>
>This query takes 200 seconds. Fondsen has 5 million records and koers_hist_tot 60,000 records.Dat_krs is a date,dat_e_bkp a constant. I don't want to index on fondsen because that takes too long. Is it possible to speed it up?
>
>Thanks beforehand.
You should have indexes on:
'koers_hist_tot.dat_krs',
'fondsen.fonds_cd',
'koers_hist_tot.fonds_cd'
Edward Pikman
Independent Consultant