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

Поиск
Список
Период
Сортировка
От Reid Thompson
Тема If an index is based on 3 columns will a query using two of the columns utilize the index?
Дата
Msg-id F71C0DC6B4FD3648815AAA7F969E35290194F1F3@sr002-2kexc.ateb.com
обсуждение исходный текст
Ответы Re: If an index is based on 3 columns will a query using two of the columns utilize the index?  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Re: If an index is based on 3 columns will a query using two of the columns utilize the index?  (Michael Fuhr <mike@fuhr.org>)
Список 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 по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: Replication
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: If an index is based on 3 columns will a query using two of the columns utilize the index?