ALTER INDEX REORGANIZE Compacts pages that contain large object (LOB) data. Does rebuilding also do it?

hi,

ALTER INDEX REORGANIZE Compacts pages that contain large object (LOB) data.

Does rebuilding also do it?

yours sincerely

Hello,

If you read books online definition it is written as below.I don't think compacting here has any literal meaning since in rebuild indexes are dropped and recreated.But both Rebuild and reorganize compact pages based on fill factor.

Compact pages for LOB data option is only present for Reorganize

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. FOREIGN KEY constraints do not have to be dropped in advance. 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.

http://ift.tt/PGTZ9Z

---

Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers