![]() |
MySQL 8.0.43
Source Code Documentation
|
A sargable (from “Search ARGument”) predicate is one that we can attempt to push down into an index (what we'd call “ref access” or “index range scan”/“quick”). More...
#include <make_join_hypergraph.h>
Public Attributes | |
| int | predicate_index |
| Field * | field |
| Item * | other_side |
| bool | can_evaluate |
| True if it is safe to evaluate "other_side" during optimization. More... | |
A sargable (from “Search ARGument”) predicate is one that we can attempt to push down into an index (what we'd call “ref access” or “index range scan”/“quick”).
This structure denotes one such instance, precomputed from all the predicates in the given hypergraph.
| bool SargablePredicate::can_evaluate |
True if it is safe to evaluate "other_side" during optimization.
It must be constant during execution. Also, it should not contain subqueries or stored procedures, which we do not want to execute during optimization.
| Field* SargablePredicate::field |
| Item* SargablePredicate::other_side |
| int SargablePredicate::predicate_index |