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" <[email protected]> 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 > [email protected]http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
