List of numberOfOrderedColumns() Examples

Examples of numberOfOrderedColumns()

org.apache.derby.catalog.IndexDescriptor.numberOfOrderedColumns()
Returns the number of ordered columns.
In the future, it will be possible to store non-ordered columns in an index. These will be useful for covered queries. The ordered columns will be at the beginning of the index row, and they will be followed by the non-ordered columns. For now, all columns in an index must be ordered.
org.apache.derby.iapi.sql.dictionary.IndexRowGenerator.numberOfOrderedColumns()
@see IndexDescriptor#numberOfOrderedColumns

Examples of org.apache.derby.catalog.IndexDescriptor.numberOfOrderedColumns()

            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

Examples of org.apache.derby.iapi.sql.dictionary.IndexRowGenerator.numberOfOrderedColumns()

                IndexRowGenerator irg = cds[i].getIndexDescriptor();


                // Skip single-column unique indexes unless we're told not to,
                // or we are running in soft-upgrade-mode on a pre 10.9 db.
                if (skipDisposableStats) {
                    if (irg.isUnique() && irg.numberOfOrderedColumns() == 1) {
                        conglomerateNumber[i] = -1;
                        continue;
                    }
                }

View Full Code Here

Examples of org.apache.derby.iapi.sql.dictionary.IndexRowGenerator.numberOfOrderedColumns()

                    // statistics for single-column unique indexes, we 
                    // should improve the selectivity of such an index
                    // when the index is being considered by the optimizer.
                    IndexRowGenerator irg = cd.getIndexDescriptor();
                    if (irg.isUnique() 
                            && irg.numberOfOrderedColumns() == 1
                            && startStopPredCount == 1) {
                        statStartStopSelectivity = (1/(double)baseRowCount());
                    }
                }
            }

View Full Code Here

Examples of org.apache.derby.iapi.sql.dictionary.IndexRowGenerator.numberOfOrderedColumns()

                IndexRowGenerator irg = cds[i].getIndexDescriptor();


                // Skip single-column unique indexes unless we're told not to,
                // or we are running in soft-upgrade-mode on a pre 10.9 db.
                if (skipDisposableStats) {
                    if (irg.isUnique() && irg.numberOfOrderedColumns() == 1) {
                        conglomerateNumber[i] = -1;
                        continue;
                    }
                }

View Full Code Here

Examples of org.apache.derby.iapi.sql.dictionary.IndexRowGenerator.numberOfOrderedColumns()

                    // statistics for single-column unique indexes, we 
                    // should improve the selectivity of such an index
                    // when the index is being considered by the optimizer.
                    IndexRowGenerator irg = cd.getIndexDescriptor();
                    if (irg.isUnique() 
                        && irg.numberOfOrderedColumns() == 1 
                        && startStopPredCount == 1) {
                            statStartStopSelectivity = 
                                (double)(1/(double)baseRowCount());
                    }
                }

View Full Code Here

Examples of org.apache.derby.iapi.sql.dictionary.IndexRowGenerator.numberOfOrderedColumns()

                }
                IndexRowGenerator irg = cds[i].getIndexDescriptor();
                // Skip single-column unique indexes unless we're told not to,
                // or we are running in soft-upgrade-mode on a pre 10.9 db.
                if (skipDisposableStats) {
                    if (irg.isUnique() && irg.numberOfOrderedColumns() == 1) {
                        conglomerateNumber[i] = -1;
                        continue;
                    }
                }

View Full Code Here

0 1 2

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.