> On Feb 18, 2019, at 10:23 AM, Charles Leifer <colei...@gmail.com> wrote: > > Thanks for the explanation. So does this mean that two identical queries > can have completely different query plans depending on whether they use a > parameters vs literal values embedded in the SQL string? >
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). _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users