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. :) )