>If the original table has an index starting with price: >WITH idlist(id) AS (SELECT id FROM fts WHERE col1 MATCH '50') SELECT * FROM table CROSS JOIN idlist ON (idlist.id=table.id) ORDER BY price; >or >WITH idlist(id) AS (SELECT id FROM fts WHERE col1 MATCH '50') SELECT * FROM table WHERE id IN (SELECT id FROM idlist);
Same time here.. And it doesn't seem to matter if there is an index. Its always "`--USE TEMP B-TREE FOR ORDER BY" Cross join is wayy slower btw. I guess its just not possible for it to use the index when orderingBy with a fts table.. Gotta move one for me. And please consider adding a forum. Its pretty annoying to receive 10 mails a day on a variety of topics just to follow a discussion. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users