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 Detail

EQSEL
static final String EQSEL
A restrictionselectivity 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 restrictionselectivity estimator suitable for an operator somewhat less strict than a typical=
operator. See Also:
 Constant Field Values

NEQSEL
static final String NEQSEL
A restrictionselectivity 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 restrictionselectivity estimator suitable for an operator with selectivity typical of an operator like<
. See Also:
 Constant Field Values

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

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

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

EQJOINSEL
static final String EQJOINSEL
A joinselectivity 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 joinselectivity estimator suitable for an operator somewhat less strict than a typical=
operator. See Also:
 Constant Field Values

NEQJOINSEL
static final String NEQJOINSEL
A joinselectivity 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 joinselectivity estimator suitable for an operator with selectivity typical of an operator like<
. See Also:
 Constant Field Values

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

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

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

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

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

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

