|
| AccessPath * | NewSortAccessPath (THD *thd, AccessPath *child, Filesort *filesort, ORDER *order, bool count_examined_rows) |
| |
| AccessPath * | NewDeleteRowsAccessPath (THD *thd, AccessPath *child, table_map delete_tables, table_map immediate_tables) |
| |
| AccessPath * | NewUpdateRowsAccessPath (THD *thd, AccessPath *child, table_map update_tables, table_map immediate_tables) |
| |
| static Mem_root_array< Item_values_column * > * | GetTableValueConstructorOutputRefs (MEM_ROOT *mem_root, const JOIN *join) |
| |
| AccessPath * | NewTableValueConstructorAccessPath (const THD *thd, const JOIN *join) |
| |
| static AccessPath * | FindSingleAccessPathOfType (AccessPath *path, AccessPath::Type type) |
| |
| static RowIterator * | FindSingleIteratorOfType (AccessPath *path, AccessPath::Type type) |
| |
| TABLE * | GetBasicTable (const AccessPath *path) |
| | Return the TABLE* referred from 'path' if it is a basic access path, else a nullptr is returned. More...
|
| |
| table_map | GetUsedTableMap (const AccessPath *path, bool include_pruned_tables) |
| | Returns a map of all tables read when path or any of its children are executed. More...
|
| |
| static Prealloced_array< TABLE *, 4 > | GetUsedTables (AccessPath *child, bool include_pruned_tables) |
| |
| Mem_root_array< TABLE * > | CollectTables (THD *thd, AccessPath *root_path) |
| | Find the list of all tables used by this root, stopping at materializations. More...
|
| |
| static table_map | GetNullableEqRefTables (const AccessPath *root_path) |
| | Get the tables that are accessed by EQ_REF and can be on the inner side of an outer join. More...
|
| |
| bool | anonymous_namespace{access_path.cc}::ShouldEnableBatchMode (AccessPath *path) |
| |
| bool | anonymous_namespace{access_path.cc}::FinalizeMaterializedSubqueries (THD *thd, JOIN *join, AccessPath *path) |
| | If the path is a FILTER path marked that subqueries are to be materialized, do so. More...
|
| |
| void | anonymous_namespace{access_path.cc}::SetupJobsForChildren (MEM_ROOT *mem_root, AccessPath *child, JOIN *join, bool eligible_for_batch_mode, IteratorToBeCreated *job, Mem_root_array< IteratorToBeCreated > *todo) |
| |
| void | anonymous_namespace{access_path.cc}::SetupJobsForChildren (MEM_ROOT *mem_root, AccessPath *outer, AccessPath *inner, JOIN *join, bool inner_eligible_for_batch_mode, IteratorToBeCreated *job, Mem_root_array< IteratorToBeCreated > *todo) |
| |
| const Mem_root_array< Item * > * | GetExtraHashJoinConditions (MEM_ROOT *mem_root, bool using_hypergraph_optimizer, const vector< HashJoinCondition > &equijoin_conditions, const Mem_root_array< Item * > &other_conditions) |
| |
| unique_ptr_destroy_only< RowIterator > | CreateIteratorFromAccessPath (THD *thd, MEM_ROOT *mem_root, AccessPath *top_path, JOIN *top_join, bool top_eligible_for_batch_mode) |
| |
| void | FindTablesToGetRowidFor (AccessPath *path) |
| | Modifies "path" and the paths below it so that they provide row IDs for all tables. More...
|
| |
| static void | MoveFilterPredicatesIntoHashJoinCondition (THD *thd, AccessPath *path, const Mem_root_array< Predicate > &predicates, int num_where_predicates) |
| |
| Item * | ConditionFromFilterPredicates (const Mem_root_array< Predicate > &predicates, OverflowBitset mask, int num_where_predicates) |
| | Extracts the Item expression from the given “filter_predicates” corresponding to the given “mask”. More...
|
| |
| void | ExpandSingleFilterAccessPath (THD *thd, AccessPath *path, const JOIN *join, const Mem_root_array< Predicate > &predicates, unsigned num_where_predicates) |
| | Like ExpandFilterAccessPaths(), but expands only the single access path at “path”. More...
|
| |
| void | ExpandFilterAccessPaths (THD *thd, AccessPath *path_arg, const JOIN *join, const Mem_root_array< Predicate > &predicates, unsigned num_where_predicates) |
| | For each access path in the (sub)tree rooted at “path”, expand any use of “filter_predicates” into newly-inserted FILTER access paths, using the given predicate list. More...
|
| |
| table_map | GetHashJoinTables (AccessPath *path) |
| | Returns the tables that are part of a hash join. More...
|
| |
| void | CollectStatusVariables (THD *thd, const JOIN *top_join, const AccessPath &top_path) |
| | Update status variables which count how many scans of various types are used in a query plan. More...
|
| |
| void CollectStatusVariables |
( |
THD * |
thd, |
|
|
const JOIN * |
top_join, |
|
|
const AccessPath & |
top_path |
|
) |
| |
Update status variables which count how many scans of various types are used in a query plan.
The following status variables are updated: Select_scan, Select_full_join, Select_range, Select_full_range_join, Select_range_check. They are also stored as performance schema statement events with the same names.
In addition, the performance schema statement events NO_INDEX_USED and NO_GOOD_INDEX_USED are updated, if appropriate.
For each access path in the (sub)tree rooted at “path”, expand any use of “filter_predicates” into newly-inserted FILTER access paths, using the given predicate list.
This is used after finding an optimal set of access paths, to normalize the tree so that the remaining consumers do not need to worry about filter_predicates and cost_before_filter.
“join” is the join that “path” is part of.
Modifies "path" and the paths below it so that they provide row IDs for all tables.
This also figures out how the row IDs should be retrieved for each table in the input to the path. If the handler of the table is positioned on the correct row while reading the input, handler::position() can be called to get the row ID from the handler. However, if the input iterator returns rows without keeping the position of the underlying handlers in sync, calling handler::position() will not be able to provide the row IDs. Specifically, hash join and BKA join do not keep the underlying handlers positioned on the right row. Therefore, this function will instruct every hash join or BKA join below "path" to maintain row IDs in the join buffer, and updating handler::ref in every input table for each row they return. Then "path" does not need to call handler::position() to get it (nor should it, since calling it would overwrite the correct row ID with a stale one).
The tables on which "path" should call handler::position() are stored in a tables_to_get_rowid_for bitset in "path". For all the other tables, it can assume that handler::ref already contains the correct row ID.
Returns a map of all tables read when path or any of its children are executed.
Only iterators that are part of the same query block as path are considered.
If a table is read that doesn't have a map, specifically the temporary tables made as part of materialization within the same query block, RAND_TABLE_BIT will be set as a convention and none of that access path's children will be included in the map. In this case, the caller will need to manually go in and find said access path, to ask it for its TABLE object.
If include_pruned_tables = true, tables that are hidden under a ZERO_ROWS access path (ie., pruned away due to impossible join conditions) will be included in the map. This is normally what you want, as those tables need to be included whenever you store NULL flags and the likes, but if you don't want them (perhaps to specifically check for conditions referring to pruned tables), you can set it to false.
1.9.2