Primary key should always be auto increment - Database

Q.  Primary key should always be auto increment.
- Published on 26 Aug 15

a. True
b. False



  • Nirja Shah   -Posted on 02 Nov 15
    - Auto-incrementing primary keys are useful for several reasons:

    1. They do not allow duplicate user names.

    2. They allow the user name (or email address, if that's used to login) to be changed (easily)

    3. Selects, joins and inserts are faster than varchar primary keys as its much faster to maintain a numeric index

    4. Validation becomes very simple.

    5. Sanitation of input is trivial

    6. There is far less overhead as foreign keys don't have to duplicate potentially large string values

Post your comment / Share knowledge

Enter the code shown above:
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)