Dual index question
From: Lewis W Kellum <lwk_at_engin.umich.edu>
Date: 2 Apr 1994 17:51:07 GMT
Message-ID: <2nkbabINNin1_at_srvr1.engin.umich.edu>
Date: 2 Apr 1994 17:51:07 GMT
Message-ID: <2nkbabINNin1_at_srvr1.engin.umich.edu>
Can anyone answer the following question regarding dual indices on a table?
Column Type
foobar primary key
foobee foriegn key
foobat data
fooboo data
If I do a select joining this table with the one where foobee is a primary key, and refer to both foobar and foobee in the where clause, which index will I be using?
Thanks.
-Woody Received on Sat Apr 02 1994 - 19:51:07 CEST