]> git.ipfire.org Git - thirdparty/sqlite.git/commit
The IN-early-out optimization: When doing a look-up on a multi-column index
authordrh <drh@noemail.net>
Thu, 7 Jun 2018 18:13:49 +0000 (18:13 +0000)
committerdrh <drh@noemail.net>
Thu, 7 Jun 2018 18:13:49 +0000 (18:13 +0000)
commit83193d0133328a28dbd4d4bbd1f9747158d253a2
tree22a01737f468f6ba6b65fd233043d3c7cc52d959
parent3c49eaf4be865f4f9a092073b7609bb69a06ee51
parentcf025a8c18590ea3b11a160cc9d2a1ba53631efe
The IN-early-out optimization:  When doing a look-up on a multi-column index
and an IN operator is used on a column other than the left-most column, then
if no rows match against the first IN value, check to make sure there exist
rows that match the columns to the right before continuing with the next IN
value.

FossilOrigin-Name: 09fffbdf9f2f6ce31a22d5a6df7a45f19a16628da622f12d6e33171cce09fb21
manifest
manifest.uuid