Package org.h2.index

Class RecursiveIndex

java.lang.Object

org.h2.engine.DbObject

org.h2.schema.SchemaObject

org.h2.index.Index

org.h2.index.QueryExpressionIndex

org.h2.index.RecursiveIndex

All Implemented Interfaces:

HasSQL

public final class RecursiveIndex
extends QueryExpressionIndex

A recursive index.

Field Summary

Fields inherited from class org.h2.index.Index

columnIds, columns, indexColumns, indexType, uniqueColumnColumn

Fields inherited from class org.h2.engine.DbObject

AGGREGATE, comment, COMMENT, CONSTANT, CONSTRAINT, database, DOMAIN, FUNCTION_ALIAS, INDEX, RIGHT, ROLE, SCHEMA, SEQUENCE, SETTING, SYNONYM, TABLE_OR_VIEW, trace, TRIGGER, USER

Fields inherited from interface org.h2.util.HasSQL

ADD_PLAN_INFORMATION, DEFAULT_SQL_FLAGS, NO_CASTS, QUOTE_ONLY_WHEN_REQUIRED, REPLACE_LOBS_FOR_TRACE, TRACE_SQL_FLAGS

Constructor Summary

Constructors

Constructor	Description
RecursiveIndex(QueryExpressionTable table, java.lang.String querySQL, java.util.ArrayList<Parameter> originalParameters, SessionLocal session)	Creates a new instance of a recursive index.

Method Summary

Modifier and Type	Method	Description
Cursor	find(SessionLocal session, SearchRow first, SearchRow last, boolean reverse)	Find a row or a list of rows and create a cursor to iterate over the result.
double	getCost(SessionLocal session, int[] masks, TableFilter[] filters, int filter, SortOrder sortOrder, AllColumnsForPlan allColumnsSet, boolean isSelectCommand)	Estimate the cost to search for rows given the search mask.
boolean	isExpired()

Methods inherited from class org.h2.index.QueryExpressionIndex

add, checkRename, close, getPlanSQL, getQuery, getRowCount, getRowCountApproximation, needRebuild, remove, remove, truncate

Methods inherited from class org.h2.index.Index

areRowsEquivalent, canFindNext, canGetFirstOrLast, canScan, checkIndexColumnTypes, compareRows, findFirstOrLast, findNext, getColumnIndex, getColumns, getCostRangeIndex, getCreateSQL, getCreateSQLForCopy, getDiskSpaceUsed, getDuplicateKeyException, getDuplicatePrimaryKeyMessage, getIndexColumns, getIndexType, getRow, getRowFactory, getTable, getType, getUniqueColumnCount, getUniqueRowFactory, isFindUsingFullTableScan, isFirstColumn, isRowIdIndex, needsUniqueCheck, removeChildrenAndResources, update

Methods inherited from class org.h2.schema.SchemaObject

getSchema, getSQL, getSQL

Methods inherited from class org.h2.engine.DbObject

equals, getChildren, getComment, getCreateSQLForMeta, getDatabase, getDropSQL, getId, getModificationId, getName, hashCode, invalidate, isTemporary, isValid, rename, setComment, setModified, setObjectName, setTemporary, toString

Methods inherited from class java.lang.Object

clone, finalize, getClass, notify, notifyAll, wait, wait, wait

Methods inherited from interface org.h2.util.HasSQL

getTraceSQL

Constructor Detail

RecursiveIndex

public RecursiveIndex(QueryExpressionTable table,
                      java.lang.String querySQL,
                      java.util.ArrayList<Parameter> originalParameters,
                      SessionLocal session)

Creates a new instance of a recursive index.

Parameters:

table - the query expression table

querySQL - the query SQL

originalParameters - the original parameters

session - the session

Method Detail

isExpired

public boolean isExpired()

Specified by:

isExpired in class QueryExpressionIndex

getCost

public double getCost(SessionLocal session,
                      int[] masks,
                      TableFilter[] filters,
                      int filter,
                      SortOrder sortOrder,
                      AllColumnsForPlan allColumnsSet,
                      boolean isSelectCommand)

Description copied from class: Index

Estimate the cost to search for rows given the search mask. There is one element per column in the search mask. For possible search masks, see IndexCondition.

Specified by:

getCost in class Index

Parameters:

session - the session

masks - per-column comparison bit masks, null means 'always false', see constants in IndexCondition

filters - all joined table filters

filter - the current table filter index

sortOrder - the sort order

allColumnsSet - the set of all columns

isSelectCommand - is this for an SELECT command

Returns:

the estimated cost

find

public Cursor find(SessionLocal session,
                   SearchRow first,
                   SearchRow last,
                   boolean reverse)

Description copied from class: Index

Find a row or a list of rows and create a cursor to iterate over the result.

Specified by:

find in class Index

Parameters:

session - the session

first - the first row, or null for no limit

last - the last row, or null for no limit

reverse - if true, iterate in reverse (descending) order

Returns:

the cursor to iterate over the results