On Mon, Feb 18, 2019 at 4:38 PM Richard Damon <rich...@damon-family.org> wrote:
> Remember the query plan is determined when that statement is compiled, > which is BEFORE you do the binding of the parameters, so the plan can not > depend on the value of parameters. There is no later attempt to optimize > once the values are known, as in general, this isn’t apt to help (you have > one case where it could, but to help that case, you would need to hurt a > lot of other more common cases). > Actually, "bind peeking" to find a more optimal plan does often help. Otherwise "non-lite" RDBMS wouldn't do it. The fact SQLite does not implement, does not mean it's not a useful thing to do. --DD _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
