Class QueryPlan.RangeSelectNode

  • All Implemented Interfaces:
    QueryPlanNode, java.io.Serializable, java.lang.Cloneable
    Enclosing class:
    QueryPlan

    public static class QueryPlan.RangeSelectNode
    extends QueryPlan.SingleQueryPlanNode
    The node for performing a simple indexed query on a single column of the child node. Finds the set from the child node that matches the range.

    The given Expression object must conform to a number of rules. It may reference only one column in the child node. It must consist of only simple mathemetical and logical operators (<, >, =, <>, >=, <=, AND, OR). The left side of each mathematical operator must be a variable, and the right side must be a constant (parameter subsitution or correlated value). For example; (col > 10 AND col < 100) OR col > 1000 OR col == 10

    Breaking any of these rules will mean the range select can not happen.

    See Also:
    Serialized Form