Two ways gather stats in 11.2.0.3 what is the best
Hi experts.I have the following two ways of gathering the stats for the schemas, what method is the best?
How to Gather Optimizer Statistics on 11g [ID 749227.1]
How to Gather Optimizer Statistics on 11g [ID 749227.1]
Gathering statistics for all objects in a schema
exec dbms_stats.gather_schema_stats( -
ownname => ' Schema_name ', -
cascade => TRUE, -
method_opt => 'FOR ALL COLUMNS SIZE AUTO' );
execute dbms_stats.gather_schema_stats(ownname=>'<Schema_name>', DEGREE=> 5,CASCADE=>TRUE,estimate_percent=>DBMS_STATS.AUTO_SAMPLE_SIZE);exec dbms_stats.gather_schema_stats( -
ownname => ' Schema_name ', -
cascade => TRUE, -
method_opt => 'FOR ALL COLUMNS SIZE AUTO' );
0