Small. Fast. Reliable.
Choose any three.

SQLite C Interface

Virtual Table Scan Flags

#define SQLITE_INDEX_SCAN_UNIQUE 0x00000001 /* Scan visits at most 1 row */
#define SQLITE_INDEX_SCAN_HEX    0x00000002 /* Display idxNum as hex */
                                            /* in EXPLAIN QUERY PLAN */

Virtual table implementations are allowed to set the sqlite3_index_info.idxFlags field to some combination of these bits.

See also lists of Objects, Constants, and Functions.