Post reply

Online indexing not possible for lob columns table

  • April 14, 2010 at 4:16 pm

    #142550

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

    Thanks in advance,

    Manu

  • April 15, 2010 at 8:28 am

    #1152151

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

  • April 15, 2010 at 1:51 pm

    #1152415

    Any other reason apart from what Henry has suggested above!

  • April 15, 2010 at 2:10 pm

    #1152422

    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