Interested to Buy Any Domain ? << Click Here >> for more details...
Why do we need to rebuild indexes?
- 1 Answers
- 7 Views
- I also Faced
- E-Mail Answers
Answer / Dheeraj Kumar Raisinghani
Rebuilding indexes is necessary to maintain their performance over time. As data in the table changes, the index can become fragmented or inconsistent, which slows down its performance. Rebuilding an index can help improve its efficiency by eliminating fragmentation and correcting any errors.
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain the purpose of oracle real application clusters (rac)?
What do you understand by “performance tuning of db” & what are the different areas where we can perform tuning?
Where does the clusterware write when there is a network or storage issue?
What is the difference between media recovery & crash recovery?
How would you identify the shared_pool_size parameter that needs to be adjusted?
What is required by oracle rac database to connect to a network?
What are the key characteristics of rac or why to use rac?
Mention what is split brain syndrome in rac?
What is olr?
What is split brain syndrome in rac?
What is oracle real application clusters?
What do you understand by redo log file mirroring?
Oracle General 
