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

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(dot)oliver(at)gmail(dot)com> 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(dot)oliver(at)gmail(dot)com <wellsoliver(at)gmail(dot)com>
>

--
---------------------------------
Craig A. James
Chief Technology Officer
eMolecules, Inc.
3430 Carmel Mountain Road, Suite 250
San Diego, CA 92121
---------------------------------