Re: Adding to Plan_Table

PRG, just because the first_rows version of the query is using indexes does not mean the all_rows version is less efficient. You need to actually test the queries. Then you should examine the statistics information to see why the CBO is wrong or why the use of indexes isn't the best plan. Often you can rewrite the query such that the CBO will find the best plan.

You can place hints in the SQL where necessary to provide the CBO guidence such as select /*+ ORDERED */ col_list ..... Hints are documented in the SQL Manual.

HTH -- Mark D Powell -- Received on Tue Aug 09 2005 - 09:02:32 CDT