Re: index rebuild online performance hit

Guy D. Kuhn wrote:
>
> What is the performance hit of doing an index rebuild online?
> Specifically, documentation says DML access to the "base table" is still
> allowed. Does that mean the index is unavailable while being rebuilt?
> That would seem reasonable.
>
> Thanks for any help.

Its available - you need a "quiet" period ie no active txns at the start and end of the index maintenance

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."