Sure I will do. But my question was general about how the query planner considers theses hints: The documentation does not state clearly which of estimatedCost or estimatedRows has higher precedence. I quickly checked the source code of SQLite and it seems that the values of estimatedCost are always compared before those of estimatedRows.