]> git.ipfire.org Git - thirdparty/sqlite.git/commit
Evaluate WHERE clause terms that reference only the index before evaluating
authordrh <drh@noemail.net>
Sat, 29 Apr 2017 15:27:04 +0000 (15:27 +0000)
committerdrh <drh@noemail.net>
Sat, 29 Apr 2017 15:27:04 +0000 (15:27 +0000)
commitbc43995f99d3f15aa3cb056068ee7e6b7ca40029
tree02faa65dece2d3a9376b4817d08bec005ad5a8b9
parent4b1736957983f4248890c79efe693a77e1945418
parent6ab3eb5d0eade5492508823c7f9405fc1a560987
Evaluate WHERE clause terms that reference only the index before evaluating
terms that require the table, and thereby avoid seeking the table row if
index terms are false.
This is called the "push-down" optimization in the MySQL world, we are told.

FossilOrigin-Name: d7bb79ed3a40419d143fbe35c310e51fe7b384a22f082a61ad788671d2d33ee0
manifest
manifest.uuid