How to gather statistics in Oracle

There are several options to create statistics.
1.Analyze command
2.DBMS_UTILITY.ANALYZE_SCHEMA
3.DBMS_STATS.GATHER_SCHEMA_STATS
4.Transfering statistics between database.

No comments:

Post a Comment

Please Provide your feedback here