Documentation Source Text

<li>Take into account WHERE clause terms that cannot be used with indices.
<li>Estimate the sizes of table and index rows and use the smallest applicable B-Tree
    for full scans and "count(*)" operations.
</ul>
<li>Added support for [SQLITE_ENABLE_STAT4]
<li>Added support for "sz=NNN" parameters at the end of sqlite_stat1.stat fields
    used to specify the average length in bytes for table and index rows.
<li>Changed the [index_list pragma] so that it shows the estimated size of index
    rows and so that it shows a new row for the PRIMARY KEY index that gives the
    estimated size of table rows.
<li>Avoid running foreign-key constraint checks on an UPDATE if none of the
    modified columns are associated with foreign keys.
<li>Added the [SQLITE_MINIMUM_FILE_DESCRIPTOR] compile-time option
<li>Added the win32-longpath VFS on windows.
<li>The [Date And Time Functions] are enhanced so that the current time
    (ex: julianday('now')) is always the same for multiple function invocations
    within the same [sqlite3_step()] call.

<li>Take into account WHERE clause terms that cannot be used with indices.
<li>Estimate the sizes of table and index rows and use the smallest applicable B-Tree
    for full scans and "count(*)" operations.
</ul>
<li>Added support for [SQLITE_ENABLE_STAT4]
<li>Added support for "sz=NNN" parameters at the end of sqlite_stat1.stat fields
    used to specify the average length in bytes for table and index rows.



<li>Avoid running foreign-key constraint checks on an UPDATE if none of the
    modified columns are associated with foreign keys.
<li>Added the [SQLITE_MINIMUM_FILE_DESCRIPTOR] compile-time option
<li>Added the win32-longpath VFS on windows.
<li>The [Date And Time Functions] are enhanced so that the current time
    (ex: julianday('now')) is always the same for multiple function invocations
    within the same [sqlite3_step()] call.

    table. ^The third column of output is the name of the column being indexed.
    </p>
}

Pragma index_list {
    <p>^(<b>PRAGMA index_list(</b><i>table-name</i><b>);</b></p>
    <p>This pragma returns one row for each index associated with the
    given table.)^   ^The original table with its rowid key is considered
    an index with a NULL name for the purposes of this pragma.
    ^Columns of the result set include the
    index name, a flag to indicate whether or not the index is UNIQUE, and
    an estimate of the number of bytes in each row of the index.
    </p>
}











Pragma page_count {
    <p>^(<b>PRAGMA page_count;</b></p>
    <p>Return the total number of pages in the database file.</p>)^
}

Pragma table_info {

    table. ^The third column of output is the name of the column being indexed.
    </p>
}

Pragma index_list {
    <p>^(<b>PRAGMA index_list(</b><i>table-name</i><b>);</b></p>
    <p>This pragma returns one row for each index associated with the
    given table.)^

    ^Columns of the result set include the
    index name and a flag to indicate whether or not the index is UNIQUE.

    </p>
}

Pragma stats {
    <p>^(<b>PRAGMA stats;</b>)^ </p>
    <p>This pragma returns auxiliary information about tables and
    indices.  The returned information is used during testing to help
    verify that the query planner is operating correctly.  The format
    and meaning of this pragma will likely change from one point release
    to the next. Because of its volatility, applications should avoid
    using this pragma.</p>
}

Pragma page_count {
    <p>^(<b>PRAGMA page_count;</b></p>
    <p>Return the total number of pages in the database file.</p>)^
}

Pragma table_info {