index on more-than-one columns?

From: Engard Ferenc <fery(at)pons(dot)sote(dot)hu>
To: PostgreSQL list <pgsql-sql(at)postgreSQL(dot)org>
Subject: index on more-than-one columns?
Date: 1999-08-14 14:51:47
Message-ID: Pine.LNX.4.02.9908141646590.312-100000@domesticus.sote.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(at)kkt(dot)sote(dot)hu
\__/ | | \_ \_/ I I http://pons.sote.hu/~s-fery

Browse pgsql-sql by date

  From Date Subject
Next Message Clayton Cottingham 1999-08-14 15:17:31 functions for...
Previous Message Clayton Cottingham 1999-08-14 05:28:20 full text index