• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 696
  • Last Modified:

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?
0
saratcm
Asked:
saratcm
  • 5
  • 3
2 Solutions
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
you create a maintenance plan, select the "reorganize index", schedule, and that's it.
what exactly is the problem?
0
 
saratcmAuthor Commented:
No, I mean will it do reorganize or rebuild?
If it is for reorganize, how to rebuild the indexes in MP?
0
 
saratcmAuthor Commented:
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?
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
here you go with a ready-to-use script:
http://www.mssqltips.com/tip.asp?tip=1367
0
 
saratcmAuthor Commented:
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?

0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
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
0
 
saratcmAuthor Commented:
So I am asking abt the diff it do in SQL 2000 MP, Any way thaks for your comments.
0
 
saratcmAuthor Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now