I am running a 9.2.0.5 db with the compatibility ini param set to 8.1.0
and the optimizer_features_enable is set to 9.2.0.
After reading an article on asktom I found that you can count the
records for a column in user_histograms to determine if histograms have
been created for that column.
I have a schema that all the tables and all columns have two records in
user_histograms. I believe this means that there is just a hi/lo
endpoint and no histograms for any columns in the tables. These stats
were generated using dbms_utility.analyze_schema(compute). My question
is what method_opt for dbms_stats.gather_schema_stats is equivalent?
All of the tables I have looked at have had two records for every
column. So I wouldn't think that 'for all columns' would be the same,
what about 'for all columns size 2' ??
Received on Fri Mar 10 2006 - 10:36:09 CST
