Interview Questions
Oracle DBA
Performance Tuning
Oracle DBA
Performance Tuning
Statistics are used by query optimizer to choose best execution plan. Statistics are stored in data dictionary.
DBMS_STATS Use to store/collect statistics in data dictionary for the use of query optimizer
ANALYZE Prior to Oracle8i used to collect statistics
You can collect statistics for the complete database or for particular objects (manually or automatically).
Tags:
