/ Check-in [4847c6cb]
Login

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

Overview
Comment:Change the weighting of binary searches on tables to 1/10th the cost of a search on an index. Change the assumed reduction in search space from a indexed range constraint from 1/3rd to 1/4th. Do not let the estimated number of rows drop below 1.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | stat2-enhancement
Files: files | file ages | folders
SHA1: 4847c6cb71423248b186ab7842b97c83e2f5fefd
User & Date: drh 2011-01-28 01:57:41
Context
2011-01-28
03:13
Reactivate the analyze5.test script. Closed-Leaf check-in: a2a9f640 user: drh tags: stat2-enhancement
01:57
Change the weighting of binary searches on tables to 1/10th the cost of a search on an index. Change the assumed reduction in search space from a indexed range constraint from 1/3rd to 1/4th. Do not let the estimated number of rows drop below 1. check-in: 4847c6cb user: drh tags: stat2-enhancement
2011-01-24
17:46
Restructuring and generalizing analyze5.test. The whole script is currently disabled and will need to be reenabled prior to merging with trunk. check-in: 31fcc706 user: drh tags: stat2-enhancement
Changes
Unified Diffs Side-by-Side Diffs Patch

Changes to src/where.c.

Changes to test/analyze2.test.

Changes to test/analyze3.test.

Changes to test/e_createtable.test.

Changes to test/eqp.test.

Changes to test/indexedby.test.

Changes to test/like.test.

Changes to test/minmax3.test.

Changes to test/where3.test.

Changes to test/where9.test.