Re: Index on multiple columns VS multiple index
От
Brice André
Тема
Re: Index on multiple columns VS multiple index
Дата
Msg-id
CAOBG12nbfWEZqnRT4s4w3Q7Z3QMnijzYAYE2GMJ2Oz4yzRDrBg@mail.gmail.com
Ответ на
Re: Index on multiple columns VS multiple index (Jonathan S. Katz)
Список
Дерево обсуждения
Index on multiple columns VS multiple index Brice André <brice@famille-andre.be>
Re: Index on multiple columns VS multiple index "Jonathan S. Katz" <jonathan.katz@excoventures.com>
this was what I was guessing. Thank you for the confirmation.
So I think that I now have a clear idea on the best index strategy for my project.
Thanks for your help,So I think that I now have a clear idea on the best index strategy for my project.
Regard,
2014/1/2 Jonathan S. Katz <jonathan.katz@excoventures.com>
On Jan 2, 2014, at 3:00 PM, Brice André wrote:If you define the index on ('a', 'b') in that order and are just searching for 'a' in your query, the query planner will use the index.
> But I have still one question that remains :
>
> suppose I define an index on ('a', 'b') columns, will it be useful for a search on 'a' column only, or will it be ignore by postgresl ?
Jonathan
В списке pgsql-sql по дате отправления
