queries with lots of tables and lots of indexes can quickly run into the thousands and even millions of alternatives. Choosing the right indexes to use, and the right order to fetch data in, proves to be the difference between a 10ms and 5s query. The planner's job is to find the best possible query plan among all possibilities.
Table of contents
How query planning works #The importance of a good query planner #Spin up a database with Vitess under the hood in just seconds.Sort: