Garry Watkins <[email protected]> wrote: > Not sure why you are using a subselect with a union all. > > SELECT * > FROM multiturnTable > WHERE (player1 ='?' OR player2 ='?')
Because OR prevents SQLite from using an index on either player1 or player2, and turns the query into full table scan. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
