I'm setting up a maintenance plan in SQL Server 2008 R2.
On the Reorganize Index Task it has an option for "Compact Large Objects". What does that mean and do I want to turn it on?
maintenancesql-server-2008
I'm setting up a maintenance plan in SQL Server 2008 R2.
On the Reorganize Index Task it has an option for "Compact Large Objects". What does that mean and do I want to turn it on?
Best Answer
Large objects (LOBs) are stored in different "pages". A page is a small section of a database, typically an 8kb chunk. For rows that contain LOB columns, the normal page will contain a reference to the LOB page.
From the alter index manual page:
The default is "on" and it's hard to think of a case where you'd want to turn it off. Perhaps if you had a strict time window for reindexing, and turning LOB compaction off would allow you to meet the window.