on line idex rebuild

Hi

I am having sql server 2000 cluster and doing index rebuild every week

Now i am moving to SQL server 2005

Should i be going for online index rebuild?

what is the frequency i should be following?

Please advise

Thanks in advance

Hi,

You may go for online index rebuilding but before refer Index Rebuilding carefully ,some excerpts here from BOL:

---

Online Index Operations

When rebuilding an index and the ONLINE option is set to ON, the underlying objects, the tables and associated indexes, are available for queries and data modification. Exclusive table locks are held only for a very short amount of time during the alteration process.

Reorganizing an index is always performed online. The process does not hold locks long term and, therefore, does not block queries or updates that are running.

You can perform concurrent online index operations on the same table only when doing the following:

Creating multiple nonclustered indexes.

Reorganizing different indexes on the same table.

Reorganizing different indexes while rebuilding nonoverlapping indexes on the same table.

sql