What are optimizer statistics how can be collected?
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:
Last Updated (Wednesday, 23 December 2009 18:31)



