creating primaray keys in a database

[dominic_leo]

i would like to know whether there is a performance gain in creating auto generated primary keys or defininig your own primary keys.

[[deleted]]

I'm not sure about the performance issues, but there is one issue that makes auto-generated primary keys the best choice for most applications: uniqueness.

Only the database can generate a value for a primary key column and guarantee that that value does not yet exist in the table.

[Anon]

Hi,
I think the performance will be the same if you create the primary key which does not allow duplicates (indexed column) and the auto generated primary key
An index speeds up queries on the indexed fields as well as sorting and grouping operations but slow down the updates

Bye
Baby .V