Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Enhance the automatic index logic so that it creates a partial index when doing so gives the same answer for less work. UPDATE: This change introduced a bug described by ticket [2326c258d02ead33]. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
d95d0313c447f5baeabdb17284d86063 |
User & Date: | drh 2014-10-24 19:28:09.216 |
Original Comment: | Enhance the automatic index logic so that it creates a partial index when doing so gives the same answer for less work. |
References
2015-02-24
| ||
15:30 | • New ticket [2326c258d0] Incorrect result on a LEFT JOIN with an ORDER BY. (artifact: f6a379b6db user: drh) | |
Context
2014-10-25
| ||
12:28 | Do not use virtual (and hence redundant) WHERE-clause terms to restrict the content of a automatic partial index. Show when an automatic partial index is used in the EXPLAIN QUERY PLAN output. (check-in: b9ad601eab user: drh tags: trunk) | |
2014-10-24
| ||
19:28 | Enhance the automatic index logic so that it creates a partial index when doing so gives the same answer for less work. UPDATE: This change introduced a bug described by ticket [2326c258d02ead33]. (check-in: d95d0313c4 user: drh tags: trunk) | |
15:26 | Honor a high likelihood() on range constraints. (check-in: 401235edf4 user: drh tags: trunk) | |
Changes
Changes to src/expr.c.
Changes to src/resolve.c.
Changes to src/sqliteInt.h.
Changes to src/where.c.
Added test/autoindex4.test.