Table & Index stats gathering best approach
Experts,
We have 270+ indexes on the Single table and it has 700+ columns.
Do we need to gather stats for each index ? or
Can we gather stats for all index in one command ?
Can we use below command to gather stats for table & indexes ?
SQL> EXEC dbms_stats.gather_table_stats(ownname => '&schema_name',tabname => '&table_name',cascade => true, estimate_percent => 40,method_opt=>'for all indexed columns size 1', granularity => 'ALL', degree => 4);
Enter value for schema_name: CAT
Enter value for table_name: VS_CUSORD
Need some inputs
Regards,
Thiyagu G