Database Administration (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center