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