Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
|
2019-08-08
| ||
| 15:24 | [fa513195] part of check-in [1e17ea2f] Remove support for STAT3. The sqlite_stat3 tables are ignored, if they exist. STAT4 continues to work as it always has, and as it is a superset of STAT3 is the recommended replacement. (check-in: [1e17ea2f] user: drh branch: omit-stat3, size: 7874) | |
|
2013-08-12
| ||
| 20:14 | [765c4e28] part of check-in [cca8bf43] If ENABLE_STAT3 is defined but ENABLE_STAT4 is not, have ANALYZE create and populate the sqlite_stat3 table instead of sqlite_stat4. (check-in: [cca8bf43] user: dan branch: sqlite_stat4, size: 8331) | |
|
2013-08-10
| ||
| 19:08 | [96ac783a] part of check-in [3a5e8ab7] Add the rowid field to the end of sample records stored in the sqlite_stat4 table. (check-in: [3a5e8ab7] user: dan branch: sqlite_stat4, size: 7854) | |
|
2013-08-03
| ||
| 20:24 | [e3eece09] part of check-in [2beea303] Begin adding experimental sqlite_stat4 table. This commit is buggy. (check-in: [2beea303] user: dan branch: sqlite_stat4, size: 7783) | |
|
2013-06-11
| ||
| 01:50 | [3e57f192] part of check-in [e612664a] Handle virtual tables correctly when using logarithmic costs. Fixes to test cases. (check-in: [e612664a] user: drh branch: nextgen-query-plan-logcost, size: 7619) | |
|
2011-08-13
| ||
| 19:35 | [71335466] part of check-in [89b2f708] Further testing and bug fixing for sqlite_stat3. Added the Index.avgEq field to index statistics. Fixed several problems in the query planner associated with stat3. (check-in: [89b2f708] user: drh branch: stat3-enhancement, size: 7542) | |
|
2011-08-03
| ||
| 01:07 | [f6c25001] part of check-in [c8ba8855] Adjust the output row estimating logic when using STAT2. (check-in: [c8ba8855] user: drh branch: query-planner-tweaks, size: 8047) | |
|
2011-04-08
| ||
| 21:35 | [1de8d66b] part of check-in [543f75a6] Always make sure the left-hand side of the IS NOT NULL operator is a simple column, not a general expression, before applying the IS NOT NULL query optimization. (check-in: [543f75a6] user: drh branch: trunk, size: 8047) | |
|
2011-03-17
| ||
| 01:34 | [adc89b92] part of check-in [23531768] Enhances to the query planner such that "x IS NULL" constraints take the STAT2 statistics into account, just like "x=VALUE" constraints. (check-in: [23531768] user: drh branch: trunk, size: 7945) | |
|
2011-02-10
| ||
| 00:08 | [0618d2fe] part of check-in [878da276] Refactor the cost function in the query planner. Give extra cost (thus reduce likelihood of selection) to full table scans. (check-in: [878da276] user: drh branch: trunk, size: 6583) | |
|
2011-01-28
| ||
| 03:13 | [18659612] part of check-in [a2a9f640] Reactivate the analyze5.test script. (check-in: [a2a9f640] user: drh branch: stat2-enhancement, size: 6583) | |
|
2011-01-24
| ||
| 17:46 | [12df6def] part of check-in [31fcc706] 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 branch: stat2-enhancement, size: 11298) | |
|
2011-01-21
| ||
| 18:18 | [c19fe600] part of check-in [c82cb9c0] 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 branch: stat2-enhancement, size: 9901) | |
|
2011-01-20
| ||
| 20:36 | [b2139886] part of check-in [c7b59afa] Update ANALYZE test cases to check out the use of histograms for equality constraints. (check-in: [c7b59afa] user: drh branch: stat2-enhancement, size: 8978) | |
| 16:52 | [b6bd2e4f] part of check-in [6bfc5c69] Use histogram data to improve the row-count estimates on equality constraints. (check-in: [6bfc5c69] user: drh branch: stat2-enhancement, size: 6888) | |
| 02:56 | Added: [18987796] part of check-in [2cd374cd] 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 branch: stat2-enhancement, size: 6560) | |