Short post about how SQLite sometimes creates indexes just for a single query. The SQLite documentation has a little more information.

It can be worth setting up and monitoring the error log for SQLITE_WARNING_AUTOINDEX warnings as good indication a persistent index should be created.