- cross-posted to:
- programming
- cross-posted to:
- programming
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.
You must log in or # to comment.