Results 1 to 2 of 2

Thread: Performance (Primary Key)

  1. Oct 11th, 2000, 10:33 AM #1
    chicho_chicho
    chicho_chicho is offline

    Thread Starter
    Junior Member
    Join Date
    Jul 2000
    Location
    Mexico
    Posts
    24

    Question

    Hello,
    I have to make a decision between a char(9)
    or a smallint on SQLServer 7 for a
    Primary Key on a Products Table
    Does anyone have suggestions about which performs
    better?
    Thanks!
    Chicho
    Reply With Quote Reply With Quote
  2. Oct 11th, 2000, 11:29 AM #2
    JHausmann
    JHausmann is offline
    Frenzied Member
    Join Date
    Aug 1999
    Location
    Santa Clara, Ca , 95058
    Posts
    1,105
    Small int. It'll consume less space (I think it's 2 bytes) than than char fld. Less space almost always = faster.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width