(SQL Server) How to defragment indexes with LOBs?

693 views Asked by At

In SQL Server, are there some points on defragmenting indexes with LOBs? Such as text, ntext, image, varchar(max), nvarchar(max), varbinary(max), xml.

Thanks.

1

There are 1 answers

0
gbn On BEST ANSWER
  • You can't do online index rebuilds
  • You have the option LOB_COMPACTION. It does exactly that if ON

Otherwise, nothing special

I'd consider doing a LOB_COMPACTION less frequently but both options comes down to your maintenance windows duration pretty much