On Tue, Apr 26, 2005 at 01:58:09PM -0400, Ying Lu wrote:
>
> 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
>
On Tue, 2005-04-26 at 13:58 -0400, Ying Lu wrote:
> 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?
simplest
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
