_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Your where clause "WHERE ItemsME.IDR ..." is only satisfied if there is
an associated ItemsME record so the left outer join is pointless. Just
use the inner join. Normally the left outer join would include all of
ItemsME_Properties, that probably explains the table scan.
- [sqlite] LEFT JOIN optimization Mira Suk
- Re: [sqlite] LEFT JOIN optimization Jim Morris
- Re: [sqlite] LEFT JOIN optimization Mira Suk
- Re: [sqlite] LEFT JOIN optimization Dan Kennedy