Gather Schema Stats | schema have 1 Big partition table
Team,
We do have a Table which is partition which we use to gather table stats with these options (estimate_percent => 30,
method_opt => 'FOR ALL COLUMNS SIZE AUTO', cascade => TRUE,
no_invalidate => FALSE, degree=>10, GRANULARITY => 'GLOBAL AND PARTITION' )
But we had a issue when we ran gather schema stats we didn't give these above options and the Performance was bad for the Process they were running.
So whats the best way to run the Schema stats if i have a schema with 1 partition table and others are normal table.
Will this help for Both partition table and Normal Tables? Please advise else what is the best option.
We do have a Table which is partition which we use to gather table stats with these options (estimate_percent => 30,
method_opt => 'FOR ALL COLUMNS SIZE AUTO', cascade => TRUE,
no_invalidate => FALSE, degree=>10, GRANULARITY => 'GLOBAL AND PARTITION' )
But we had a issue when we ran gather schema stats we didn't give these above options and the Performance was bad for the Process they were running.
So whats the best way to run the Schema stats if i have a schema with 1 partition table and others are normal table.
Will this help for Both partition table and Normal Tables? Please advise else what is the best option.
0