Hello, sqlite> explain query plan SELECT name_id, inode, rowid FROM contents WHERE parent_inode=42 AND rowid > 12932 ORDER BY rowid; 0|0|0|SEARCH TABLE contents USING INDEX sqlite_autoindex_contents_1 (parent_inode=?) (~6 rows) 0|0|0|USE TEMP B-TREE FOR ORDER BY
Why does ordering by rowid need a temporary b-tree? Isn't the ordering by rowid also the order in which rows are stored, and therefore also already the order in which the SEARCH will find them? Best, -Nikolaus -- »Time flies like an arrow, fruit flies like a Banana.« PGP fingerprint: 5B93 61F8 4EA2 E279 ABF6 02CF A9AD B7F8 AE4E 425C _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users