On Tue, Feb 8, 2011 at 9:12 AM, Ian Hardingham <[email protected]> wrote: > Wow - changing to that in combination with indexes on player1 and > player2 has dropped the time to 25 and 10 - an incredible improvement. > > I'll need to get my head around using combinations of queries which each > only use indexed columns.
SQLite3 uses a single index per-table in a select, but it can perform the optimization suggested by Igor (OR -> UNION ALL). Use EXPLAIN QUERY PLAN to see what SQLite3 is doing. Nico -- _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
