Hi, ALL, sqlite> EXPLAIN QUERY PLAN SELECT positions.positionname, positionsforleague.val ue FROM positionsforleague, positions, leagues WHERE leagues.id = positionsforle ague.id AND positions.positionid = positionsforleague.positionid AND leagues.nam e = "test";
0|0|0|SCAN TABLE positionsforleague (~1000000 rows) 0|1|1|SEARCH TABLE positions USING INTEGER PRIMARY KEY (rowid=?) (~1 rows) 0|2|2|SEARCH TABLE leagues USING INTEGER PRIMARY KEY (rowid=?) (~1 rows) sqlite> .schema positionsforleague CREATE TABLE positionsforleague(positionid integer,id integer, value integer, fo reign key(positionid) references positions(positionid),foreign key(id) reference s leagues(id)); There is no WHERE filtering on positionsforleague table, so I'm not sure what index to create. What am I missing? Thank you. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
