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 (specifical

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 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.