Ways to improve statistics gathering
Hello
I'm on a database 11.2.4.
I need to gather statistics for daily partitions. I EXECUTE THE BELOW:
exec dbms_stats.gather_table_stats(ownname => 'SCHEMA', tabname => 'TABLE_NAME', partname => 'P_20170914', estimate_percent => 1, degree => dbms_stats.auto_degree, cascade => DBMS_STATS.AUTO_CASCADE);
It takes 35 minutes for each day and I only choose 1%.
1) Is there anything else I could do to use less rows for sample?
2) What does block_sample parameter do? Oracle help says:
"Whether or not to use random block sampling instead of random row sampling. Random block sampling is more efficient, but if the data is not randomly distributed on disk, then the sample values may be somewhat correlated. Only pertinent when doing an estimate statistics."