diff options
| author | drh <> | 2024-02-20 12:48:00 +0000 |
|---|---|---|
| committer | drh <> | 2024-02-20 12:48:00 +0000 |
| commit | 68d92c4ad3342a97ae523574cb8e09d1043970a5 (patch) | |
| tree | 0f6ed269e065b93243259a7ea02a8ff9db3cf516 /src/build.c | |
| parent | e0a9935be1c506646566f6b7845eb381bb219e16 (diff) | |
| parent | 4189c44cff384341fb2a7780a7b5b35c734db9af (diff) | |
| download | sqlite-68d92c4ad3342a97ae523574cb8e09d1043970a5.tar.gz sqlite-68d92c4ad3342a97ae523574cb8e09d1043970a5.zip | |
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
Diffstat (limited to 'src/build.c')
| -rw-r--r-- | src/build.c | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/build.c b/src/build.c index cfa2c886c..15f8fe1d2 100644 --- a/src/build.c +++ b/src/build.c @@ -2923,11 +2923,11 @@ void sqlite3EndTable( /* Test for cycles in generated columns and illegal expressions ** in CHECK constraints and in DEFAULT clauses. */ if( p->tabFlags & TF_HasGenerated ){ - sqlite3VdbeAddOp4(v, OP_SqlExec, 1, 0, 0, + sqlite3VdbeAddOp4(v, OP_SqlExec, 0x0001, 0, 0, sqlite3MPrintf(db, "SELECT*FROM\"%w\".\"%w\"", db->aDb[iDb].zDbSName, p->zName), P4_DYNAMIC); } - sqlite3VdbeAddOp4(v, OP_SqlExec, 1, 0, 0, + sqlite3VdbeAddOp4(v, OP_SqlExec, 0x0001, 0, 0, sqlite3MPrintf(db, "PRAGMA \"%w\".integrity_check(%Q)", db->aDb[iDb].zDbSName, p->zName), P4_DYNAMIC); } |