index rebuild vs index reorg

hi,

what are differences between index rebuild vs index reorg while getting statistics

when to use which one. Advantages, disadvantages of each

please advise.

DatabasesMicrosoft Server OSMicrosoft SQL Server 2008Microsoft SQL ServerMicrosoft SQL Server 2005

Last Comment

SysTools

8/22/2022 - Mon

SOLUTION

Maclean

12/21/2017

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

ASKER CERTIFIED SOLUTION

Ganesh Gurudu

12/21/2017

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

SysTools

5/14/2018

Index Rebuild & Index Reorganize are two different operations which are used to reduce fragmentation. Both work differently towards the same end.
Index Rebuild recreates the index by dropping existing index while Index Reorganize, physically reorganizes the leaf nodes of the index.
Go through the following link for further information:
http://www.sqlmvp.org/how-to-rebuild-and-reorganize-index-in-sql-server/

All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat

Certified Expert Program

Credly Partnership

Udemy Partnership