Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
13 check-ins related to "stat2-enhancement"
2011-02-04
| ||
06:36 | Merge the stat2 query planner enhancements into the trunk. (check-in: 499edcbc user: drh tags: trunk) | |
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) | |
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: b442525b 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: 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) | |
14:37 | Add the ability to use indices when a range contraint is bounded on the lower end by NULL. (check-in: f73a167b 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: c7b59afa user: drh tags: stat2-enhancement) | |
16:52 | Use histogram data to improve the row-count estimates on equality constraints. (check-in: 6bfc5c69 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: 2cd374cd user: drh tags: stat2-enhancement) | |
2011-01-19
| ||
21:58 | Comment improvements in pcache1.c. No changes to code. (check-in: 9660a0a2 user: drh tags: trunk) | |