If an index is based on 3 columns will a query using two of the columns utilize the index? - Mailing list pgsql-general

From Reid Thompson
Subject If an index is based on 3 columns will a query using two of the columns utilize the index?
Date
Msg-id F71C0DC6B4FD3648815AAA7F969E35290194F1F3@sr002-2kexc.ateb.com
Whole thread Raw
Responses Re: If an index is based on 3 columns will a query using two of the columns utilize the index?
Re: If an index is based on 3 columns will a query using two of the columns utilize the index?
List pgsql-general
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?

thanks,
reid



pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Replication
Next
From: Alvaro Herrera
Date:
Subject: Re: If an index is based on 3 columns will a query using two of the columns utilize the index?