◐ Shell
clean mode source ↗

Message 73027 - Python tracker

Gerhard> FWIW that will also work without the ORDER BY, because you're
    Gerhard> getting the rows back in the same ORDER. Something cheaper
    Gerhard> would also be "ORDER BY ROWID". I still propose to just do
    Gerhard> without the ORDER BY.

As long as SQLite guarantees that the ordering is identical, then sure, dump
the ORDER BY clause.

Skip