List of selectivityForConglomerate() Examples

Examples of selectivityForConglomerate()

org.apache.derby.iapi.sql.dictionary.TableDescriptor.selectivityForConglomerate()
For this conglomerate (index), return the selectivity of the first numKeys. This basically returns the reciprocal of the number of unique values in the leading numKey columns of the index. It is assumed that statistics exist for the conglomerate if this function is called. However, no locks are held to prevent the statistics from being dropped, so the method also handles the case of missing statistics by using a heuristic to estimate the selectivity. @param cd ConglomerateDescriptor (Index) whosecardinality we are interested in. @param numKeys Number of leading columns of the index for whichcardinality is desired.

Examples of org.apache.derby.iapi.sql.dictionary.TableDescriptor.selectivityForConglomerate()

      
      if (conglomIndex == -1)
        break;      // no more stats available.


      selectivity *=
        td.selectivityForConglomerate(conglomerates[conglomIndex], maxPreds.size());


      for (int i = 0; i < maxPreds.size(); i++)
      {
        /* remove the predicates that we've calculated the selectivity
         * of, from workingPredicates.

View Full Code Here

Examples of org.apache.derby.iapi.sql.dictionary.TableDescriptor.selectivityForConglomerate()

      
      if (conglomIndex == -1)
        break;      // no more stats available.


      selectivity *=
        td.selectivityForConglomerate(conglomerates[conglomIndex], maxPreds.size());


      for (int i = 0; i < maxPreds.size(); i++)
      {
        /* remove the predicates that we've calculated the selectivity
         * of, from workingPredicates.

View Full Code Here

Examples of org.apache.derby.iapi.sql.dictionary.TableDescriptor.selectivityForConglomerate()

      
      if (conglomIndex == -1)
        break;      // no more stats available.


      selectivity *=
        td.selectivityForConglomerate(conglomerates[conglomIndex], maxPreds.size());


      for (int i = 0; i < maxPreds.size(); i++)
      {
        /* remove the predicates that we've calculated the selectivity
         * of, from workingPredicates.

View Full Code Here

Examples of org.apache.derby.iapi.sql.dictionary.TableDescriptor.selectivityForConglomerate()

      
      if (conglomIndex == -1)
        break;      // no more stats available.


      selectivity *=
        td.selectivityForConglomerate(conglomerates[conglomIndex], maxPreds.size());


      for (int i = 0; i < maxPreds.size(); i++)
      {
        /* remove the predicates that we've calculated the selectivity
         * of, from workingPredicates.

View Full Code Here

Examples of org.apache.derby.iapi.sql.dictionary.TableDescriptor.selectivityForConglomerate()

      
      if (conglomIndex == -1)
        break;      // no more stats available.


      selectivity *=
        td.selectivityForConglomerate(conglomerates[conglomIndex], maxPreds.size());


      for (int i = 0; i < maxPreds.size(); i++)
      {
        /* remove the predicates that we've calculated the selectivity
         * of, from workingPredicates.

View Full Code Here

Examples of org.apache.derby.iapi.sql.dictionary.TableDescriptor.selectivityForConglomerate()

      
      if (conglomIndex == -1)
        break;      // no more stats available.


      selectivity *=
        td.selectivityForConglomerate(conglomerates[conglomIndex], maxPreds.size());


      for (int i = 0; i < maxPreds.size(); i++)
      {
        /* remove the predicates that we've calculated the selectivity
         * of, from workingPredicates.

View Full Code Here

Examples of org.apache.derby.iapi.sql.dictionary.TableDescriptor.selectivityForConglomerate()

      
      if (conglomIndex == -1)
        break;      // no more stats available.


      selectivity *=
        td.selectivityForConglomerate(conglomerates[conglomIndex], maxPreds.size());


      for (int i = 0; i < maxPreds.size(); i++)
      {
        /* remove the predicates that we've calculated the selectivity
         * of, from workingPredicates.

View Full Code Here

Examples of org.apache.derby.iapi.sql.dictionary.TableDescriptor.selectivityForConglomerate()

      
      if (conglomIndex == -1)
        break;      // no more stats available.


      selectivity *=
        td.selectivityForConglomerate(conglomerates[conglomIndex], maxPreds.size());


      for (int i = 0; i < maxPreds.size(); i++)
      {
        /* remove the predicates that we've calculated the selectivity
         * of, from workingPredicates.

View Full Code Here

Examples of org.apache.derby.iapi.sql.dictionary.TableDescriptor.selectivityForConglomerate()

      
      if (conglomIndex == -1)
        break;      // no more stats available.


      selectivity *=
        td.selectivityForConglomerate(conglomerates[conglomIndex], maxPreds.size());


      for (int i = 0; i < maxPreds.size(); i++)
      {
        /* remove the predicates that we've calculated the selectivity
         * of, from workingPredicates.

View Full Code Here

Examples of org.apache.derby.iapi.sql.dictionary.TableDescriptor.selectivityForConglomerate()

      
      if (conglomIndex == -1)
        break;      // no more stats available.


      selectivity *=
        td.selectivityForConglomerate(conglomerates[conglomIndex], maxPreds.size());


      for (int i = 0; i < maxPreds.size(); i++)
      {
        /* remove the predicates that we've calculated the selectivity
         * of, from workingPredicates.

View Full Code Here

0 1

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.