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
Modifier and TypeFieldDescriptionstatic final String
A join-selectivity estimator suitable for an operator doing 2-D area-based comparisons.static final String
A join-selectivity estimator suitable for an operator doing 2-D containment-based comparisons.static final String
A join-selectivity estimator suitable for an operator with rather high selectivity typical of an operator like=
.static final String
A restriction-selectivity estimator suitable for an operator with rather high selectivity typical of an operator like=
.static final String
A join-selectivity estimator suitable for an operator somewhat less strict than a typical=
operator.static final String
A restriction-selectivity estimator suitable for an operator somewhat less strict than a typical=
operator.static final String
A join-selectivity estimator suitable for an operator with rather low selectivity typical of an operator like<>
.static final String
A restriction-selectivity estimator suitable for an operator with rather low selectivity typical of an operator like<>
.static final String
A join-selectivity estimator suitable for an operator doing 2-D position-based comparisons.static final String
A join-selectivity estimator suitable for an operator with selectivity typical of an operator like>=
.static final String
A restriction-selectivity estimator suitable for an operator with selectivity typical of an operator like>=
.static final String
A join-selectivity estimator suitable for an operator with selectivity typical of an operator like>
.static final String
A restriction-selectivity estimator suitable for an operator with selectivity typical of an operator like>
.static final String
A join-selectivity estimator suitable for an operator with selectivity typical of an operator like<=
.static final String
A restriction-selectivity estimator suitable for an operator with selectivity typical of an operator like<=
.static final String
A join-selectivity estimator suitable for an operator with selectivity typical of an operator like<
.static final String
A restriction-selectivity estimator suitable for an operator with selectivity typical of an operator like<
.
-
Field Details
-
EQSEL
A restriction-selectivity estimator suitable for an operator with rather high selectivity typical of an operator like=
.- See Also:
-
MATCHINGSEL
A restriction-selectivity estimator suitable for an operator somewhat less strict than a typical=
operator.- See Also:
-
NEQSEL
A restriction-selectivity estimator suitable for an operator with rather low selectivity typical of an operator like<>
.- See Also:
-
SCALARLTSEL
A restriction-selectivity estimator suitable for an operator with selectivity typical of an operator like<
.- See Also:
-
SCALARLESEL
A restriction-selectivity estimator suitable for an operator with selectivity typical of an operator like<=
.- See Also:
-
SCALARGTSEL
A restriction-selectivity estimator suitable for an operator with selectivity typical of an operator like>
.- See Also:
-
SCALARGESEL
A restriction-selectivity estimator suitable for an operator with selectivity typical of an operator like>=
.- See Also:
-
EQJOINSEL
A join-selectivity estimator suitable for an operator with rather high selectivity typical of an operator like=
.- See Also:
-
MATCHINGJOINSEL
A join-selectivity estimator suitable for an operator somewhat less strict than a typical=
operator.- See Also:
-
NEQJOINSEL
A join-selectivity estimator suitable for an operator with rather low selectivity typical of an operator like<>
.- See Also:
-
SCALARLTJOINSEL
A join-selectivity estimator suitable for an operator with selectivity typical of an operator like<
.- See Also:
-
SCALARLEJOINSEL
A join-selectivity estimator suitable for an operator with selectivity typical of an operator like<=
.- See Also:
-
SCALARGTJOINSEL
A join-selectivity estimator suitable for an operator with selectivity typical of an operator like>
.- See Also:
-
SCALARGEJOINSEL
A join-selectivity estimator suitable for an operator with selectivity typical of an operator like>=
.- See Also:
-
AREAJOINSEL
A join-selectivity estimator suitable for an operator doing 2-D area-based comparisons.- See Also:
-
POSITIONJOINSEL
A join-selectivity estimator suitable for an operator doing 2-D position-based comparisons.- See Also:
-
CONTJOINSEL
A join-selectivity estimator suitable for an operator doing 2-D containment-based comparisons.- See Also:
-