Primary Key On Varchar column

• deba_20032004

  Default port

  Points: 1476

  More actions

  February 25, 2012 at 1:29 am

  #391652

  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: 1004454

  More actions

  February 25, 2012 at 2:33 am

  #1451682

  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