List of selectivity() Examples

Examples of selectivity()

org.apache.derby.iapi.sql.compile.OptimizablePredicate.selectivity()
Get a (crude) estimate of the selectivity of this predicate. This is to be used when no better technique is available for estimating the selectivity - this method's estimate is a hard- wired number based on the type of predicate and the datatype (the selectivity of boolean is always 50%). @param optTable The Optimizable that this predicate restricts

Examples of org.apache.derby.iapi.sql.compile.OptimizablePredicate.selectivity()

    double selectivity = 1.0;


    for (int i = 0; i < size(); i++)
    {
      OptimizablePredicate pred = (OptimizablePredicate)elementAt(i);
      selectivity *= pred.selectivity((Optimizable)optTable);
    }
    
    return selectivity;
  }

View Full Code Here

Examples of org.apache.derby.iapi.sql.compile.OptimizablePredicate.selectivity()

              startStopPredCount++;


            if (pred.getIndexPosition() == 0)
            {
              extraFirstColumnSelectivity *=
                            pred.selectivity(this);
              if (! seenFirstColumn)
              {
                ValueNode relNode = ((Predicate) pred).getAndNode().getLeftOperand();
                if (relNode instanceof BinaryRelationalOperatorNode)
                  firstColumn = ((BinaryRelationalOperatorNode) relNode).getColumnOperand(this);

View Full Code Here

Examples of org.apache.derby.iapi.sql.compile.OptimizablePredicate.selectivity()

                seenFirstColumn = true;
              }
            }
            else
            {
              extraStartStopSelectivity *= pred.selectivity(this);
              numExtraStartStopPreds++;
            }
          }
        }
        else

View Full Code Here

Examples of org.apache.derby.iapi.sql.compile.OptimizablePredicate.selectivity()

            }
          }


          if (pred.isQualifier())
          {
            extraQualifierSelectivity *= pred.selectivity(this);
            numExtraQualifiers++;
          }
          else
          {
            extraNonQualifierSelectivity *= pred.selectivity(this);

View Full Code Here

Examples of org.apache.derby.iapi.sql.compile.OptimizablePredicate.selectivity()

            extraQualifierSelectivity *= pred.selectivity(this);
            numExtraQualifiers++;
          }
          else
          {
            extraNonQualifierSelectivity *= pred.selectivity(this);
            numExtraNonQualifiers++;
          }


          /*
          ** Strictly speaking, it shouldn't be necessary to

View Full Code Here

Examples of org.apache.derby.iapi.sql.compile.OptimizablePredicate.selectivity()

              startStopPredCount++;


            if (pred.getIndexPosition() == 0)
            {
              extraFirstColumnSelectivity *=
                            pred.selectivity(this);
              if (! seenFirstColumn)
              {
                ValueNode relNode = ((Predicate) pred).getAndNode().getLeftOperand();
                if (relNode instanceof BinaryRelationalOperatorNode)
                  firstColumn = ((BinaryRelationalOperatorNode) relNode).getColumnOperand(this);

View Full Code Here

Examples of org.apache.derby.iapi.sql.compile.OptimizablePredicate.selectivity()

                seenFirstColumn = true;
              }
            }
            else
            {
              extraStartStopSelectivity *= pred.selectivity(this);
              numExtraStartStopPreds++;
            }
          }
        }
        else

View Full Code Here

Examples of org.apache.derby.iapi.sql.compile.OptimizablePredicate.selectivity()

            }
          }


          if (pred.isQualifier())
          {
            extraQualifierSelectivity *= pred.selectivity(this);
            numExtraQualifiers++;
          }
          else
          {
            extraNonQualifierSelectivity *= pred.selectivity(this);

View Full Code Here

Examples of org.apache.derby.iapi.sql.compile.OptimizablePredicate.selectivity()

            extraQualifierSelectivity *= pred.selectivity(this);
            numExtraQualifiers++;
          }
          else
          {
            extraNonQualifierSelectivity *= pred.selectivity(this);
            numExtraNonQualifiers++;
          }


          /*
          ** Strictly speaking, it shouldn't be necessary to

View Full Code Here

Examples of org.apache.derby.iapi.sql.compile.OptimizablePredicate.selectivity()

    double selectivity = 1.0;


    for (int i = 0; i < size(); i++)
    {
      OptimizablePredicate pred = (OptimizablePredicate)elementAt(i);
            selectivity *= pred.selectivity(optTable);
    }
    
    return selectivity;
  }

View Full Code Here

0 1 2 3 4 5

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.