Primary Key On Varchar column

  • deba_20032004

    Default port

    Points: 1476

    Dear Sir,

    I am in confusion I want to build primary key index(clustered) on varchar

    data type column which length(6), but my some freinds told me to buld index on int. data type column for your sql performance so what i do

    plz. give me idea and why do it plz. explain me..

    thanks & regards

  • Gail Shaw

    SSC Guru

    Points: 1004484

    http://www.sqlservercentral.com/articles/Indexing/68563/

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

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