On 3-4-2019 19:34, Jose Isaias Cabrera wrote:
Never mind, guys. I was missing the INDEX for the table for the first left
join:
CREATE INDEX PLE_ProjID ON Project_List_Extra (ProjID);
Everything is nice, now. Thanks.
From: Jose Isaias Cabrera
Sent: Wednesday, April 3, 2019 01:02 PM
To: sqlite-users@mailinglists.sqlite.org
Subject: [sqlite] Help with INDEXing a query
Greetings!
I am trying to speed up this query,
.....
sqlite> .expert
sqlite> select * from testing where a=42;
CREATE INDEX testing_idx_00000061 ON testing(a);
SEARCH TABLE testing USING INDEX testing_idx_00000061 (a=?)
sqlite>
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
