/ Check-in [d95d0313]
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 | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: d95d0313c447f5baeabdb17284d8606331ab7d49
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
Unified Diffs Side-by-Side Diffs 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.