Re: If an index is based on 3 columns will a query using two of the columns utilize the index?

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Reid Thompson <Reid(dot)Thompson(at)ateb(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: If an index is based on 3 columns will a query using two of the columns utilize the index?
Date: 2005-09-12 14:00:41
Message-ID: 20050912140041.GB7856@surnet.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Sep 12, 2005 at 09:43:57AM -0400, Reid Thompson wrote:
> Example:
> assume a table of 10 columns, three of which are fname, lname, and dob.
> If an index is created on (fname, lname, dob), will a query that
> utilizes two of the columns ( select 'data' from table where fname = 'X'
> and lname = 'Y') utilize the index?

Yes, if it is selective enough. (It _can_ use the index, which does not
mean that it _will_ use it.) Note that if your example query used the
columns (lname, dob), the answer would be "no."

--
Alvaro Herrera -- Valdivia, Chile Architect, www.EnterpriseDB.com
Officer Krupke, what are we to do?
Gee, officer Krupke, Krup you! (West Side Story, "Gee, Officer Krupke")

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2005-09-12 14:04:53 Re: If an index is based on 3 columns will a query using two of the columns utilize the index?
Previous Message Reid Thompson 2005-09-12 13:43:57 If an index is based on 3 columns will a query using two of the columns utilize the index?