index rebuilding process
668822Jan 21 2009 — edited Jan 22 2009hi 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