Primary Key On Varchar column

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Performance Point » Primary Key On Varchar column

Primary Key On Varchar column

Rate Topic

Display Mode

Topic Options

Author

Message

deba_20032004

Posted Saturday, February 25, 2012 1:29 AM

Valued Member

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 1:33 AM
Points: 50, Visits: 219

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

Post #1257756

GilaMonster

Posted Saturday, February 25, 2012 2:33 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 6:47 AM
Points: 37,698, Visits: 29,960

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

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #1257759

« Prev Topic | Next Topic »

Permissions