Monday, February 4, 2008

Improved Statistics Gathering in Oracle 11g

Oracle uses dbms_stats to manage optimizer statistics. The dbms_stats estimates statistics in a better way especially for large partitioned tables and thus results in faster SQL execution plans. dbms_stats package provides several pl/sql procedures to gather statistics for a table, schema, or a database.

Refer: http://www.articles.freemegazone.com/improved-statistics-gathering-oracle-11g.php

No comments: