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 -> Compute Statistics during Index Creation

Compute Statistics during Index Creation

From: tq <tomm_quinn_at_yahoo.com>
Date: 1 Feb 2006 10:05:20 -0800
Message-ID: <1138817120.783862.70640@g14g2000cwa.googlegroups.com> 






Does anyone know how expensive it is (what additional work needs to be
done by Oracle) if you add compute statistics in the 'create index'
call? I'm sure it's less than a separate analyze, just wondering how
much of the index creation it can leverage to gather the stats.



Thanks.
Received on Wed Feb 01 2006 - 12:05:20 CST












Original text of this message













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