>I recommend you execute the SQL command ANALYZE then try various of those SELECTs again. This can cause the SQLite optimizer to make different choices about which indexes to use.
Thanks for the suggestion. I am familiar with the Analyze command and have been using it. However, it doesn't seem to help in this scenario where the choice is whether or not to use the index for the ORDER BY or the JOIN. I find it a little frustrating that a single query can't use two indexes from the same table as other database engines support that ability. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
