At 9:22 PM +0300 6/13/1999, Mark Papadakis wrote:
>Is a primary index exactly the same thing as a unique index, except that it
>is market as a primary?
They are the same.
>Also, do primary/unique keys make sense only on multi-column keys?
What does that mean, "make sense"? Do you mean "are they only useful
for multi-column keys"? If so, the answer is no. For example, any table
which lists unique entities and has an identifier number column will
likely benefit from putting a unique index on that column.
Paul DuBois, paul@stripped
Northern League Chronicles: http://www.snake.net/nl/