How can you determine if an index needs to be dropped and rebuilt?
- 1 Answers
- 654 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
Is oracle dba in demand?
How can you find out how many users are currently logged into the database? How can you find their operating system id?
How do you use automatic pga memory management with oracle 9i and above?
What is difference between co-related sub query and nested sub query?
What do you mean by oracle database?
What is the difference between truncate and delete? Why is one faster? Can we rollback both? How would a full table scan behave after?
What causes the "snapshot too old" error? How can this be prevented or mitigated?
What do you understand by a control file?
What is difference between logical standby database and physical standby database?
Who is dba in dbms?
When configuring sqlnet on the client what files need to be set up?
What are the skills required for oracle dba?
Oracle General 
