Simon, I appreciate that, but your comment seems to contradict the example I provided, as well as the example Dr. Hipp provided. Am I misunderstanding?
On Mon, Feb 18, 2019, 9:44 AM Simon Slavin <[email protected] wrote: > On 18 Feb 2019, at 3:23pm, Charles Leifer <[email protected]> wrote: > > > At some point before actually executing the query I'm calling > > sqlite3_bind...() to set the value of the parameter placeholder. > Presumably SQLite would know at that point that a certain index is usable > (or in this case, that a certain constraint is relevant)? > > SQLite knows before then. The SQLite query optimizer does not do > algebra. It does its job without knowing what values you will plug into > the parameters. > > Indexes are chosen by looking at how you are comparing certain columns: > whether you compare a column using "<" or ">" or "=" or some other > comparator. The values you're comparing them with are ignored. > > Simon. > _______________________________________________ > sqlite-users mailing list > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
