Easy primary key question

I think this is pretty basic, but: How does the order in which the fields in a composite primary key on a table affect the performance/effectiveness of the key? Is it based on the relative selectivity of the fields?

Thanks Received on Sat Nov 23 2002 - 13:15:56 CST