Re: Design Question

From: <sergey_s_at_my-deja.com>
Date: 2000/08/10
Message-ID: <8muq76$v1o$1@nnrp1.deja.com>#1/1

If your queries reference multiple columns of a table in the WHERE clause then create a concatenated index on those columns with the order of columns matching the WHERE clause (given, of course, that these columns qualify for a certain type of indexing in the first place). The performance will be better if you have a concatenated index instead of multiple single column indexes.

Sergey

In article <3992d0c4.29956204_at_news.space.net>, jmayer_at_ratundtat.com (Jens Mayer) wrote:
> Hi folks,
>
> is there any difference concerning the performance between using
> primary keys with only one column and primary keys with more than one
> column ?
>
> jens
>
> Jens Mayer
> Rat & Tat GmbH
> Hamburg, Germany
>
> Jens Mayer
> Rat & Tat GmbH
> Hamburg, Germany
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Aug 10 2000 - 00:00:00 CDT