Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Profiling SQL Queries
(profile.html)
3. Complex Cases - Rows, Loops and Cycles
... transient) index on it, then uses that index to optimize
the join. All three of these steps - "MATERIALIZE v2", "CREATE AUTOMATIC
INDEX" and "SEARCH ... USING AUTOMATIC INDEX" have separate cycle counts.
The "rows" associated with the "CREATE AUTOMATIC INDEX" line ...
|
|
The Bytecode() And Tables_Used() Table-Valued Functions
(bytecodevtab.html)
2.1. Schema
... This will be "main" for the main database (the usual case), or "temp" for
TEMP tables and indexes, or the name assigned to attached databases by
the ATTACH statement.
name → The name of the table or index
wr &rarr ...
|
|
The SQLite Bytecode Engine
(opcode.html)
4. The Opcodes
... Compare this key value against
the index that P1 is currently pointing to, ignoring the PRIMARY KEY or
ROWID on the P1 index.
If the P1 index entry is less than or equal to the key value then jump
to ...
|
|
C API: Binding Values To Prepared Statements
(c3ref/bind_blob.html)
sqlite3_bind_blob(), sqlite3_bind_blob64(), sqlite3_bind_double(), sqlite3_bind_int(), sqlite3_bind_int64(), sqlite3_bind_null ...
... The leftmost SQL parameter has an index of 1. When the same named
SQL parameter is used more than once, second and subsequent
occurrences have the same index as the first occurrence.
The index for named parameters can be looked ...
|
|
The SQLite R*Tree Module
(rtree.html)
3.1. Creating An R*Tree Index
A new R*Tree index is created as follows:
CREATE VIRTUAL TABLE <name> USING rtree(<column-names>);
The <name> is the name your application chooses for the
R*Tree index and <column-names ...
|
|
C API: Run-Time Limit Categories
(c3ref/c_limit_attached.html)
SQLITE_LIMIT_LENGTH, SQLITE_LIMIT_SQL_LENGTH, SQLITE_LIMIT_COLUMN, SQLITE_LIMIT_EXPR_DEPTH, SQLITE_LIMIT_COMPOUND_SELECT, SQLITE_LIMIT_VDBE_OP ...
... SQLITE_LIMIT_COLUMN
The maximum number of columns in a table definition or in the
result set of a SELECT or the maximum number of columns in an index
or in an ORDER BY or GROUP BY clause.
SQLITE_LIMIT_EXPR_DEPTH
The maximum depth ...
|
|
SQLite FTS3 and FTS4 Extensions
(fts3.html)
5. Fts4aux - Direct Access to the Full-Text Index
As of version 3.7.6 (2011-04-12),
SQLite includes a new virtual table module called
"fts4aux", which can be used to inspect the full-text index of an existing
FTS table directly. Despite its name, fts4aux works just ...
|
|
ANALYZE
(lang_analyze.html)
... If the argument
is an index name, then only that one index is analyzed.
2. Recommended usage patterns
The use of ANALYZE is never required. However, if an application
makes complex queries that have many possible query plans, the query ...
|
|
List Of Virtual Tables
(vtablist.html)
2. Virtual Tables
... FTS3
A high-performance full-text search index.
FTS5
A higher-performance full-text search index
generate_series
A table-valued function returning a sequence of
integers, modeled after the table-valued function by the same
name in PostgreSQL.
json_each
A ...
|
|
ALTER TABLE
(lang_altertable.html)
... Use CREATE INDEX, CREATE TRIGGER, and CREATE VIEW
to reconstruct indexes, triggers, and views
associated with table X. Perhaps use the old format of the triggers,
indexes, and views saved from step 3 above as a guide, making changes
as ...
|
Page generated by FTS5 in about 94.82 ms.