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