Re:SQLite's Automatic Indexes
by masklinn on Thursday December 29, 2022 @03:22AM
(#34170640)
Per the linked mailing list post there’s no dust but there is a back channel through which you can be notified:
> SQLite
comes with instrumentation (specifically the SQLITE_STMTSTATUS_AUTOINDEX
verb for sqlite3_stmt_status() - http://www.sqlite.org/c3ref/stmt_status.html) that can be used to detect when automatic indices are used and alert the developer through a back channel to this fact so that she can fix the problem with an appropriate
CREATE INDEX. In other words, SQLite provides you with the tools to help you detect and eliminate the use of automatic indices.
> SQLite comes with instrumentation (specifically the SQLITE_STMTSTATUS_AUTOINDEX verb for sqlite3_stmt_status() - http://www.sqlite.org/c3ref/stmt_status.html) that can be used to detect when automatic indices are used and alert the developer through a back channel to this fact so that she can fix the problem with an appropriate CREATE INDEX. In other words, SQLite provides you with the tools to help you detect and eliminate the use of automatic indices.