Re: Oracle Order By Clause

Which optimizer goal do you use?

Try the cost-based optimizer and use a optimizer hint:

select /*+ all_rows */ ...
or
select /*+ first_rows */ ...

Don't forget to analyze your schema on a regulary basis:

execute dbms_utility.analyze_schema('<SCHEMA_NAME (capital letters)>','COMPUTE');

hope that helps
Falk Received on Sat Feb 07 1998 - 00:00:00 CST