SQLite Forum

Runtime of and opcode counts of ANALYZE
Login
What's the difference between the output if you run these commands in the sqlite3 shell on (a) the 20GB/7 minutes to analyze DB and (b) the 18GB/22 minutes to analyze DB?

```
.stats on
.timer on
ANALYZE;
```

(I guess also repeat this for `PRAGMA integrity_check(100)`)