0

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.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Just a learner
  • 26,690
  • 50
  • 155
  • 234

1 Answers1

2
  • 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

gbn
  • 422,506
  • 82
  • 585
  • 676