Documentation Source Text

Check-in [5eb8cc7380]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Fix requirements marks on ANALYZE documentation.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 5eb8cc7380cc3b6aa2deea344979a5743dec8e3a
User & Date: drh 2011-10-11 12:36:18.592
Context
2011-10-13
15:55
Change exit(1) to return(1) in the quick-start demo programs to avoid having to #include stdlib.h. (check-in: 4a03d52003 user: drh tags: trunk)
2011-10-11
12:36
Fix requirements marks on ANALYZE documentation. (check-in: 5eb8cc7380 user: drh tags: trunk)
2011-10-07
23:26
Update documentation for SQLITE_ENABLE_STAT3. (check-in: 4b78e06344 user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/lang.in.
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
or "3" changed to larger digits.</p>

<p> ^The [ALTER TABLE] command does
not work on the <b>sqlite_stat1</b> or <b>sqlite_stat3</b> tables,
but all the content of those tables can be queried using [SELECT]
and can be deleted, augmented, or modified using the [DELETE],
[INSERT], and [UPDATE] commands.
^The [DROP TABLE] command does work on <b>sqlite_stat1</b> and
<b>sqlite_stat3</b> as of SQLite version 3.7.9.
Appropriate care should be used when changing the content of the statistics
tables as invalid content can cause SQLite to select inefficient
query plans.  Generally speaking, one should not modify the content of
the statistics tables by any mechanism other than invoking the
ANALYZE command.</p>

<p> ^Statistics gathered by ANALYZE are <u>not</u> automatically updated as







|
|







208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
or "3" changed to larger digits.</p>

<p> ^The [ALTER TABLE] command does
not work on the <b>sqlite_stat1</b> or <b>sqlite_stat3</b> tables,
but all the content of those tables can be queried using [SELECT]
and can be deleted, augmented, or modified using the [DELETE],
[INSERT], and [UPDATE] commands.
^(The [DROP TABLE] command works on <b>sqlite_stat1</b> and
<b>sqlite_stat3</b> as of SQLite version 3.7.9.)^
Appropriate care should be used when changing the content of the statistics
tables as invalid content can cause SQLite to select inefficient
query plans.  Generally speaking, one should not modify the content of
the statistics tables by any mechanism other than invoking the
ANALYZE command.</p>

<p> ^Statistics gathered by ANALYZE are <u>not</u> automatically updated as