/ Check-in [defaf0d9]
Login

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

Overview
Comment:Further refinements to table order selection on join query planning.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: defaf0d99a807027f8883bf821b6482025f9f54e
User & Date: drh 2010-04-15 01:04:54
References
2010-08-04
18:43 New ticket [13f033c8] Performance regression. artifact: 07edd854 user: drh
Context
2010-04-15
13:29
The query planner fix of check-in [33b1f584ef] should have been on the trunk. check-in: f538d759 user: drh tags: trunk
02:37
Bring over the recent query planner enhancements from the trunk. check-in: 82969f27 user: drh tags: wal
01:04
Further refinements to table order selection on join query planning. check-in: defaf0d9 user: drh tags: trunk
2010-04-14
19:01
The query planner uses non-indexable WHERE clause terms to reduce the estimated number of output rows, then uses the estimated number of output rows as a tie-breaker when choosing table order. check-in: b87cb0c2 user: drh tags: trunk
Changes
Unified Diffs Side-by-Side Diffs Patch

Changes to src/where.c.

Changes to test/select2.test.

Changes to test/triggerA.test.

Changes to test/where3.test.

Changes to test/where7.test.

Changes to test/where8.test.