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
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
