Re: Indices

From: Steve McDaniels <steve.mcdaniels_at_sierra.com>
Date: 2000/05/02
Message-ID: <8enafa$kco$1@plo.sierra.com>#1/1

I'm not positive, but my experience indicates that it would be MUCH better if you added a sequence number to the table, declared it to be the primary key, then indexed each of the individual fields which you used to build
your composite key. Using [partial] composite keys frequently requires a full INDEX scan which, although faster than a full table scan, is not the fastest.

"craibuc" <craibucNOcrSPAM_at_hotmail.com.invalid> wrote in message news:055c9c20.bcb6cb5e_at_usw-ex0105-035.remarq.com...
> If I have a multi-column index on a table, and I only use a
> subset of the index's columns in a query, will the index be
> used? What are the rules?
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
*
> The fastest and easiest way to search and participate in Usenet - Free!
>
Received on Tue May 02 2000 - 00:00:00 CDT