Simon Willison’s Weblog

Subscribe

12th December 2022

TIL SQLite can use more than one index for a query — I was trying to figure out if SQLite has the ability to use more than one index as part of executing a single query, or if it only ever picks a single index that it thinks will give the best performance.
Posted 12th December 2022 at 7:34 am

Recent articles

This is a beat by Simon Willison, posted on 12th December 2022.

Monthly briefing

Sponsor me for $10/month and get a curated email digest of the month's most important LLM developments.

Pay me to send you less!

Sponsor & subscribe