Re: [sqlite] use of index in ORDER BY clause

[Jay Sprenkle]

On 6/27/06, Jens Miltner <[EMAIL PROTECTED]> wrote:

When I run a query like

SELECT
        foo.id AS foo_id,
        bar.id AS bar_id
FROM
        bar
LEFT JOIN
        foo ON foo.id=bar.foo_id
ORDER BY
        bar.something

I think it's using the join first to determine what goes in the output set,
then sorting the output set using the ORDER BY.
That seems to be correct to me. It might not be optimal
but that would be extremely difficult to determine before executing
the query.


--
SqliteImporter and SqliteReplicator: Command line utilities for Sqlite
http://www.reddawn.net/~jsprenkl/Sqlite

Cthulhu Bucks!
http://www.cthulhubucks.com