Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix a typo in the documentation for ANALYZE. |
|---|---|
| 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 |
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 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 must 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
|
| |
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
|