/ Timeline
Login

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

2017-07-10
17:00
When multiple constraints need to be evaluated for a row, do any constraints that involve correlated subqueries last. Hence, the priority is index-covered constraints first, correlated subquery constraints last, and all others in the middle. This is a follow-on and improvement to the push-down optimization of check-in [d7bb79ed]. check-in: c4cb90487f user: drh tags: trunk
16:38
Additional debugging Noop-comment in the constraint generator when wheretrace is enabled. Closed-Leaf check-in: 0ca7474f05 user: drh tags: defer-where-subqueries
15:26
Small performance optimization in sqlite3WhereExprUsage(). check-in: 38edc6770e user: drh tags: defer-where-subqueries
15:17
Fix another problem on this branch. check-in: a4fc98113a user: dan tags: defer-where-subqueries
14:39
Fix a problem causing non-covered WHERE terms to be evaluated before covered WHERE terms. check-in: 7d3cb39f60 user: dan tags: defer-where-subqueries
14:33
When testing non-indexed WHERE constraints, test those that involve correlated sub-queries last of all. This increases the chances of not having to run the sub-query at all. check-in: 1f9c1f359e user: dan tags: defer-where-subqueries
13:24
For sqlite3TreeView() debugging output, show the Expr.flags field on scalar subqueries. check-in: dc857a96b0 user: drh tags: trunk