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
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: 64120
Registered: March 2007
Location: Nanterre, France, http://...
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: 25041
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:
  


Current Time: Tue Dec 06 14:17:27 CST 2016

Total time taken to generate the page: 0.11495 seconds