SQLite Forum

Should SQLite be able to optimize this query?
Login
This optimization is now available on the [omit-subquery-order-by branch][1].
Try it out if you dare.  All the core SQLite tests pass now, but there is 
still no guarantee that this will ever land on trunk.

[1]: src:/timeline?r=omit-subquery-order-by