/ File History
Login

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