![]()  | 
  
    MySQL 9.5.0
    
   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 |