/ Timeline
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Parents and children of check-in [d7bb79ed]

2017-04-29
20:53
Automatically transfer terms from the HAVING clause to the WHERE clause of an aggregate query in cases where the result of evaluating the term depends only one one or more of the GROUP BY expressions (and on no other inputs). check-in: 5375a3ce user: dan tags: having-where-optimization
18:02
Improvements to opcode documentation in the bytecode engine. No changes to code. check-in: e54c9f8d user: drh tags: trunk
15:27
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. check-in: d7bb79ed user: drh tags: trunk
14:56
Minor size and performance improvements to the push-down optimization. Closed-Leaf check-in: 91dfb61a user: drh tags: pushdown-optimization
2017-04-26
17:21
Add new test file cachespill.test. check-in: 2d0b6431 user: dan tags: trunk