Post reply

is nvarchar(2000) is big or BIGINT is big in size

  • June 13, 2012 at 4:27 am

    #262393

    Hi Experts,

    I have a column of nvarchar type. is it good to create index on this. what is the effect if we created index on this type..

    Please help me in understanding this

    Thanks

    Chaithanya M

  • June 13, 2012 at 4:31 am

    #1500249

    It depends on what is in the column. Index size can't go over 900 though, so nvarchar(2000) is often impossible to index. BigInt is no problem to index.

    I'm kind of guess part of your question from the title of your post.

    Indexing depends on what the columns are for, and what you need to speed up for Selects.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • June 13, 2012 at 5:15 am

    #1500263

    No effect when you index a nvarchar column. Bigint has no problem

  • June 13, 2012 at 5:49 am

    #1500280

    Sony Francis @EY (6/13/2012)

    No effect when you index a nvarchar column.

    By 'No effect', you mean??????

    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 4 posts - 1 through 3 (of 3 total)

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