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