List of SQLite Syntax Diagrams aggregate-function-invocation alter-table-stmt analyze-stmt attach-stmt begin-stmt column-constraint column-def column-name-list comment-syntax commit-stmt common-table-expression compound-operator compound-select-stmt conflict-clause create-index ... 

5. Checklist For Avoiding Or Fixing Query Planner Problems  ... Make sure indexes are available to assist all large queries. Most performance issues can be resolved by one or two CREATE INDEX commands and with no changes to application code. Avoid creating low-quality indexes.. A low-quality index (for ... 

 ... aggregate functions ALTER TABLE ANALYZE ATTACH DATABASE BEGIN TRANSACTION comment COMMIT TRANSACTION core functions CREATE INDEX CREATE TABLE CREATE TRIGGER CREATE VIEW CREATE VIRTUAL TABLE date and time functions DELETE DETACH DATABASE DROP INDEX DROP TABLE DROP TRIGGER DROP VIEW ... 

4.2. Prefix Indexes By default, FTS5 maintains a single index recording the location of each token instance within the document set. This means that querying for complete tokens is fast, as it requires a single lookup, but querying for a prefix token can ... 

SQLITE_DETERMINISTIC, SQLITE_DIRECTONLY, SQLITE_SUBTYPE, SQLITE_INNOCUOUS, SQLITE_RESULT_SUBTYPE

 ... SQLITE_DIRECTONLY The SQLITE_DIRECTONLY flag means that the function may only be invoked from top-level SQL, and cannot be used in VIEWs or TRIGGERs nor in schema structures such as CHECK constraints, DEFAULT clauses, expression indexes, partial indexes, or generated ... 

2.8. Transient Indices  ... A preexisting index is used if possible, but if no suitable index is available, a transient index is created. The DISTINCT keyword on an aggregate query is implemented by creating a transient index in a temporary file and storing each ... 

2.1. Columns  ... This field is the number of rows that have been inserted into automatic indexes. A positive value in this field may indicate an opportunity to improve performance by adding a named index that take the place of the automatic index ... 

PRAGMA index_xinfo PRAGMA schema.index_xinfo(index-name); This pragma returns information about every column in an index. Unlike this index_info pragma, this pragma returns information about every column in the index, not just the key columns. (A key column is a column ... 

 ... Creating an index CREATE INDEX i2a ON t2(a);CREATE INDEX i2b ON t2(b); PostgreSQL:   0.381 MySQL:   0.318 SQLite 2.7.6:   0.777 SQLite 2.7.6 ... 

 ... If the argument is an index name, then only that one index is analyzed. 1.1. Recommended usage pattern Applications with long-lived databases that use complex queries should consider running the following commands just prior to closing each database ...