I would appreciate any donations. Wishlist or send e-mail type donations to maekawa AT daemon-systems.org.

Thank you.


SQLITE_STMTSTATUS_FULLSCAN_STEP(3)                    Library Functions Manual

NAME
     SQLITE_STMTSTATUS_FULLSCAN_STEP, SQLITE_STMTSTATUS_SORT,
     SQLITE_STMTSTATUS_AUTOINDEX, SQLITE_STMTSTATUS_VM_STEP - Status
     Parameters for prepared statements

SYNOPSIS
     #define SQLITE_STMTSTATUS_FULLSCAN_STEP
     #define SQLITE_STMTSTATUS_SORT
     #define SQLITE_STMTSTATUS_AUTOINDEX
     #define SQLITE_STMTSTATUS_VM_STEP

DESCRIPTION
     These preprocessor macros define integer codes that name counter values
     associated with the sqlite3_stmt_status() interface.  The meanings of the
     various counters are as follows:

     SQLITE_STMTSTATUS_FULLSCAN_STEP
             This is the number of times that SQLite has stepped forward in a
             table as part of a full table scan.  Large numbers for this
             counter may indicate opportunities for performance improvement
             through careful use of indices.

     SQLITE_STMTSTATUS_SORT
             This is the number of sort operations that have occurred.  A non-
             zero value in this counter may indicate an opportunity to
             improvement performance through careful use of indices.

     SQLITE_STMTSTATUS_AUTOINDEX
             This is the number of rows inserted into transient indices that
             were created automatically in order to help joins run faster.  A
             non-zero value in this counter may indicate an opportunity to
             improvement performance by adding permanent indices that do not
             need to be reinitialized each time the statement is run.

     SQLITE_STMTSTATUS_VM_STEP
             This is the number of virtual machine operations executed by the
             prepared statement if that number is less than or equal to
             2147483647.  The number of virtual machine operations can be used
             as a proxy for the total work done by the prepared statement.  If
             the number of virtual machine operations exceeds 2147483647 then
             the value returned by this statement status code is undefined.

SEE ALSO
     sqlite3_stmt_status(3)

NetBSD 8.0                      March 11, 2017                      NetBSD 8.0