indexes - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Other SQL Server 2008 Topics

indexes

Author

Topic

sqlpavan
Starting Member

20 Posts

Posted - 2011-11-19 : 10:50:42

hi all..
can any explain me about reorganizing nd rebuilding indexes..wht was the main difference between these two..i dont want any links..plz explain me ...

thanks in advance..

s.pavan

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-11-19 : 11:31:36

I'm not rewriting Books Online, there are good explanations in there. The following page has a nice summary of what the two do and when they should probably be used.
http://msdn.microsoft.com/en-us/library/ms189858.aspx

--
Gail Shaw
SQL Server MVP

sqlpavan
Starting Member

20 Posts

Posted - 2011-11-19 : 11:58:26

really thanks for ur quick response gila..

s.pavan

johntech
Yak Posting Veteran

51 Posts

Posted - 2011-11-30 : 09:40:49

SQL SERVER – Difference Between Index Rebuild and Index Reorganize Explained with T-SQL Script

December 22, 2007 by pinaldave

Index Rebuild : This process drops the existing Index and Recreates the index.
USE AdventureWorks;
GO
ALTER INDEX ALL ON Production.Product REBUILD
GO

Index Reorganize : This process physically reorganizes the leaf nodes of the index.
USE AdventureWorks;
GO
ALTER INDEX ALL ON Production.Product REORGANIZE
GO

real article below
http://blog.sqlauthority.com/2007/12/22/sql-server-difference-between-index-rebuild-and-index-reorganize-explained-with-t-sql-script/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources