> Why don't you just explicitly sort by bar.foo? > > > sqlite> EXPLAIN QUERY PLAN SELECT bar.foo as id, foo.baz FROM bar CROSS JOIN > foo ON bar.foo = foo.id ORDER BY bar.foo LIMIT 10, 10; > 0|0|0|SCAN TABLE bar > 0|1|1|SEARCH TABLE foo USING INTEGER PRIMARY KEY (rowid=?) > sqlite>
I have explained that in the original message. 'foo' is a master table. There are more tables like 'baz' that play role of a partial index. Query is built dynamically from some collection of data. As a result, various combinations of 'foo', 'baz' and co may be in the resulting query. The only certain thing is that 'foo' is always in the query, hence the 'id'. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
