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
Monday, February 4, 2008
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment