Thursday, July 5, 2012

How to run gather statistics on a table.


You can use analyze command:

analyze table TABLE_NAME compute statistics  
or
analyze table TABLE_NAME estimate statistics 

also you can use "dbms_stats package" follow:

exec dbms_stats.gather_table_stats('ownername','tablename')

No comments:

Post a Comment