Re: Design Question

Sergey is correct that performance will be better with a concatenated index vs multiple single column indexes. However, you will get the best performance out of a single unique numeric index. Oracle helps you achieve this with automatic sequence generation, or you can generate these numbers by your own devices.

Taz

<sergey_s_at_my-deja.com> wrote in message news:8muq76$v1o$1_at_nnrp1.deja.com...
> 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 Sun Aug 13 2000 - 00:00:00 CDT