Thanks. I didn't know this.
From: Luuk <luu...@gmail.com> Sent: Wednesday, April 3, 2019 02:34 PM To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] Help with INDEXing a query 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
