Postgres Pro
Downloads
Home   >   mailing lists

index on more-than-one columns? - Mailing list pgsql-sql

From Engard Ferenc
Subject index on more-than-one columns?
Date
Msg-id Pine.LNX.4.02.9908141646590.312-100000@domesticus.sote.hu
Whole thread Raw
Responses Re: [SQL] index on more-than-one columns?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view 
Hi all,

Is there any advantage to use index on more columns against to use
more separate indexes, e.g. creating index on t1 (a,b) instead of
index on t1 (a) plus index on t1 (b)? Let's suppose that the queries
include all sorts of combinations.

Thx:
Circum
__  @
/  \    _   _                                           Engard Ferenc
l    | ( \ /  | | (\/)                      mailto:s-fery@kkt.sote.hu
\__/ | |   \_ \_/ I  I                    http://pons.sote.hu/~s-fery

pgsql-sql by date:

Previous
From: Herouth Maoz
Date:
Subject: RE: [SQL] datediff function
Next
From: Tom Lane
Date:
Subject: Re: [SQL] index on more-than-one columns?