Updating oracle statistics dating direct georgia

Table DBA_OPTSTAT_OPERATIONS contains executions from dbms_stats package performed at the schema and database level.The history may have been purged in the meantime though (retention time can be retrieved by DBMS_STATS.

updating oracle statistics-2updating oracle statistics-14

1) By default, the UPDATE STATISTICS statement updates both index and column statistics.

Using the COLUMNS option of this statement will update column statistics only.

Using the INDEX option will update index statistics only.

2) By default, the UPDATE STATISTICS statement uses only a sample of records of the table.

Using UPDATE STATISTICS WITH FULLSCAN will scan the entire table.

3) Rebuilding an index, for example by using the ALTER INDEX …

REBUILD statement, will update only index statistics with the equivalent of using WITH FULLSCAN.

Rebuilding indexes does not update any column statistics.

4) Reorganizing an index, for example using the ALTER INDEX …

REORGANIZE statement, does not update any statistics.

So depending on your maintenance jobs and scripts several scenarios can exist.

Tags: , ,