Re: Index usage question - 06-23-2003 , 10:23 PM
Don't rely on the implicit string to date conversion. Explicitly convert
AND reportdatentime >= '25-Mar-2003'
AND reportdatentime < '21-Jun-2003'
AND reportdatentime >= to_date('25-Mar-2003','dd-mmm-yyyy')
AND reportdatentime < to_date('21-Jun-2003','dd-mmm-yyyy')
If someone changes the nls date format default on the client the query won't
work. This method is much safer.
Replace part of the email address: kennedy-down_with_spammers (AT) attbi (DOT) com
with family. Remove the negative part, keep the minus sign. You can figure
"MThomas" <markt (AT) wrx-ca (DOT) com> wrote
Re: Index usage question - 06-24-2003 , 09:52 AM
Thank you Jim, Daniel and Brian for you help sorting myself out.
I have been able to get Oracle to rely on the index I require. A secondary
index on the table also seemed to be interferring with Oracle's selection of
the best way to select. After removing the extraneous index and resetting
the statistics, the performance seems to have come back into line (we now
seem to be bound through the network, but that's another project.
Have a good day all,
"Jim Kennedy" <kennedy-down_with_spammers (AT) attbi (DOT) com> wrote