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-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users