estimate_percent and degree option in DBMS_STATS.GATHER_SCHEMA_STATS
479297Oct 20 2007 — edited Aug 12 2009Hi,
in gathering schema statistics.....we have to provide
estimate_percent => 100
degree => dbms_stats.default_degree
here estimate_percent means...while gathering statistics, it will take all records of the table or index...
if we give 20%, oracle will randomly selects the 20% of the data from data block and compute statistics....
is it right.....please correct me if i am wrong....