Module org.postgresql.pljava
Package org.postgresql.pljava.annotation
Interface Operator.SelectivityEstimators
 Enclosing class:
 Operator
public static interface Operator.SelectivityEstimators
Names of several functions predefined in PostgreSQL for estimating the
selectivity of operators in restriction clauses or joins.

Field Summary
Fields Modifier and Type Field Description static String
AREAJOINSEL
A joinselectivity estimator suitable for an operator doing 2D areabased comparisons.static String
CONTJOINSEL
A joinselectivity estimator suitable for an operator doing 2D containmentbased comparisons.static String
EQJOINSEL
A joinselectivity estimator suitable for an operator with rather high selectivity typical of an operator like=
.static String
EQSEL
A restrictionselectivity estimator suitable for an operator with rather high selectivity typical of an operator like=
.static String
MATCHINGJOINSEL
A joinselectivity estimator suitable for an operator somewhat less strict than a typical=
operator.static String
MATCHINGSEL
A restrictionselectivity estimator suitable for an operator somewhat less strict than a typical=
operator.static String
NEQJOINSEL
A joinselectivity estimator suitable for an operator with rather low selectivity typical of an operator like<>
.static String
NEQSEL
A restrictionselectivity estimator suitable for an operator with rather low selectivity typical of an operator like<>
.static String
POSITIONJOINSEL
A joinselectivity estimator suitable for an operator doing 2D positionbased comparisons.static String
SCALARGEJOINSEL
A joinselectivity estimator suitable for an operator with selectivity typical of an operator like>=
.static String
SCALARGESEL
A restrictionselectivity estimator suitable for an operator with selectivity typical of an operator like>=
.static String
SCALARGTJOINSEL
A joinselectivity estimator suitable for an operator with selectivity typical of an operator like>
.static String
SCALARGTSEL
A restrictionselectivity estimator suitable for an operator with selectivity typical of an operator like>
.static String
SCALARLEJOINSEL
A joinselectivity estimator suitable for an operator with selectivity typical of an operator like<=
.static String
SCALARLESEL
A restrictionselectivity estimator suitable for an operator with selectivity typical of an operator like<=
.static String
SCALARLTJOINSEL
A joinselectivity estimator suitable for an operator with selectivity typical of an operator like<
.static String
SCALARLTSEL
A restrictionselectivity estimator suitable for an operator with selectivity typical of an operator like<
.

Field Details

EQSEL
A restrictionselectivity estimator suitable for an operator with rather high selectivity typical of an operator like=
. See Also:
 Constant Field Values

MATCHINGSEL
A restrictionselectivity estimator suitable for an operator somewhat less strict than a typical=
operator. See Also:
 Constant Field Values

NEQSEL
A restrictionselectivity estimator suitable for an operator with rather low selectivity typical of an operator like<>
. See Also:
 Constant Field Values

SCALARLTSEL
A restrictionselectivity estimator suitable for an operator with selectivity typical of an operator like<
. See Also:
 Constant Field Values

SCALARLESEL
A restrictionselectivity estimator suitable for an operator with selectivity typical of an operator like<=
. See Also:
 Constant Field Values

SCALARGTSEL
A restrictionselectivity estimator suitable for an operator with selectivity typical of an operator like>
. See Also:
 Constant Field Values

SCALARGESEL
A restrictionselectivity estimator suitable for an operator with selectivity typical of an operator like>=
. See Also:
 Constant Field Values

EQJOINSEL
A joinselectivity estimator suitable for an operator with rather high selectivity typical of an operator like=
. See Also:
 Constant Field Values

MATCHINGJOINSEL
A joinselectivity estimator suitable for an operator somewhat less strict than a typical=
operator. See Also:
 Constant Field Values

NEQJOINSEL
A joinselectivity estimator suitable for an operator with rather low selectivity typical of an operator like<>
. See Also:
 Constant Field Values

SCALARLTJOINSEL
A joinselectivity estimator suitable for an operator with selectivity typical of an operator like<
. See Also:
 Constant Field Values

SCALARLEJOINSEL
A joinselectivity estimator suitable for an operator with selectivity typical of an operator like<=
. See Also:
 Constant Field Values

SCALARGTJOINSEL
A joinselectivity estimator suitable for an operator with selectivity typical of an operator like>
. See Also:
 Constant Field Values

SCALARGEJOINSEL
A joinselectivity estimator suitable for an operator with selectivity typical of an operator like>=
. See Also:
 Constant Field Values

AREAJOINSEL
A joinselectivity estimator suitable for an operator doing 2D areabased comparisons. See Also:
 Constant Field Values

POSITIONJOINSEL
A joinselectivity estimator suitable for an operator doing 2D positionbased comparisons. See Also:
 Constant Field Values

CONTJOINSEL
A joinselectivity estimator suitable for an operator doing 2D containmentbased comparisons. See Also:
 Constant Field Values
