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

Field Details

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