Igor Korot schrieb am 11.05.2013 08:14:
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
You are actually filtering positionsforleague by id, namely the id of
league named 'test'. So I'd recommend an index on positionsforleague.id.
I did a short test and it also creates a different query plan if this
index exists.
hth
Gerd
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
