Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Fix a typo in the documentation for ANALYZE. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | branch-3.28 |
Files: | files | file ages | folders |
SHA3-256: |
0917d5f9d68fd2d6e9071f96f51de63d |
User & Date: | drh 2019-05-10 11:38:24.156 |
Context
2019-05-21
| ||
02:48 | Use the <!DOCTYPE html> header on all pages. (check-in: b5aef4cfad user: drh tags: branch-3.28) | |
2019-05-10
| ||
11:38 | Fix a typo in the documentation for ANALYZE. (check-in: 0917d5f9d6 user: drh tags: branch-3.28) | |
2019-05-02
| ||
16:25 | Attempt to clarify the scope of when UPSERT processing applies. (check-in: aae75b6ac2 user: drh tags: branch-3.28) | |
Changes
Changes to pages/lang.in.
︙ | ︙ | |||
483 484 485 486 487 488 489 | In most cases [PRAGMA optimize] will not run ANALYZE, but it will occasionally do so either for tables that have never before been analyzed, or for tables that have grown significantly since they were last analyzed.</p> <p>Since the actions of [PRAGMA optimize] are determined to some extent by prior queries that have been evaluated on the same database connection, it is recommended that [PRAGMA optimize] be deferred until the database connection | | | 483 484 485 486 487 488 489 490 491 492 493 494 495 496 497 | In most cases [PRAGMA optimize] will not run ANALYZE, but it will occasionally do so either for tables that have never before been analyzed, or for tables that have grown significantly since they were last analyzed.</p> <p>Since the actions of [PRAGMA optimize] are determined to some extent by prior queries that have been evaluated on the same database connection, it is recommended that [PRAGMA optimize] be deferred until the database connection is closing and has thus had an opportunity to accumulate as much usage information as possible. It is also reasonable to set a timer to run [PRAGMA optimize] every few hours, or every few days, for database connections that stay open for a long time.</p> <p>Applications that desire more control can run [PRAGMA optimize(0x03)] to obtain a list of ANALYZE commands that SQLite thinks are appropriate to run, but without actually running those commands. If the returned set is |
︙ | ︙ |