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: Difference between build index and gather stat

Re: Difference between build index and gather stat

From: <bdbafh_at_gmail.com>
Date: 18 Apr 2006 22:13:02 -0700
Message-ID: <1145423582.570034.307560@g10g2000cwb.googlegroups.com> 





you can assume that the cost based optimizer will use the information
available to try to provide an optimal execution plan.



if you leave it (the CBO) to assume that there are say 1000 rows that
will be read in a single multiblock read because the stats have not
been updated ... suffer the consequences.



The load routine should gather stats (cascade) after the load.



-bdbafh
Received on Wed Apr 19 2006 - 00:13:02 CDT












Original text of this message













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