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 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