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

Поиск
Список
Период
Сортировка
От Craig James
Тема Re: Query planning around one key of a multi-column index
Дата
Msg-id CAFwQ8reu3kbbREr2M2i-7o7C-UdTOpMybRyMzbkcCwjhmiyMYQ@mail.gmail.com
обсуждение исходный текст
Ответ на Query planning around one key of a multi-column index  (Wells Oliver <wells.oliver@gmail.com>)
Ответы Re: Query planning around one key of a multi-column index
Список pgsql-admin
Дерево обсуждения

On Wed, Dec 18, 2019 at 4:43 PM Wells Oliver <wells.oliver@gmail.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.

--


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

В списке pgsql-admin по дате отправления: