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 | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
d95d0313c447f5baeabdb17284d86063 |
| User & Date: | drh 2014-10-24 19:28:09 |
| 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 [2326c258] Incorrect result on a LEFT JOIN with an ORDER BY. (artifact: f6a379b6 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: b9ad601e 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: d95d0313 user: drh tags: trunk) | |
| 15:26 | Honor a high likelihood() on range constraints. (check-in: 401235ed 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.