SQLite

Check-in [d95d0313c4]
Login

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: d95d0313c447f5baeabdb17284d8606331ab7d49
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
Unified Diff Side-by-Side Diff Patch
Changes to src/expr.c.
Changes to src/resolve.c.
Changes to src/sqliteInt.h.
Changes to src/where.c.
Added test/autoindex4.test.