March 26, 2010 at 3:21 am
Hi,
Can any one tell me what is the basic diff b/n index rebuild and reorganize how it will affect the sql performance.
thanks.
🙂
March 26, 2010 at 3:38 am
dba-vb (3/26/2010)
Hi,Can any one tell me what is the basic diff b/n index rebuild and reorganize how it will affect the sql performance.
thanks.
Go google/BOL 🙂
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
March 26, 2010 at 5:05 am
Rebuilding Indexes
Rebuilding an index drops and re-creates the index. This removes fragmentation, reclaims disk space by compacting the pages based on the specified or existing fill factor setting, and reorders the index rows in contiguous pages. When ALL is specified, all indexes on the table are dropped and rebuilt in a single transaction.When indexes with 128 extents or more are rebuilt, the Database Engine defers the actual page deallocations, and their associated locks, until after the transaction commits.
Reorganizing Indexes
Reorganizing an index uses minimal system resources. It defragments the leaf level of clustered and nonclustered indexes on tables and views by physically reordering the leaf-level pages to match the logical, left to right, order of the leaf nodes. Reorganizing also compacts the index pages. Compaction is based on the existing fill factor value.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 26, 2010 at 5:06 am
Refer this link alsohttp://technet.microsoft.com/en-us/library/ms189858.aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply