StatementStatusCode Enumeration |
Namespace: SQLitePCL.prettyAssembly: SQLitePCL.pretty (in SQLitePCL.pretty.dll) Version: 1.0.0.0 (1.0.0)
Syntax public enum StatementStatusCode
Members
| Member name | Value | Description |
---|
| FullscanStep | 1 |
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.
|
| Sort | 2 |
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.
|
| AutoIndex | 3 |
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.
|
| VirtualMachineStep | 4 |
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