29 ms·
I don't know if this has the level of detail you're looking for, but you might want to check https://www.sqlite.org/optoverview.html https://www.sqlite.org/opto
by sobellian 3y ago
I don't know if this has the level of detail you're looking for, but you might want to check https://www.sqlite.org/optoverview.html https://www.sqlite.org/optoverview.html and https://www.sqlite.org/queryplanner.html https://www.sqlite.org/queryplanner.html.
- Sesse__ 3y agoThe SQLite optimizer is really primitive. You generally don't want to be using it as a template if you can avoid it; it's good for OLTP but can't handle many-way joins well.