InnoDB Plugin  1.0
Functions
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:

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

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

Parameters
copy_valin: if TRUE, new found columns are added as columns to copy
indexin: index to use
col_listin: base node of a list where to add new found columns
planin: plan or NULL
UNIV_INTERN void opt_print_query_plan ( sel_node_t sel_node)

Prints info of a query plan. in: select node

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