Multiple column index question.

From: "Jan Muszynski" <jan(at)jancm(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Multiple column index question.
Date: 2007-01-19 20:22:12
Message-ID: 45B0E224.6782.A59F71D@jan.jancm.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

If I have an index that's composed of 2 columns:
Index index1 on tableA (foo,bar)

and I then:
Select cola, colb from tableA where foo=<value>

Will index1 still be used, or am I looking at a seqscan under all
circumstances in this case?

TIA
-jan m

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Ribe 2007-01-19 20:35:26 Re: Clearing plans
Previous Message Merlin Moncure 2007-01-19 20:20:54 Re: Spam from EnterpriseDB?