Re: Query planning around one key of a multi-column index

[Wells Oliver <wells.oliver@xxxxxxxxx>]

But so are you guys!

Thanks, this is helpful.

Is it really always true that querying off any column that's not the first column of a multi-column index will NOT use that index?

On Wed, Dec 18, 2019 at 7:02 PM Craig James <cjames@xxxxxxxxxxxxxx> wrote:

Google is your friend:

http://www.postgresqltutorial.com/postgresql-indexes/postgresql-multicolumn-indexes/

On Wed, Dec 18, 2019 at 4:43 PM Wells Oliver <wells.oliver@xxxxxxxxx> wrote:

I've been using PG now for so many years and I don't have a solid concrete answer on this in my head, and I feel like I should: if I have a table with a multi-column index and I query on one of those columns (or some subset of those columns), will it use that index?

Is there more reading on this topic? I've always felt it's a little more complicated but I'm not quite sure.

--

Wells Oliver
wells.oliver@xxxxxxxxx

--

---------------------------------
Craig A. James

Chief Technology Officer

eMolecules, Inc.

3430 Carmel Mountain Road, Suite 250

San Diego, CA 92121

---------------------------------

--

Wells Oliver
wells.oliver@xxxxxxxxx