SQLite Forum

Should SQLite be able to optimize this query?
Login
I'm glad to have posed something that turns out to be an interesting problem!