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

    OrderedHashSet getContainingIndexNames(int colIndex) {


        OrderedHashSet set = new OrderedHashSet();


        for (int i = 0, size = indexList.length; i < size; i++) {
            Index index = indexList[i];


            if (ArrayUtil.find(index.getColumns(), colIndex) != -1) {
                set.add(index.getName());
            }
        }


        return set;
    }

View Full Code Here

            case TableBase.FUNCTION_TABLE :
            case TableBase.SYSTEM_SUBQUERY :
            case TableBase.INFO_SCHEMA_TABLE :
            case TableBase.VIEW_TABLE :
            case TableBase.TEMP_TABLE : {
                Index index = createIndexForColumns(session, new int[]{ col });


                return index;
            }
        }

View Full Code Here

    /**
     *  Used to create an index automatically for system and temp tables.
     */
    Index createIndexForColumns(Session session, int[] columns) {


        Index index = null;
        HsqlName indexName = database.nameManager.newAutoName("IDX_T",
            getSchemaName(), getName(), SchemaObject.INDEX);


        try {
            index = createAndAddIndexStructure(session, indexName, columns,

View Full Code Here

            case TableBase.FUNCTION_TABLE :
            case TableBase.SYSTEM_SUBQUERY :
            case TableBase.INFO_SCHEMA_TABLE :
            case TableBase.VIEW_TABLE :
            case TableBase.TEMP_TABLE : {
                Index index = createIndexForColumns(session, cols);


                return index;
            }
        }

View Full Code Here

    synchronized Index getIndexForColumns(Session session,
                                          OrderedIntHashSet set,
                                          boolean ordered) {


        int   maxMatchCount = 0;
        Index selected      = null;


        if (set.isEmpty()) {
            return null;
        }


        for (int i = 0, count = indexList.length; i < count; i++) {
            Index currentindex = getIndex(i);
            int[] indexcols    = currentindex.getColumns();
            int matchCount = ordered ? set.getOrderedStartMatchCount(indexcols)
                                     : set.getStartMatchCount(indexcols);


            if (matchCount == 0) {
                continue;

View Full Code Here

    }


    public RowIterator rowIteratorClustered(Session session) {


        PersistentStore store = getRowStore(session);
        Index           index = getClusteredIndex();


        if (index == null) {
            index = getPrimaryIndex();
        }


        return index.firstRow(session, store);
    }

View Full Code Here

        return index.firstRow(session, store);
    }


    public RowIterator rowIteratorClustered(PersistentStore store) {


        Index index = getClusteredIndex();


        if (index == null) {
            index = getPrimaryIndex();
        }


        return index.firstRow(store);
    }

View Full Code Here


        if (collations != null) {
            return;
        }


        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

    }


    public Index getNewIndex(Session session, TableBase table) {


        if (hasOrder()) {
            Index orderIndex = table.createAndAddIndexStructure(session, null,
                sortOrder, sortDescending, sortNullsLast, false, false, false);


            if (collations != null) {
                for (int i = 0; i < columnCount; i++) {
                    if (collations[i] != null) {
                        Type type = orderIndex.getColumnTypes()[i];


                        type = Type.getType(type.typeCode,
                                            type.getCharacterSet(),
                                            collations[i], type.precision,
                                            type.scale);
                        orderIndex.getColumnTypes()[i] = type;
                    }
                }
            }


            return orderIndex;

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.