/ Check-in [c82cb9c0]
Login

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

Overview
Comment:Adjustments to the result row estimator for the IN operator so that it gives the same estimates as the equivalent OR operator. Test cases for the same.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | stat2-enhancement
Files: files | file ages | folders
SHA1: c82cb9c028b3ba5463ae50c30196dbf157a7a305
User & Date: drh 2011-01-21 18:18:13
Context
2011-01-22
00:10
Add the ability to use indices for constraints of the form "x IS NOT NULL" when sqlite_stat2 is available and most entries for column x are NULL. check-in: 5d5bddd2 user: drh tags: stat2-enhancement
2011-01-21
18:18
Adjustments to the result row estimator for the IN operator so that it gives the same estimates as the equivalent OR operator. Test cases for the same. check-in: c82cb9c0 user: drh tags: stat2-enhancement
16:27
Make use of histogram data to make better estimates for the number of rows that will be returned from "x IN (v1,v2,v3,...)" constraints. check-in: fd3977a2 user: drh tags: stat2-enhancement
Changes
Unified Diffs Side-by-Side Diffs Patch

Changes to src/where.c.

Changes to test/analyze5.test.