]> git.ipfire.org Git - thirdparty/sqlite.git/commit
When doing an UPDATE or DELETE using a multi-column index where only a few
authordrh <drh@noemail.net>
Fri, 14 Aug 2020 21:51:02 +0000 (21:51 +0000)
committerdrh <drh@noemail.net>
Fri, 14 Aug 2020 21:51:02 +0000 (21:51 +0000)
commit861889e4f8e63e5f9f7508419fe01fe5de8ccb49
tree4fee42358d8588e2402bdffcbc26f29ef0bc023d
parenta3d6d6a93fc87eba1ccb52d6f72d79ab6b378f69
parentf8556d0106e57c1599a6e4171a9e5f3ed1e81822
When doing an UPDATE or DELETE using a multi-column index where only a few
of the earlier columns of the index are useful for the index lookup,
postpone doing the main table seek until after all WHERE clause constraints
have been evaluated, in case those constraints can be covered by unused
later terms of the index, thus avoiding unnecessary main table seeks.

FossilOrigin-Name: 7fee0b1075d622835dc6828c061be516102da9e2809f52d9ab7c4bbef7dfb871
manifest
manifest.uuid