asked on

Reorganize Index in SQLServer 2000

Hi All,
How to schedule a reorganize index job on SQL 2000 using Maintenance plan?
How to schedule a rebuild index job on SQL 2000 using Maintenance plan?

SOLUTION

Guy Hengel [angelIII / a3]

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

saratcm

ASKER

No, I mean will it do reorganize or rebuild?
If it is for reorganize, how to rebuild the indexes in MP?

saratcm

ASKER

In SQL 2005 It clearly had seperate tasks,one to REORG & one to REBUILD.
In REBUILD section it will appear the same as it appear in SQL 2000 REORG.
So got confused, What exactly it is doing in SQL 2000 if we schedule REORG job using MP?
REORG or REBUILD?

ASKER CERTIFIED SOLUTION

Guy Hengel [angelIII / a3]

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

saratcm

ASKER

Just want to make sure, if I am right or no. there is a difference b/w REORG Index & REBUILD(DBREINDEX), right?

If so, there is a job which says reorganize indexes in SQL 2000 Maintenance Plan and if it do the REORG Index, is there a way to create REBUILD Index using Maintenance Paln in SQL Server 2000?

Guy Hengel [angelIII / a3]

rebuild will rebuild the index from ground up.
reorg will "just" check if there are any "pages" to be merged or splitted, based on the settings of the index.

I am not sure about what exactly the sql 2000 maintenance plan is doing, because I never used that one, as it just does all the indexes, which is just overkill

saratcm

ASKER

So I am asking abt the diff it do in SQL 2000 MP, Any way thaks for your comments.

saratcm

ASKER

Thanks