Say I have a table created like this: create table table1( [id] integer primary key, [dob] integer)
with an index (not unique) on dob and I run this SQL: select id, dob from table1 then the query plan I get is: SCAN TABLE TABLE1 USING COVERING INDEX IDX_TABLE1_DOB The result is that the output is descending on DOB. I expected and preferred if the output was ascending on rowid. What is the idea/logic of this query plan? Using SQLite 3.16.2 RBS _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
