On Mon, Apr 15, 2013 at 9:45 PM, <ven...@intouchmi.com> wrote: > Igor, > > As a follow up, I added the other two indexes with no real inprovement. > Here is the new explain query plan: > 0|0|6|SEARCH TABLE Object_Types USING COVERING INDEX > sqlite_autoindex_Object_Types_1 (Object_Type=?) (~1 rows) > 0|1|1|SCAN TABLE DTC_Statuses (~1000000 rows) > 0|2|0|SEARCH TABLE Objects USING INTEGER PRIMARY KEY (rowid=?) (~1 rows) > 0|3|7|SEARCH TABLE DisplayFormats USING INTEGER PRIMARY KEY (rowid=?) (~1 > rows) > 0|4|2|SEARCH TABLE Object_TextTables USING INDEX Object_TextTables_1_index > (Object_ID=?) (~10 rows) > 0|5|3|SEARCH TABLE Object_Transactions USING INDEX > Object_Transactions_2_index (Object_ID=?) (~10 rows) > 0|6|4|SEARCH TABLE Equations USING INTEGER PRIMARY KEY (rowid=?) (~1 rows) > 0|7|5|SEARCH TABLE Equation_Types USING INTEGER PRIMARY KEY (rowid=?) (~1 > rows) >
No clue if it matters, but maybe you could gather stats on the tables, and see if that helps? --DD http://www.sqlite.org/lang_analyze.html _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
