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?
Given a table FOO:
Column Type
I want to create a unique index on column foobar to
insure data integrity, but I also want a concatenated
index on foobar & foobee in order to speed table joins.
In many cases, I will not return any other data from FOO.
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?
foobar primary key
foobee foriegn key
foobat data
fooboo data
Thanks.
-Woody Received on Sat Apr 02 1994 - 19:51:07 CEST