I was reading about the new query planner and came across a few references to that idea that the left most columns in the index definition should be the most unique (as far as values in the column are concerned).
Is that correct? In my case, many tables have a timestamp column, and I've been using that as my right-most column, but it seems it would be a great candidate to be switched. Thanks Doug _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users