Re: Indexing Question.
From: Saad Ahmad <sahmad_at_mfa.com>
Date: 5 Feb 1995 00:29:08 GMT
Message-ID: <3h164k$il_at_homer.alpha.net>
Date: 5 Feb 1995 00:29:08 GMT
Message-ID: <3h164k$il_at_homer.alpha.net>
Tyler Van Gorder (tvangod_at_ecst.csuchico.edu) wrote:
> If you have a 4 part primary key do you need to define an index on each
> column or can you define an index on the entire key. If the second is
> the case, how is performance when say 2 of the 4 columns are supplied in
> a query?
You may give the entire key and as long as you are using the leading portion of the key its ok
-- ************************************************************** * Saad Ahmad * * E-Mail: sahmad_at_mfa.com * **************************************************************Received on Sun Feb 05 1995 - 01:29:08 CET