Re: Primary Keys and Foreign Keys

<MSherrill_at_compuserve.com> wrote in message news:3a262824.158717433_at_news.compuserve.com...
> 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. :)
>

Ok. Sure wouldn't expect to find it in the. . .gasp. . .documentation :-) Received on Sat Dec 02 2000 - 02:21:20 CET