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
