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
