OraFAQ Forum: Server Administration » Index and Table rebuild method

Home » RDBMS Server » Server Administration » Index and Table rebuild method (Oracle 10.2.0.4.0,SunOS)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Index and Table rebuild method [message #539592]

Tue, 17 January 2012 05:21

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Hi,

Can you guys suggest me the best way to rebuild index and table and also give the reason as why we need to use this method?

Thank you

[Updated on: Tue, 17 January 2012 05:30]

Report message to a moderator

Re: Index and Table rebuild method [message #539595 is a reply to message #539592]

Tue, 17 January 2012 05:32

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

The best way is to not rebuild them and the reason is that there is no reason to rebuild them.

Regards
Michel

Report message to a moderator

Re: Index and Table rebuild method [message #539596 is a reply to message #539595]

Tue, 17 January 2012 05:40

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Quote:

The best way is to not rebuild them

Can you explain the above one as why we dont have to rebuild them?

Thank you

Report message to a moderator

Re: Index and Table rebuild method [message #539597 is a reply to message #539596]

Tue, 17 January 2012 05:44

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

The actual question is: Why do you want to rebuild them?

Regards
Michel

Report message to a moderator

Re: Index and Table rebuild method [message #539600 is a reply to message #539597]

Tue, 17 January 2012 05:57

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

For better performance.

Report message to a moderator

Re: Index and Table rebuild method [message #539610 is a reply to message #539600]

Tue, 17 January 2012 06:32

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

What make you think that rebuilding table or index you will have better performances? And better performances for what? In which circumstances?

Regards
Michel

Report message to a moderator

Re: Index and Table rebuild method [message #539616 is a reply to message #539610]

Tue, 17 January 2012 06:44

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

I believe rebuilding index and table will have better performance.

Report message to a moderator

Re: Index and Table rebuild method [message #539621 is a reply to message #539616]

Tue, 17 January 2012 07:08

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

"Believe"? What belief has to do with tuning? Tuning is a matter of science not belief.

Regards
Michel

Report message to a moderator

Re: Index and Table rebuild method [message #539624 is a reply to message #539616]

Tue, 17 January 2012 07:21

LNossov
Messages: 318
Registered: July 2011
Location: Germany

Senior Member

Regarding Index Rebuild s. the presentation of Richard Foote http://richardfoote.files.wordpress.com/2007/12/index-internals-rebuilding-the-truth-ii.pdf

Table Rebuild can help only for FTS's, because it sets the HWM lower.

Report message to a moderator