Rebuilding an index means deleting the old index replacing it with a new index. Performing an index rebuild eliminates fragmentation, compacts the pages based on the existing fill factor setting to reclaim storage space, and also reorders the index rows into contiguous pages.
You must gather statistics on a regular basis to provide the optimizer with information about schema objects. New statistics should be gathered after a schema object's data or structure are modified in ways that make the previous statistics inaccurate.
Gather Stats job is the default job running in Oracle Database for collecting the most used tables stats automatically. Oracle monitor the most DML tables with help of DBA_TAB_MODIFICATIONS view which stores information about the inserts, deletes, and updates to a table.
For more Information Visit:
asrblogger.com/
For More Detailed Info:
asrblogger.com/how-to-decide-...
asrblogger.com/basic-concepts...
asrblogger.com/index-and-stat...
Join Telegram : t.me/asrBlogger
Scripts from Github : github.com/anishs10/db-scripts
#oracledatabase #oracledatabasetutorial #performancetuning #databasetuning #performanceoptimization #asrblogger #asrbloggerdba
5 май 2023