Hi Igor, I'm getting ....
"0","0","TABLE first_table WITH INDEX first_table_target_field_id" "1","1","TABLE second_table USING PRIMARY KEY" "2","2","TABLE third_table USING PRIMARY KEY" ... so I presume it is then. (Is there anywhere that explains how to interpret this?) Thanks ALJ On May 5, 1:45 pm, "Igor Tandetnik" <itandet...@mvps.org> wrote: > Astley Le Jasper wrote: > > Given the example below where 'first_table' could be huge, are sqlite > > or other relational databases clever enough to do the WHERE filter > > before doing the joins. > > I would expect SQLite to do it this way, yes. Especially if there's an index > on first_table.target_field. You can confirm with EXPLAIN QUERY PLAN > -- > Igor Tandetnik > > _______________________________________________ > sqlite-users mailing list > sqlite-us...@sqlite.orghttp://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
