The though I had in mind was that you might
post the two execution plans, and perhaps
a little detail of the tables and their indexes,
then someone might spot something useful.
Have you analyzed the tables ?
Have you set query_rewrite_enabled=true,
which you probably need to get the nlssort()
index to behave ?
--
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Author of:
Practical Oracle 8i: Building Efficient Databases
Next Seminar - Australia - July/August
http://www.jlcomp.demon.co.uk/seminar.html
Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Ariel wrote in message ...
>I use application SQLAnalyze from Tuning Pack.
>on explain plan i see that indices are used on WHERE clause.
>
>I try to remove ORDER BY clause, and this helps...
>Times of executions equals.
>
Received on Thu Apr 25 2002 - 06:17:07 CDT
