MySQL 5.6.14 Source Code Document
 All Classes Namespaces Files Functions Variables Typedefs Enumerations Enumerator Friends Macros Groups Pages
pars0opt.h File Reference
#include "univ.i"
#include "que0types.h"
#include "usr0types.h"
#include "pars0sym.h"
#include "dict0types.h"
#include "row0sel.h"
#include "pars0opt.ic"
Include dependency graph for pars0opt.h:
This graph shows which files directly or indirectly include this file:

Go to the source code of this file.

Functions

UNIV_INTERN void opt_search_plan (sel_node_t *sel_node)
UNIV_INTERN void opt_find_all_cols (ibool copy_val, dict_index_t *index, sym_node_list_t *col_list, plan_t *plan, que_node_t *exp)
UNIV_INTERN void opt_print_query_plan (sel_node_t *sel_node)

Detailed Description

Simple SQL optimizer

Created 12/21/1997 Heikki Tuuri

Definition in file pars0opt.h.

Function Documentation

UNIV_INTERN void opt_find_all_cols ( ibool  copy_val,
dict_index_t index,
sym_node_list_t *  col_list,
plan_t plan,
que_node_t *  exp 
)

Looks for occurrences of the columns of the table in the query subgraph and adds them to the list of columns if an occurrence of the same column does not already exist in the list. If the column is already in the list, puts a value indirection to point to the occurrence in the column list, except if the column occurrence we are looking at is in the column list, in which case nothing is done. in: expression or condition

Looks for occurrences of the columns of the table in the query subgraph and adds them to the list of columns if an occurrence of the same column does not already exist in the list. If the column is already in the list, puts a value indirection to point to the occurrence in the column list, except if the column occurrence we are looking at is in the column list, in which case nothing is done.

Parameters
copy_valin: if TRUE, new found columns are added as columns to copy
indexin: index of the table to use
col_listin: base node of a list where to add new found columns
planin: plan or NULL
expin: expression or condition or NULL

Definition at line 867 of file pars0opt.cc.

Here is the call graph for this function:

Here is the caller graph for this function:

UNIV_INTERN void opt_print_query_plan ( sel_node_t sel_node)

Prints info of a query plan. in: select node

Prints info of a query plan.

Parameters
sel_nodein: select node

Definition at line 1218 of file pars0opt.cc.

Here is the call graph for this function:

Here is the caller graph for this function:

UNIV_INTERN void opt_search_plan ( sel_node_t sel_node)

Optimizes a select. Decides which indexes to tables to use. The tables are accessed in the order that they were written to the FROM part in the select statement. in: parsed select node

Optimizes a select. Decides which indexes to tables to use. The tables are accessed in the order that they were written to the FROM part in the select statement.

Parameters
sel_nodein: parsed select node

Definition at line 1141 of file pars0opt.cc.

Here is the call graph for this function:

Here is the caller graph for this function: