ntext indexing problem?

  • why we cannot apply indexing to ntext datatypes?

  • Maximum key length for an index is 900 bytes, as ntext can store up to 2GB you cant index it

  • Because it doesn't make sense to do so. If you think about an index in a book, the keys are short. NText is a blob store for large amounts of text data. Even if it could be an index key, it wouldn't be at all useful.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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