Originally posted by DaPi
Hi Abhay,
Slim's point is that if the index is usable, the rebuild is based on the index, NOT the table. The required data can be read in order by reading the chain of leaf blocks, so no sorting should be required.
Well i do understand that point and was of that impression too, but you can check the usage of Temp TS while even rebuilding usable index.
Abhay.
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"