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 information
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 a
> 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?
It shouldn't cause any prob
