What is compact large object column data?
Specifies that all pages that contain large object (LOB) data are compacted. The LOB data types are image, text, ntext, varchar(max), nvarchar(max), varbinary(max), and xml. Compacting this data can improve disk space use. The default is ON.
What is LOB compaction?
LOB_COMPACTION = ON. Specifies to compact all pages that contain data of these large object (LOB) data types: image, text, ntext, varchar(max), nvarchar(max), varbinary(max), and xml. Compacting this data can reduce the data size on disk.
What can be compacted in the reorganize index task?
The Reorganize Index task also includes an option to compact large object data. Large object data is data with the image, text, ntext, varchar(max), nvarchar(max), varbinary(max), or xml data type.
How to compact large objects in alter index?
From the alter index manual page: WITH ( LOB_COMPACTION = { ON | OFF } ) Specifies that all pages that contain large object (LOB) data are compacted. The LOB data types are image, text, ntext, varchar (max), nvarchar (max), varbinary (max), and xml. Compacting this data can improve disk space use. The default is ON.
How to reorganize indexes to improve performance?
Right-click the index you want to reorganize and select Rebuild. In the Rebuild Indexes dialog box, verify that the correct index is in the Indexes to be rebuilt grid and click OK. Select the Compact large object column data check box to specify that all pages that contain large object (LOB) data are also compacted.
What is the reorganize index task in SQL Server?
The Reorganize Index task reorganizes indexes in SQL Server database tables and views. For more information about managing indexes, see Reorganize and Rebuild Indexes. By using the Reorganize Index task, a package can reorganize indexes in a single database or multiple databases.