Hey,
I was wondering if anyone could give me some tips on forcing specific indexes to be used in select statements (or point me to some documentation on the subject). I encountered some yesterday that by changing something in the WHERE clause would speed up the query from 60 minutes to 2 minutes because a specific index was used like it should have been.
Thanx,
JB
P.S. Were hints (ie. /*+ INDEX tablename indexname*/ ) available in Version 7? I can't get my hands on any documentation other that some archived HTML stuff on Oracle Web site.
I was wondering if anyone could give me some tips on forcing specific indexes to be used in select statements (or point me to some documentation on the subject). I encountered some yesterday that by changing something in the WHERE clause would speed up the query from 60 minutes to 2 minutes because a specific index was used like it should have been.
Thanx,
JB
P.S. Were hints (ie. /*+ INDEX tablename indexname*/ ) available in Version 7? I can't get my hands on any documentation other that some archived HTML stuff on Oracle Web site.