Online indexing not possible for lob columns table

  • Why online indexing is not possible when table has lob columns in it?

    Thanks in advance,

    Manu

  • I suspect it because some data it stored in a different location.

  • Any other reason apart from what Henry has suggested above!

  • Out of row storage would be just about it.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply