Originally Posted by waitecj Rebuilding (provided you have the space to do it), will do a fast full scan of the index (assuming Oracle can read all the blocks). Not if the index is unusable.
David Aldridge, "The Oracle Sponge" Senior Manager, Business Intelligence Development XM Satellite Radio Washington, DC Oracle ACE
Forum Rules