About index - "a query or data manipulation command can use at most one index per table"
От
Ying Lu
Тема
About index - "a query or data manipulation command can use at most
one index per table"
Дата
Msg-id
426E8131.8020005@cs.concordia.ca
Список
Дерево обсуждения
About index - "a query or data manipulation command can use at most
one index per table" Ying Lu <ying_lu@cs.concordia.ca>
Re: About index - "a query or data manipulation command Ragnar Hafstað <gnari@simnet.is>
Re: About index - "a query or data manipulation command can use at most one index per table" Michael Fuhr <mike@fuhr.org>
Hello List, A question about index. It mentioned in postgresql 8.0 doc "a query or data manipulation command can use *at most one index* *per table*". An example query is: select * from A left join B using (id) where A.type='apple' and A.isExport=true; "id" is the primary key for both table A & B. If index (type, isExport) has been created for table A. In the above query, will this index works? Thanks a lot, Emi
В списке pgsql-general по дате отправления