SQLite

Check-in [4847c6cb71]
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
Timelines: family | ancestors | descendants | both | stat2-enhancement
Files: files | file ages | folders
SHA1: 4847c6cb71423248b186ab7842b97c83e2f5fefd
User & Date: drh 2011-01-28 01:57:41.767
Context
2011-01-28
03:13
Reactivate the analyze5.test script. (Closed-Leaf check-in: a2a9f6401c 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: 4847c6cb71 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: 31fcc7067b user: drh tags: stat2-enhancement)
Changes
Unified Diff Side-by-Side Diff 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.