Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how much time it take to rebuild an index for a table with 20 millions rows

tahaJun 1 2011 — edited Jun 1 2011

Hi all,

i need to rebuild the index of a table containing 20 000 000 row (i don't know why the other people working on this didn't think of rebuilding the index regularly, because i asked and apparently it has never been done :cry: :cry:) i am not a sql developper nor a DBA so i can't mesure how long it take to rebuild the index, does any one have an idea (aproximativly of course :aie:), the other question is there any formula to use in order to calculate how often to rebuild the indexes (i can for example retieve how much rows are delated or inserted daily ...)

Thanks again
Taha

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 29 2011

Added on Jun 1 2011

#general-database-discussions

15 comments

7,278 views