This series of tutorials is about indexing and optimization in SQLite:

  • Creating Indexes
    • Syntax and use cases
    • Unique and composite indexes
  • Optimizing Queries
    • Understanding the query planner
    • Using EXPLAIN and EXPLAIN QUERY PLAN
  • Performance Considerations
    • Balancing read/write performance
    • Impact of indexes on inserts and updates