Rebuild of indexes and 'Sweeper' referred in Ask tom site

Giganews Newsgroups
Subject: Rebuild of indexes and 'Sweeper' referred in Ask tom site
Posted by:  nirav (shivam…@gmail.com)
Date: Thu, 29 Nov 2007

Hi ,

I have a question about rebuild of indexes...In Ask Tom site, Tom Kyte
says that rebuild is not required in 99% of time...except in situation
like 'sweepter'...but I am not getting clarity on  what is the
'sweeper' term referring to.  Can you please help me understand with
an example.

Thanks,
Nirav

Replies