Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: EXPLAIN PLAN : better with RULE!

Re: EXPLAIN PLAN : better with RULE!

From: Loadrunner <load_at_runner.com>
Date: Tue, 16 Jul 2002 10:17:46 +0100
Message-ID: <1026810930.9839.0.nnrp-10.c2d92da9@news.demon.co.uk> 





Can you confirm that you have analyzed tables with the "For Table For All
Columns For All Indexes" clause?



If very large table estimate the statistics.



The explain plan produced when CBO active can vary dramatically with or
without statistics.
Received on Tue Jul 16 2002 - 04:17:46 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US