/ Timeline
Login

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

2011-02-04
06:36
Merge the stat2 query planner enhancements into the trunk. check-in: 499edcbc8a user: drh tags: trunk
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
15:11
Change the cost estimator in the query planner to take into account the logN rowid lookup cost when going from an index to a table. check-in: b442525b0b user: drh tags: stat2-enhancement
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: 5d5bddd290 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: c82cb9c028 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: fd3977a27a user: drh tags: stat2-enhancement
14:37
Add the ability to use indices when a range contraint is bounded on the lower end by NULL. check-in: f73a167b43 user: drh tags: stat2-enhancement
2011-01-20
20:36
Update ANALYZE test cases to check out the use of histograms for equality constraints. check-in: c7b59afaf0 user: drh tags: stat2-enhancement
16:52
Use histogram data to improve the row-count estimates on equality constraints. check-in: 6bfc5c69eb user: drh tags: stat2-enhancement
02:56
The first of a planned series of enhancements to the query planner that enable it to make better use of sqlite_stat2 histograms when the table has many repeated values. check-in: 2cd374cd23 user: drh tags: stat2-enhancement
2011-01-19
21:58
Comment improvements in pcache1.c. No changes to code. check-in: 9660a0a225 user: drh tags: trunk