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. 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? Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
