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