|
-
Rebuild oracle indexes
I have three questions on rebuilding oracle table indexes.
1.What affects the table index tree, is it updates/inserts/deletes ?
2.I have a index defined over three columns in a table, and the table gets updated very frequently but those columns indexed are not updated.
Would those updates also affect the index tree..Do i need to rebuild the indexes in sucn cases too...
3.When does rebuilding index tree take more time, is it when the table has more number of records or the table had involved in more number of transactions ?
The core thing i would want to know is when to rebuild indexes and what indexes of a table need to be rebuilt.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|