Artifact
d299d7a19853463dac418de0d97f2dd9cb4ddb495a45c93364e2daee109ba0ef:
- File
src/vdbeInt.h
-
2018-06-05 20:45:20
— part of check-in
[6bf251af]
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
[09fffbdf]
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)