This is a good explanation about join order optimization: https://www.sqlite.org/queryplanner-ng.html https://www.sqlite.org/queryplanner-ng.html No database c

This is a good explanation about join order optimization: https://www.sqlite.org/queryplanner-ng.html https://www.sqlite.org/queryplanner-ng.html No database can find perfect join order when you have more than about 8 to 10 tables in the join.