Menu
  • HOME
  • TAGS

How does using char(17) as primary key to store VIN numbers in a table with SQL Server affect performance? [closed]

sql-server,join,primary-key,sqldatatypes,vin

Just a personal opinion.. I always use int as a primary key. Primary key is in most cases always a clustered index. It's 4 bytes vs. 17 bytes and you can always put a non-clustered index on your VIN column. Keep things simple and clear. It's just my opinion though....