|
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 |
