Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Explain plan cardinality way off / bad plan problem
Perhaps the statistics are out of date. Look at dba_tables.num_rows
for all the tables in the query and the view used in the query. If the
value is more than 5% off from the actual count generate new
statistics. Compare before and after explain plans.
You might want to see if you can eliminate the outer select by pushing the outer select where clause conditions into the inner selects.
HTH -- Mark D Powell -- Received on Thu Jul 21 2005 - 18:32:32 CDT