On 30 May 2012, at 6:15pm, Charles Samuels <char...@cariden.com> wrote:
> sqlite> select Name from Employee left outer join Uniform on > Employee.name=Uniform.employeename; > Joe > Steve > Eric > Dave > sqlite> explain query plan select Name from Employee left outer join Uniform > on Employee.name=Uniform.employeename; > 0|0|0|SCAN TABLE Employee (~1000000 rows) > 0|1|1|SEARCH TABLE Uniform USING COVERING INDEX sqlite_autoindex_Uniform_1 > (employeename=?) (~1 rows) Do an ANALYZE then try the 'explain query plan' again, just in case it helps. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users