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

Home -> Community -> Mailing Lists -> Oracle-L -> how determine chaining if using gather_stats

how determine chaining if using gather_stats

From: Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>
Date: Fri, 01 Jun 2001 05:04:16 -0700
Message-ID: <F001.00317961.20010601045522@fatcity.com> 







Since oracle seems to be pushing the dbms_stats.gather_stats procedure for 
getting table statistics.  Do you run a separate analyze command to find 
the number of chained rows since gather stats does not get this value.  Or 
are you still using "analyze".


 

 

 



Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional 
Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 
781-4204
Received on Fri Jun 01 2001 - 07:04:16 CDT












Original text of this message













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