Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> dbms_stats vs analyze for statistics
Doing a dbms_stats with method option of 'for all indexed columns size 254' with compute optin.
I notice that only indexed columns are getting column stats - as expected. Howver, if do an anaylze command instead, all columns get some sort of stats. For non-index columns, stats are apparently the min/max values for the column.
Anybody see a problem with only getting column stats for the indexed columns as dbms_stats is giving me.
Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113
(216) 781-4204
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeffrey Beckstrom INET: JBECKSTROM_at_gcrta.org Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Mon Jul 22 2002 - 12:03:35 CDT
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
![]() |
![]() |