CODEWITHSUNDEEP
sql-serverindexingfragmentationdefragmentation
Just a learner
Just a learner

Reputation: 28572

(SQL Server) How to defragment indexes with LOBs?

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.

Upvotes: 0

Views: 701

Answers (1)

gbn
gbn

Reputation: 432261

  • 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

Upvotes: 2

Related Questions