SQLite Forum

Request for comment: New ANALYZE syntax
Login
A "danger" with `RESTRICT` is that it suggests, well, _restriction_... if future parameters/options are unknown, you might end up with something like `ANALYZE main.table RESTRICT VERBOSE` or `ANALYZE main.table RESTRICT ALL_LEVELS` where the option _widens_ rather than restricts the analysis. `WITH` or `USING` don't (to me) carry that connotation.