4 ms·
would be cool to get a diagnostic message when that happens
by yread 4y ago
would be cool to get a diagnostic message when that happens
- chasil 4y agoFor transient indexes, or permanent ones? The transient indexes will be created in a separate, temporary file. They will be erased on a commit, rollback, or crash recovery. They will not persist.
- masklinn 4y agoPer 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.