Skip to Main Content
Forums

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!

index rebuilding process

668822Jan 21 2009 — edited Jan 22 2009
hi masters,

it is "NOT" yet another thread on index rebuilding.

i read every thread on index rebuilding on oracle forums. every thread is full of load with arguments and dramatically valuable discussion.

but hardly some thread discuss the process of index rebuilding!!!!!

i would like to know what exactly oracle do, to rebuild the index??? does it use existing index as a source and hence require more space??

or it generates more redo therefore requires more space??

what oracle do with old index??? does it releases space occupied by old index???

if anyone have any link or suggestion then i will be thankful. and more deep knowledge sharing is appreciated.


thanks and regards
VD

Edited by: vikrant dixit on Jan 21, 2009 3:40 AM
This post has been answered by Charles Hooper on Jan 21 2009
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 19 2009
Added on Jan 21 2009
#general-database-discussions, #index, #process
12 comments
975 views