How can you determine if an index needs to be dropped and rebuilt?
- 1 Answers
- 653 Views
- I also Faced
- E-Mail Answers
Answer Posted / Rupesh Kumar Singh
"To determine whether an index needs to be dropped and rebuilt, you can consider the following factors: 1) High Index Fragmentation: Run DBMS_SPACE_ADVISOR.REPORT_INDEX_USAGE to check if there is a high level of fragmentation in the indexes. 2) Slow Query Performance: Monitor query execution statistics using tools like Oracle AWR, ASH, or EXPLAIN PLAN to identify any indexes that are causing slow performance. 3) Index Stats Stale: Check if the statistics on the index are stale by running DBMS_STATS.GATHER_INDEX_STATS."
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
No New Questions to Answer in this Category !! You can
Post New Questions
Answer Questions in Different Category
