Re: About index - "a query or data manipulation command

[Ragnar Hafstað <gnari@xxxxxxxxx>]

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 is just to do an explain.

explain select * from A left join B using (id) where A.type='apple' and
  A.isExport=true;

gnari




---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings