How to Determine When an Index Should be Rebuilt?
(Doc ID 1373415.1)
Last updated on DECEMBER 02, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 8.1.7.3 and laterOracle Cloud Infrastructure - Exadata Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Gen 2 Exadata Cloud at Customer - Version N/A and later
Information in this document applies to any platform.
Goal
How to determine when an index should be rebuilt?
NOTE:
Please note that the reason to rebuild an index should be because of poor performance of your queries using the index.
You should/must not rebuild indexes if you find the results for both relevant queries in 1. and 2. true for an index but that is not accompanied by poor SQL performance.
For a more current approach, please refer to
<Note 989093.1> - Index Rebuild, the Need vs the Implications
This Note 1373415.1 has been archived in favor of <Note 989093.1>
Please note that the reason to rebuild an index should be because of poor performance of your queries using the index.
You should/must not rebuild indexes if you find the results for both relevant queries in 1. and 2. true for an index but that is not accompanied by poor SQL performance.
For a more current approach, please refer to
<Note 989093.1> - Index Rebuild, the Need vs the Implications
This Note 1373415.1 has been archived in favor of <Note 989093.1>
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Goal |
| Solution |
| References |