Skip Montanaro wrote:
> Skip Montanaro <skip@pobox.com> added the comment:
>
> 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.
It doesn't guarantee it, but the implementation behaves like this.
-- Gerhard