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.
Vance
on Apr 15, 2013, Igor Tandetnik <i...@tandetnik.org> wrote:
>
>Are you sure? The query plan looks like Objects(Object_Type_ID) was
>added but DTC_Statuses(Object_ID) was not.
>
>Igor Tandetnik
>
>On 4/15/2013 3:57 PM, ven...@intouchmi.com wrote:
>> DTC_Statuses(Object_ID) and Objects(Object_Type_ID)
>>
>> Vance
>>
>> on Apr 15, 2013, Igor Tandetnik <i...@tandetnik.org> wrote:
>>>
>>> On 4/15/2013 3:45 PM, ven...@intouchmi.com wrote:
>>>> As a follow up, I added the other two indexes with no real inprovement.
>>>
>>> Which two indexes?
>>> --
>>> Igor Tandetnik
>>>
>>> _______________________________________________
>>> sqlite-users mailing list
>>> sqlite-users@sqlite.org
>>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>>
>
>
>_______________________________________________
>sqlite-users mailing list
>sqlite-users@sqlite.org
>http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
