Which index should SQLite use?

Hello, I'm Maneshwar. I'm building git-lrc, an AI code reviewer that runs on every commit. It is free, unlimited, and source-available on Github. Star Us to help devs discover the project. Do give it a try and share your feedback for improving the product. Even when indexes exist, choosing the wrong one can slow down a query significantly. The optimizer’s job here is not just to use an index, but to use the right index . One Table, One Index (Mostly) For each table in a query, SQLite can typically use only one index . There is one exception. In OR-based queries, SQLite may use multiple indexes, but in most cases, it selects a single index per table. Because of this limitation, index selection becomes a critical decision. SQLite tries to ensure that at least one useful index is applied to each table whenever possible. When Multiple Indexes Exist Consider a table with multiple indexes: ```sql id="9j9h8h" CREATE TABLE table1(x, y, z); CREATE INDEX i1 ON table1(x); CREATE INDEX i2 ON table