3 ms·
For comparison, SQLite's optimizer is described in https://www.sqlite.org/optoverview.html https://www.sqlite.org/optoverview.html and, linked from it, https:/
by Someone 11y ago
For comparison, SQLite's optimizer is described in https://www.sqlite.org/optoverview.html https://www.sqlite.org/optoverview.html and, linked from it, https://www.sqlite.org/queryplanner-ng.html https://www.sqlite.org/queryplanner-ng.html.
SQLite doesn't want to spend time considering all possible join combinations, accepting the risk that it chooses a plan that is a lot worse than the optimal one.