]> git.ipfire.org Git - thirdparty/sqlite.git/commit
Enhancements to PRAGMA optimize and ANALYZE. Add the 0x10000 flag to
authordrh <>
Tue, 20 Feb 2024 12:48:00 +0000 (12:48 +0000)
committerdrh <>
Tue, 20 Feb 2024 12:48:00 +0000 (12:48 +0000)
commit68d92c4ad3342a97ae523574cb8e09d1043970a5
tree0f6ed269e065b93243259a7ea02a8ff9db3cf516
parente0a9935be1c506646566f6b7845eb381bb219e16
parent4189c44cff384341fb2a7780a7b5b35c734db9af
Enhancements to PRAGMA optimize and ANALYZE.  Add the 0x10000 flag to
PRAGMA optimize.  ANALYZE now records zero-size partial indexes in the
sqlite_stat1 table.  PRAGMA optimize looks for both growth and shrinkage
in table sizes, and uses tighter bounds (10x rather than 25x) to trigger
a re-analyze.  PRAGMA optimize automatically uses are reasonable
analysis_limit to prevent excessive runtimes.

FossilOrigin-Name: 63ef234e88857a653fa3541e80d59802ceccb806ac8296e8bae79a385b7086f7
manifest
manifest.uuid