On 15 Apr 2013, at 9:22pm, ven...@intouchmi.com wrote: > This is the create index statement: > CREATE INDEX IF NOT EXISTS > "DTC_Statuses_1_index" ON > "DTC_Statuses" ("Object_ID"); > > For some reason, when I execute analyze, my software locks up somewhere > when running its test queries. I'll delve further into this.
Worth noting that ANALYZE may end up having to read your entire database file into cache. So it can be slow. But if you're still having trouble with it try a "PRAGMA integrity_check": <http://www.sqlite.org/pragma.html#pragma_integrity_check> Having got ANALYZE working, please post another EXPLAIN QUERY PLAN so we can compare the two. I also note this: > WHERE ((([Object_Types].[Object_Type])="DTC")) This is technically incorrect. It should use single quotes around DTC, not double quotes. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users