Hi all, Sorry in advance about this newbish question. Rest assured I've checked the FAQ, Wiki, and Googled before coming to you now empty-handed. I have a really simple schema:
CREATE TABLE CalendarData ( date date NOT NULL, uid char(40) NOT NULL, json text NOT NULL, PRIMARY KEY (date, uid) ); I just want to confirm that the index for the primary key efficiently handles queries using WHERE or BETWEEN on only the date field (avoiding a full table scan), such as the following: SELECT * from CalendarData WHERE date='2011-03-17'; SELECT * from CalendarData WHERE date BETWEEN '2011-02-01' and '2011-05-01'; I tried using 'explain' with the preceding queries, but the output was lower-level than I'd like. Any pointers on how to clearly show which indexes are used for a query? Thanks, Mike _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
