|
Revision tags: release, version-3.50.2, version-3.50.1, major-release, version-3.50.0, version-3.49.2, patch-release, version-3.44.4, version-3.49.1, version-3.49.0, major-relase, relase, version-3.48.0, version-3.47.2, version-3.47.1, version-3.47.0, version-3.46.1, version-3.46.0, version-3.45.3, version-3.44.3, version-3.45.2, version-3.45.1, vesion-3.45.1, version-3.45.0, version-3.44.2, version-3.44.1, version-3.44.0, version-3.43.2, version-3.43.1, version-3.43.0, version-3.42.0, version-3.41.2, version-3.41.1, version-3.41.0, version-3.40.1, version-3.40.0, version-3.39.4, version-3.39.3, version-3.39.2, version-3.39.1, version-3.39.0, version-3.38.5, version-3.38.4, relese, version-3.38.3, version-3.38.2, version-3.38.1, version-3.38.0, version-3.37.2, version-3.37.1, version-3.37.0, version-3.36.0, version-3.35.5, version-3.35.4, version-3.35.3, same-as-3.35.3, version-3.35.2, version-3.35.1, version-3.35.0, patch, version-3.34.1, version-3.34.0, version-3.33.0, version-3.32.3, version-3.32.2, version-3.32.1, version-3.32.0, version-3.31.1, version-3.31.0, version-3.30.1, version-3.30.0 |
|
| #
175b8f06 |
| 08-Aug-2019 |
drh <[email protected]> |
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.
FossilOrigi
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.
FossilOrigin-Name: 1e17ea2fd1df4ad49138c787c8fe3207dd0c25c93f9001d52a9b69f8c12e841c
show more ...
|
|
Revision tags: version-3.29.0, version-3.28.0, version-3.27.2, version-3.27.1, version-3.27.0, version-3.26.0, version-3.25.3, version-3.25.2, version-3.25.1, version-3.25.0, version-3.24.0, version-3.23.2, version-3.23.1, version-3.23.0, version-3.22.0, version-3.21.0, version-3.20.1, version-3.19.4, version-3.20.0, version-3.18.2, version-3.18.1, version-3.19.3, version-3.19.2, version-3.19.1, version-3.19.0, version-3.18.0, version-3.17.0, version-3.16.2, version-3.16.1, version-3.16.0, version-3.15.2, version-3.15.1, version-3.15.0, version-3.14.2, version-3.14.1, version-3.14.0, version-3.13.0, version-3.12.2, version-3.12.1, version-3.9.3, version-3.12.0, version-3.11.1, version-3.11.0, version-3.10.2, version-3.10.1, version-3.10.0, version-3.9.2, version-3.9.1, version-3.9.0, version-3.8.11.1, version-3.8.11, version-3.8.10.2, version-3.8.10.1, version-3.8.10, version-3.8.9, version-3.8.8.3, version-3.8.8.2, version-3.8.8.1, version-3.8.8, version-3.8.7.4, version-3.8.7.3, version-3.8.7.2, version-3.8.7.1, version-3.8.6.1, version-3.8.7, version-3.8.6, version-3.8.5, version-3.8.4.3, version-3.8.4.2, version-3.8.4.1, version-3.8.4, version-3.8.3.1, version-3.8.3, version-3.8.2, version-3.8.1, version-3.8.0.2, version-3.8.0.1, version-3.8.0 |
|
| #
8ad169ab |
| 12-Aug-2013 |
dan <[email protected]> |
If ENABLE_STAT3 is defined but ENABLE_STAT4 is not, have ANALYZE create and populate the sqlite_stat3 table instead of sqlite_stat4.
FossilOrigin-Name: cca8bf4372ab7a0258aa5c9397818415c6cf0abf
|
| #
dd6e1f19 |
| 10-Aug-2013 |
dan <[email protected]> |
Add the rowid field to the end of sample records stored in the sqlite_stat4 table.
FossilOrigin-Name: 3a5e8ab7ddbe1d943b35ef329fe4e5a1bfdb0d9d
|
| #
f52bb8d3 |
| 03-Aug-2013 |
dan <[email protected]> |
Begin adding experimental sqlite_stat4 table. This commit is buggy.
FossilOrigin-Name: 2beea303a1d609cd2ff252412c50b966b9e5e8f1
|
| #
8636e9c5 |
| 11-Jun-2013 |
drh <[email protected]> |
Handle virtual tables correctly when using logarithmic costs. Fixes
to test cases.
FossilOrigin-Name: e612664aa2e24ed5e222be2c7fe16e210ac9bded
|
|
Revision tags: version-3.7.17, version-3.7.16.2, version-3.7.16.1, version-3.7.16, version-3.7.15.2, version-3.7.15.1, version-3.7.15, version-3.7.14.1, version-3.7.14, version-3.7.13, version-3.7.12.1, version-3.7.12, mountain-lion, version-3.7.11, version-3.7.10, version-3.7.9, version-3.7.8 |
|
| #
4e50c5ec |
| 13-Aug-2011 |
drh <[email protected]> |
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.
FossilOrigin-Name: 89b2f70884ca
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.
FossilOrigin-Name: 89b2f70884cad0abdf4c66cb64ecddb2820ded74
show more ...
|
|
Revision tags: version-3.7.7.1, version-3.7.7, version-3.7.6.3, version-3.7.6.2, version-3.7.6.1, version-3.7.6 |
|
| #
ea6dc445 |
| 08-Apr-2011 |
drh <[email protected]> |
Always make sure the left-hand side of the IS NOT NULL operator is a
smiple column, not a general expression, before applying the IS NOT NULL
query optimization.
FossilOrigin-Name: 543f75a6abe3aa4f4
Always make sure the left-hand side of the IS NOT NULL operator is a
smiple column, not a general expression, before applying the IS NOT NULL
query optimization.
FossilOrigin-Name: 543f75a6abe3aa4f49df43e71a462702d40b3251
show more ...
|
| #
1f9c7663 |
| 17-Mar-2011 |
drh <[email protected]> |
Enhances to the query planner such that "x IS NULL" constraints take the
STAT2 statistics into account, just like "x=VALUE" constraints.
FossilOrigin-Name: 2353176811f752a16c1f2351a3d3431919b062a9
|
| #
37722067 |
| 10-Feb-2011 |
drh <[email protected]> |
Refactor the cost function in the query planner. Give extra cost (thus
reduce likelihood of selection) to full table scans.
FossilOrigin-Name: 878da276ebf643b716ddd650d4d0ca3595fe5bf2
|
|
Revision tags: version-3.7.5 |
|
| #
40ad34c6 |
| 28-Jan-2011 |
drh <[email protected]> |
Reactivate the analyze5.test script.
FossilOrigin-Name: a2a9f6401c927f6259cda3ba35219cabef24e84d
|
| #
fc449136 |
| 24-Jan-2011 |
drh <[email protected]> |
Restructuring and generalizing analyze5.test. The whole script is
currently disabled and will need to be reenabled prior to merging with trunk.
FossilOrigin-Name: 31fcc7067bd76da4bf19232811b90cf8b
Restructuring and generalizing analyze5.test. The whole script is
currently disabled and will need to be reenabled prior to merging with trunk.
FossilOrigin-Name: 31fcc7067bd76da4bf19232811b90cf8b76eed74
show more ...
|
| #
5ac06071 |
| 21-Jan-2011 |
drh <[email protected]> |
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.
FossilOrigin-Name: c82cb9c028b3ba5463ae50c301
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.
FossilOrigin-Name: c82cb9c028b3ba5463ae50c30196dbf157a7a305
show more ...
|
| #
3851b74a |
| 20-Jan-2011 |
drh <[email protected]> |
Update ANALYZE test cases to check out the use of histograms for equality
constraints.
FossilOrigin-Name: c7b59afaf0c0bf85dbaf0a122cc8d65fca93680f
|
| #
82759754 |
| 20-Jan-2011 |
drh <[email protected]> |
Use histogram data to improve the row-count estimates on equality constraints.
FossilOrigin-Name: 6bfc5c69eb22938972bbf4e60179952dc215f770
|
| #
e847d324 |
| 20-Jan-2011 |
drh <[email protected]> |
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.
FossilOrigin-Name: 2cd374cd23
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.
FossilOrigin-Name: 2cd374cd23fa2fd38f49090d6eeb9b1e521d51d5
show more ...
|