Re: Primary Keys and Foreign Keys

On Wed, 29 Nov 2000 23:50:18 GMT, "Richard MacDonald" <macdonaldrj_at_worldnet.att.net> wrote:

[snip]
>Say I have a many-many table with the primary/candidate key being a
>composite of the two foreign keys. The database is going to
>create an index on these two fields. Now say that standard
>select queries will be one field or the other. Do I need
>to define two additional indices -- one for each of the two
>foreign keys?

I'd expect this to be implementation-dependent. Consider it a good opportunity to get familiar with the diagnostic tools your dbms provides. :)

-- 
Mike Sherrill
Information Management Systems