The SQLite Query Optimizer Overview - SQLite Home Page
The SQLite Query Planner This document provides overview of how the query planner and optimizer for SQLite works. Given a single SQL statement, there might be dozens, hundreds, or even thousands of ways to implement that statement, depending on the ......