PostgreSQL Discussion - About index - "a query or data manipulation command can use at most

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

About index - "a query or data manipulation command can use at most

Ying Lu

2005-04-26, 1:23 pm

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

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Sponsored Links