Examples of org.apache.derby.catalog.IndexDescriptor

org.apache.derby.catalog.IndexDescriptor
This interface describes an index. It is used in the column SYS.SYSCONGLOMERATES.DESCRIPTOR and describes everything about an index except the index name and the table on which the index is defined. That information is available in the columns NAME and TABLEID of the table SYS.SYSCONGLOMERATES.

               * null in a join case (See Beetle 4423)
               */
              AccessPath accessPath= getTrulyTheBestAccessPath();
              if (accessPath == null)
                return;
              IndexDescriptor id = accessPath.
                        getConglomerateDescriptor().
                        getIndexDescriptor();
              int[] keyColumns = id.baseColumnPositions();
              boolean[] isAscending = id.isAscending();
              for (int i = 0; i < keyColumns.length; i++)
              {
                /* in such a query: select min(c3) from
                 * tab1 where c1 = 2 and c2 = 5, if prefix keys
                 * have equality operator, then we can still use

View Full Code Here

              if (accessPath == null ||
                accessPath.getConglomerateDescriptor()==null||
                accessPath.getConglomerateDescriptor().
                           getIndexDescriptor() == null)
                return;
              IndexDescriptor id = accessPath.
                        getConglomerateDescriptor().
                        getIndexDescriptor();
              int[] keyColumns = id.baseColumnPositions();
              boolean[] isAscending = id.isAscending();
              for (int i = 0; i < keyColumns.length; i++)
              {
                /* in such a query: select min(c3) from
                 * tab1 where c1 = 2 and c2 = 5, if prefix keys
                 * have equality operator, then we can still use

View Full Code Here


      if (! cd.isIndex())
      {
        continue;
      }
      IndexDescriptor id = cd.getIndexDescriptor();


      if (! id.isUnique())
      {
        continue;
      }


      int[] keyColumns = id.baseColumnPositions();
      int numBits = tableColMap[0].size();
      JBitSet keyMap = new JBitSet(numBits);
      JBitSet resMap = new JBitSet(numBits);


      int inner = 0;

View Full Code Here

            if (step == 0 && baseColumnPositions[k + step] == 0)
              step++;
            newBCP[k] = baseColumnPositions[k + step];
            newIsAscending[k] = isAscending[k + step];
          }
          IndexDescriptor id = compressIRGs[j].getIndexDescriptor();
          id.setBaseColumnPositions(newBCP);
          id.setIsAscending(newIsAscending);
          id.setNumberOfOrderedColumns(id.numberOfOrderedColumns() - 1);
        }
      }
      compressIRGs = newIRGs;
      indexConglomerateNumbers = newIndexConglomNumbers;
    }

View Full Code Here


      if (! cd.isIndex())
      {
        continue;
      }
      IndexDescriptor id = cd.getIndexDescriptor();


      if (! id.isUnique())
      {
        continue;
      }


      int[] keyColumns = id.baseColumnPositions();


      int inner = 0;
      for ( ; inner < keyColumns.length; inner++)
      {
        if (! eqCols[keyColumns[inner]])

View Full Code Here

            if (step == 0 && baseColumnPositions[k + step] == 0)
              step++;
            newBCP[k] = baseColumnPositions[k + step];
            newIsAscending[k] = isAscending[k + step];
          }
          IndexDescriptor id = compressIRGs[j].getIndexDescriptor();
          id.setBaseColumnPositions(newBCP);
          id.setIsAscending(newIsAscending);
          id.setNumberOfOrderedColumns(id.numberOfOrderedColumns() - 1);
        }
      }
      compressIRGs = newIRGs;
      indexConglomerateNumbers = newIndexConglomNumbers;
    }

View Full Code Here

            if (step == 0 && baseColumnPositions[k + step] == 0)
              step++;
            newBCP[k] = baseColumnPositions[k + step];
            newIsAscending[k] = isAscending[k + step];
          }
          IndexDescriptor id = compressIRGs[j].getIndexDescriptor();
          id.setBaseColumnPositions(newBCP);
          id.setIsAscending(newIsAscending);
          id.setNumberOfOrderedColumns(id.numberOfOrderedColumns() - 1);
        }
      }
      compressIRGs = newIRGs;
      indexConglomerateNumbers = newIndexConglomNumbers;
    }

View Full Code Here


      if (! cd.isIndex())
      {
        continue;
      }
      IndexDescriptor id = cd.getIndexDescriptor();


      if (! id.isUnique())
      {
        continue;
      }


      int[] keyColumns = id.baseColumnPositions();


      int inner = 0;
      for ( ; inner < keyColumns.length; inner++)
      {
        if (! eqCols[keyColumns[inner]])

View Full Code Here

            if (step == 0 && baseColumnPositions[k + step] == 0)
              step++;
            newBCP[k] = baseColumnPositions[k + step];
            newIsAscending[k] = isAscending[k + step];
          }
          IndexDescriptor id = compressIRGs[j].getIndexDescriptor();
          id.setBaseColumnPositions(newBCP);
          id.setIsAscending(newIsAscending);
          id.setNumberOfOrderedColumns(id.numberOfOrderedColumns() - 1);
        }
      }
      compressIRGs = newIRGs;
      indexConglomerateNumbers = newIndexConglomNumbers;
    }

View Full Code Here


      if (! cd.isIndex())
      {
        continue;
      }
      IndexDescriptor id = cd.getIndexDescriptor();


      if (! id.isUnique())
      {
        continue;
      }


      int[] keyColumns = id.baseColumnPositions();


      int inner = 0;
      for ( ; inner < keyColumns.length; inner++)
      {
        if (! eqCols[keyColumns[inner]])

View Full Code Here

0 1 2 3 4 5 6

TOP

Related Classes of org.apache.derby.catalog.IndexDescriptor

org.apache.derby.impl.sql.compile.FromBaseTable

org.apache.derby.impl.sql.compile.GroupByNode

org.apache.derby.impl.sql.execute.AlterTableConstantAction

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.