MySQL 8.4.2
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 |