michael4606
asked on
Determine If an Index Needs to Be Rebuilt
Hello,
In reading various information on the web there seems to be a great debate over rebuilding standard Oracle indexes( how often and how affective it is etc.). I have a table that experiences a large number of deletions plus others with not so heavy deletion rates. I am suspecting that performance may be enhanced if the index is rebuilt but I'd like to be able to determine this a head of time (some systems cannot use ONLINE option and need a maintenance window etc.).
1. How can I determine if an index needs to be rebuilt, i.e. is there a formula that shows efficiency etc.?
2. Can you recommend SQL that can be run to determine indexes that need to be rebuilt?
Thanks,
Michael
In reading various information on the web there seems to be a great debate over rebuilding standard Oracle indexes( how often and how affective it is etc.). I have a table that experiences a large number of deletions plus others with not so heavy deletion rates. I am suspecting that performance may be enhanced if the index is rebuilt but I'd like to be able to determine this a head of time (some systems cannot use ONLINE option and need a maintenance window etc.).
1. How can I determine if an index needs to be rebuilt, i.e. is there a formula that shows efficiency etc.?
2. Can you recommend SQL that can be run to determine indexes that need to be rebuilt?
Thanks,
Michael
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
....sorry, thought this would link you straight through to a web page regarding rebuilding issues, but it simply displays the search page. Enter "rebuilding indexes" and choose one of the returned discussions. "Rebuilding Indexes" is a good one.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Guys,
All really great material that cover this topic in complete detail.
Thanks!
All really great material that cover this topic in complete detail.
Thanks!