Examples of org.hsqldb.index.Index

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

        return node;
    }


    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 indexedColCount = 0;


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


                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 < indexedColCount; j++) {
                    int leftIndex  = index.getColumns()[j];
                    int rightIndex = set.getIndex(leftIndex);
                    Expression e = new ExpressionLogical(rangeVar, leftIndex,
                                                         newRangeVar,
                                                         rightIndex);

View Full Code Here

        bestIndexForColumn = new int[colTypes.length];


        ArrayUtil.fillArray(bestIndexForColumn, -1);


        for (int i = 0; i < indexList.length; i++) {
            Index index     = indexList[i];
            int[] cols      = index.getColumns();
            int   colsCount = index.getVisibleColumns();


            if (colsCount == 0) {
                continue;
            }


            if (i == 0) {
                isStrict = true;
            }


            if (bestIndexForColumn[cols[0]] == -1) {
                bestIndexForColumn[cols[0]] = i;
            } else {
                Index existing = indexList[bestIndexForColumn[cols[0]]];


                if (colsCount > existing.getColumns().length) {
                    bestIndexForColumn[cols[0]] = i;
                }
            }


            if (!index.isUnique()) {

View Full Code Here


    public final void createPrimaryIndex(int[] pkcols, Type[] pktypes,
                                         HsqlName name) {


        long id = database.persistentStoreCollection.getNextId();
        Index newIndex = database.logger.newIndex(name, id, this, pkcols,
            null, null, pktypes, true, pkcols.length > 0, pkcols.length > 0,
            false);


        try {
            addIndex(null, newIndex);

View Full Code Here

    public final Index createAndAddIndexStructure(Session session,
            HsqlName name, int[] columns, boolean[] descending,
            boolean[] nullsLast, boolean unique, boolean constraint,
            boolean forward) {


        Index newindex = createIndexStructure(name, columns, descending,
                                              nullsLast, unique, constraint,
                                              forward);


        addIndex(session, newindex);

View Full Code Here

            cols[j]  = columns[j];
            types[j] = colTypes[cols[j]];
        }


        long id = database.persistentStoreCollection.getNextId();
        Index newIndex = database.logger.newIndex(name, id, this, cols,
            descending, nullsLast, types, false, unique, constraint, forward);


        return newIndex;
    }

View Full Code Here

    final void addIndex(Session session, Index index) {


        int i = 0;


        for (; i < indexList.length; i++) {
            Index current = indexList[i];
            int order = index.getIndexOrderValue()
                        - current.getIndexOrderValue();


            if (order < 0) {
                break;
            }
        }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.hsqldb.index.Index

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.