Optimize_table_order Class Reference

#include <sql_planner.h>

List of all members.

Public Member Functions
	Optimize_table_order (THD *thd, JOIN *join, TABLE_LIST *sjm_nest)
bool	choose_table_order ()

---

Detailed Description

This class determines the optimal join order for tables within a basic query block, ie a query specification clause, possibly extended with semi-joined tables from embedded subqueries.

This class takes as prerequisite a join class where all dependencies among tables have been sorted out, all possible access paths have been sorted out, and all statistics information has been filled in.

The class has a sole public function that will calculate the most optimal plan based on the inputs and the environment, such as prune level and greedy optimizer search depth. For more information, see the function headers for the private functions greedy_search(), best_extension_by_limited_search() and eq_ref_extension_by_limited_search().

---

The documentation for this class was generated from the following files:

• sql_planner.h
• sql_planner.cc