Am Mon, 1 Jan 2018 20:30:10 +0100 schrieb Clemens Ladisch: > Wolfgang Enzinger wrote: >> Am Mon, 1 Jan 2018 16:20:21 +0100 schrieb Clemens Ladisch: >>> It is indeed possible to change the query so that SQLite uses rowid >>> lookups for the R-tree filter (INDEX 1). However, any likelihood on the >>> R-tree search expression still did not make any difference. Do you have >>> an example? >> >> SELECT * FROM t INNER JOIN i USING(id) >> WHERE LIKELIHOOD(i.minX>=-81.08 ..., 0.999) -- 0.999 >> AND LIKELIHOOD(t.x=3, 0.001); -- 0.001 >> >> SELECT * FROM t INNER JOIN i USING(id) >> WHERE LIKELIHOOD(i.minX>=-81.08 ..., 0.001) -- 0.001 >> AND LIKELIHOOD(t.x=3, 0.999); -- 0.999 > > Sorry, this is not what I meant.
Seems like I didn't get the original question correctly, then. > The original question was about manually removing the R-tree search > depending on the spatial window. So, do you have an example where > the query plan changes due to a difference in *only* the likelihood > of the R-tree search expression? No. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
