Home » RDBMS Server » Performance Tuning » Rebuild of indexes and 'Sweeper' referred in Ask tom site Options
Rebuild of indexes and 'Sweeper' referred in Ask tom site Options [message #284392] Thu, 29 November 2007 09:05 Go to next message
orausern
Messages: 817
Registered: December 2005
Senior Member
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 'sweeper'...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


[Updated on: Thu, 29 November 2007 09:05]

Report message to a moderator

Re: Rebuild of indexes and 'Sweeper' referred in Ask tom site Options [message #284396 is a reply to message #284392] Thu, 29 November 2007 09:14 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post the thread is AskTom where you find that.
I bet it is clearly explain in it.

Regards
Michel

[Updated on: Thu, 29 November 2007 09:14]

Report message to a moderator

Re: Rebuild of indexes and 'Sweeper' referred in Ask tom site Options [message #284492 is a reply to message #284392] Thu, 29 November 2007 21:35 Go to previous message
Kevin Meade
Messages: 2101
Registered: December 1999
Location: Connecticut USA
Senior Member
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:2913600659112


try this one. Do a page search for "sweeper", then look up a little. Something about right handed indexes...

It is a pretty obscure situation, but Tom is real good at finding these kinds of things for us to ponder.

Kevin
Previous Topic: parameter setting error
Next Topic: order of drop,create and create index during data load
Goto Forum:
  


Current Time: Mon Dec 05 21:26:58 CST 2016

Total time taken to generate the page: 0.09457 seconds