asked on

Rebuild and Reorganize Index

In SQL 2008, is it necessary to rebuild and reorganize the index under the maintenance Plans.

If so, which one should rebuild periodically? Should I Rebuild before Reorganizing?

What is the main difference between these two tasks? Are there any dangers to doing this?

I will be using the maintenance wizard to implement this, so any advice on the above questions would be helpful.

Thanks

ASKER CERTIFIED SOLUTION

Aneesh

membership

This solution is only available to members.

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

Start Free Trial

al4629740

ASKER

Why not the maintenance plans?

Aneesh

>Why not the maintenance plans?
You cannot really specify when to go for index reorganise and rebuild. Also i find it really hard to debug. The solution on that link is excellent most of the top SQL gurus uses that.

al4629740

ASKER

Would I run this code without modification?

http://ola.hallengren.com/scripts/IndexOptimize.sql

I am apprehensive about running any scripts that change something that I don't fully understand.

al4629740

ASKER

Also, in my original question, which would be better to do first?

Reorganize or rebuild?

SOLUTION

Anthony Perkins

membership

This solution is only available to members.

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

Start Free Trial

al4629740

ASKER

ok. How does one determine the avg_fragmentation_in_percent

Anthony Perkins

How does one determine the avg_fragmentation_in_percent
It is covered in that same article that Aneesh posted. Let me know if you are having difficulty reaching that link.