Re: Primary Keys and Foreign Keys

From: <>
Date: Thu, 30 Nov 2000 17:06:30 GMT
Message-ID: <>

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

>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
Received on Thu Nov 30 2000 - 18:06:30 CET

Original text of this message