2018-06-05 20:45:20
— part of check-in
[6bf251af43]
on branch multikey-opt-idea
— Add the OP_IfNoHope and OP_SeekHit opcodes used to reduce the number of
unnecessary sqlite3BtreeMovetoUnpacked() calls when checking for an early
exit on IN-operator loops. Futher optimizations are likely possible here.
(user:
drh
size: 24956)
2018-06-07 18:13:49
— part of check-in
[09fffbdf9f]
on branch trunk
— 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.
(user:
drh
size: 24956)