News for hackers. Stuff that matters.
Re:Joins 13 Ways by sobellian on Monday July 03, 2023 @05:00PM (#36578772)
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 and https://www.sqlite.org/queryplanner.html.
Re:Joins 13 Ways by Sesse__ on Tuesday July 04, 2023 @03:50AM (#36583559)
The 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.