[ORACLE] dbms_stats - Table

Gather information about all columns

view source

print?

1	exec dbms_stats.gather_table_stats ( -

2	'&&owner', '&&table_name' -

3	,estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE -

4	,block_sample => true -

5	,granularity => 'all' -

6	,method_opt => 'for all columns size auto' -

7	,cascade => true)

Gather information about indexed columns

view source

print?

1	exec dbms_stats.gather_table_stats ( -

2	'&&owner', '&&table_name' -

3	,estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE -

4	,block_sample => true -

5	,granularity => 'all' -

6	,method_opt => 'for all indexed columns size auto' -

7	,cascade => true)