Examples of org.hsqldb.index.Index$IndexUse

org.hsqldb.index.Index
@author Fred Toussi (fredt@users dot sourceforge.net) @version 2.2.9 @since 1.9.0

            indexQualifier = tableCatalog;
            indexCount     = table.getIndexCount();


            // process all of the visible indices for this table
            for (int i = 0; i < indexCount; i++) {
                Index index = table.getIndex(i);


                colCount = table.getIndex(i).getColumnCount();


                if (colCount < 1) {
                    continue;
                }


                indexName      = index.getName().name;
                nonUnique      = index.isUnique() ? Boolean.FALSE
                                                  : Boolean.TRUE;
                cardinality    = null;
                pages          = ValuePool.INTEGER_0;
                rowCardinality = null;
                cols           = index.getColumns();
                indexType      = ValuePool.getInt(3);


                for (int k = 0; k < colCount; k++) {
                    col                    = cols[k];
                    row                    = t.getEmptyRowData();

View Full Code Here

        manager.setStore(table, null);
    }


    public void setAccessor(Index key, CachedObject accessor) {


        Index index = (Index) key;


        accessorList[index.getPosition()] = accessor;
    }

View Full Code Here

                    OrderedIntHashSet set = new OrderedIntHashSet();


                    ((ExpressionLogical) e).addLeftColumnsForAllAny(
                        conditions.rangeVar, set);


                    Index index =
                        conditions.rangeVar.rangeTable.getIndexForColumns(
                            session, set, false);


                    // code to disable IN optimisation
                    // index = null;

View Full Code Here

    }


    private void setEqaulityConditions(RangeVariableConditions conditions,
                                       HsqlArrayList exprList) {


        Index idx = conditions.rangeVar.rangeTable.getIndexForColumns(session,
            colIndexSetEqual, false);


        if (idx == null) {
            return;
        }


        int[]        cols                = idx.getColumns();
        int          colCount            = cols.length;
        Expression[] firstRowExpressions = new Expression[cols.length];


        for (int j = 0; j < exprList.size(); j++) {
            Expression e = (Expression) exprList.get(j);

View Full Code Here

            if (colCount > currentCount) {
                currentIndex = colIndex;
            }
        }


        Index idx = conditions.rangeVar.rangeTable.getIndexForColumn(session,
            currentIndex);


        if (idx == null) {
            it = colIndexSetOther.keySet().iterator();


            while (it.hasNext()) {
                int colIndex = it.nextInt();


                if (colIndex != currentIndex) {
                    idx = conditions.rangeVar.rangeTable.getIndexForColumn(
                        session, colIndex);


                    if (idx != null) {
                        break;
                    }
                }
            }
        }


        if (idx == null) {
            return;
        }


        int[] cols = idx.getColumns();


        for (int j = 0; j < exprList.size(); j++) {
            Expression e = (Expression) exprList.get(j);


            if (e == null) {
                continue;
            }


            boolean isIndexed = false;


            switch (e.getType()) {


                case OpTypes.NOT : {
                    if (e.getLeftNode().getType() == OpTypes.IS_NULL
                            && cols[0]
                               == e.getLeftNode().getLeftNode()
                                   .getColumnIndex()) {
                        isIndexed = true;
                    }


                    break;
                }
                case OpTypes.SMALLER :
                case OpTypes.SMALLER_EQUAL :
                case OpTypes.GREATER :
                case OpTypes.GREATER_EQUAL : {
                    if (cols[0] == e.getLeftNode().getColumnIndex()) {
                        if (e.getRightNode() != null
                                && !e.getRightNode().isCorrelated()) {
                            isIndexed = true;
                        }
                    }


                    break;
                }
            }


            if (isIndexed) {
                Expression[] firstRowExpressions =
                    new Expression[idx.getColumnCount()];


                firstRowExpressions[0] = e;


                conditions.addIndexCondition(firstRowExpressions, idx, 1);
                exprList.set(j, null);

View Full Code Here

            if (in != null) {
                OrderedIntHashSet set = new OrderedIntHashSet();


                in.addLeftColumnsForAllAny(rangeVar, set);


                Index index = rangeVar.rangeTable.getIndexForColumns(session,
                    set, false);
                int colCount = 0;


                for (int j = 0; j < index.getColumnCount(); j++) {
                    if (set.contains(index.getColumns()[j])) {
                        colCount++;
                    }
                }


                RangeVariable newRangeVar =
                    new RangeVariable(in.getRightNode().getTable(), null,
                                      null, null, compileContext);


                newRangeVar.isGenerated = true;


                RangeVariable[] newList =
                    new RangeVariable[rangeVariables.length + 1];


                ArrayUtil.copyAdjustArray(rangeVariables, newList,
                                          newRangeVar, i, 1);


                rangeVariables = newList;


                // make two columns as arg
                Expression[] exprList = new Expression[index.getColumnCount()];


                for (int j = 0; j < colCount; j++) {
                    int leftIndex  = index.getColumns()[j];
                    int rightIndex = set.getIndex(leftIndex);
                    Expression e = new ExpressionLogical(rangeVar, leftIndex,
                                                         newRangeVar,
                                                         rightIndex);

View Full Code Here

        if (columnIndexes == null) {
            return;
        }


        int[] colIndexes;
        Index rangeIndex = select.rangeVariables[0].getSortIndex();


        if (rangeIndex == null) {
            return;
        }


        colIndexes = rangeIndex.getColumns();


        int     count         = ArrayUtil.countTrueElements(sortDescending);
        boolean allDescending = count == columnCount;


        if (!allDescending && count > 0) {
            return;
        }


        if (!select.rangeVariables[0].hasIndexCondition()) {
            Table table = select.rangeVariables[0].getTable();
            Index index = table.getFullIndexForColumns(columnIndexes);


            if (index != null) {
                if (select.rangeVariables[0].setSortIndex(index,
                        allDescending)) {
                    skipSort       = true;

View Full Code Here

        if (((ExpressionColumn) e).getRangeVariable()
                != select.rangeVariables[0]) {
            return false;
        }


        Index rangeIndex = select.rangeVariables[0].getSortIndex();


        if (rangeIndex == null) {
            return false;
        }


        int[] colIndexes = rangeIndex.getColumns();


        if (select.rangeVariables[0].hasIndexCondition()) {
            if (colIndexes[0] != ((ExpressionColumn) e).getColumnIndex()) {
                return false;
            }


            if (opType == OpTypes.MAX) {
                select.rangeVariables[0].reverseOrder();
            }
        } else {
            Table table = select.rangeVariables[0].getTable();
            Index index = table.getIndexForColumn(
                session, ((ExpressionColumn) e).getColumnIndex());


            if (index == null) {
                return false;
            }

View Full Code Here

        return node;
    }


    public void setAccessor(Index key, CachedObject accessor) {


        Index index = (Index) key;


        accessorList[index.getPosition()] = accessor;
    }

View Full Code Here

        throw Error.runtimeError(ErrorCode.U_S0500, "RowStoreAVLDisk");
    }


    public int elementCount(Session session) {


        Index index = this.indexList[0];


        if (elementCount < 0) {
            if (index == null) {
                elementCount = 0;
            } else {

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.hsqldb.index.Index$IndexUse

org.hsqldb.Constraint

org.hsqldb.dbinfo.DatabaseInformationMain

org.hsqldb.ExpressionLogical

org.hsqldb.ParserDDL

org.hsqldb.persist.RowStoreAVL

org.hsqldb.persist.RowStoreAVLDisk

org.hsqldb.persist.RowStoreAVLHybrid

org.hsqldb.persist.RowStoreAVLMemory

org.hsqldb.QuerySpecification

org.hsqldb.RangeVariable

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.