Re: Foreign keys and indexes

Marc Compte wrote:
> Thanks to everyone for the prompt reply :)
>
> Good thing about answers is when they raise up new questiosn, so you
> can keep on learning all the time.
>
> This one answer, for instance, brings me another question. Does having
> a composite primary mean the system will create an individual index on
> each of the fields? or is the index created on the composition only?
>
> For instance, in the implementation of a N:M relationship, declaring
> the primary as (foreign1, foreign2) will create two indexes? or just one?

Just one (and please don't top post.  :) )