Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2017
    Posts
    2

    Answered: Performans beetween primary key varchar and int

    Goodmorning everyone.
    It turns out that it is a bad choice to create primary keys, and consequently external keys, using varchar instead of integer fields?
    Are there any performance issues?
    Do you know any biographical references?
    thank you so much
    Marco

  2. Best Answer
    Posted by wjburke2

    "Well that been the question for years. I asked the same question a few years back and was told Integer keys are the best. But I have several databases that use primary\foreign key that are Character. Here is a good post on the subject. HERE"


  3. #2
    Join Date
    Mar 2015
    Posts
    61
    Provided Answers: 4
    Well that been the question for years. I asked the same question a few years back and was told Integer keys are the best. But I have several databases that use primary\foreign key that are Character. Here is a good post on the subject. HERE
    Last edited by wjburke2; 07-20-17 at 14:21.

  4. #3
    Join Date
    Jul 2017
    Posts
    2
    thank you wjburke2 !

  5. #4
    Join Date
    Jan 2017
    Posts
    18
    i think, you can get more help regarding primary key of SQL from this article https://www.janbasktraining.com/blog...-example-uses/ which is define all different type of Primary Keys..

Posting Permissions

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