is it generally recommended / a good idea to have more than one PRI index
in the same table? i've never seen that before until today while trying
to track down bugs in someone else's system and noticed a table with 2 PRI
indexes. will this cause any problems?
tia.
~shawn
At 10:33 AM -0500 8/29/01, shawn reed wrote:
is it generally recommended / a good idea to have more than one PRI index
in the same table? i've never seen that before until today while trying
to track down bugs in someone else's system and noticed a table with 2 PRI
indexes. will this cause any
He may mean a composite primary key, which is a primary key based on two columns. On
whether this is a good idea or not it's really a question of whether you want to use
natural or surrogate keys on your tables.
A composite key is typically a natural key. A natural key is a key with