Home » RDBMS Server » Performance Tuning » INDEX rebuild with ONLINE Option
INDEX rebuild with ONLINE Option [message #235482] Sun, 06 May 2007 15:45 Go to next message
abcindiaxyz
Messages: 13
Registered: March 2005
Location: Indonesia
Junior Member
Dear All,
I have a 300GB database for which the INDEXE's are built every month.
Please provide the pros and cons of using the ONLINE option while creating the indexes....
Thanks in advance

Report message to a moderator

Re: INDEX rebuild with ONLINE Option [message #235483 is a reply to message #235482] Sun, 06 May 2007 15:51 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Why do you rebuild your indexes every month?

Regards
Michel

[Updated on: Sun, 06 May 2007 15:52]

Report message to a moderator

Re: INDEX rebuild with ONLINE Option [message #235485 is a reply to message #235482] Sun, 06 May 2007 16:10 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Please provide the pros and cons of using the ONLINE option while creating the indexes....
CON - wasted cpu cycles & disk I/O without any quantified benefit

What metric is used to determine which indexes would benefit & benefit by how much?

[Updated on: Sun, 06 May 2007 16:12] by Moderator

Report message to a moderator

Previous Topic: oracle sql query analyzer optimize tool
Next Topic: Index Issues
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 23 07:59:36 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.