Package org.h2.index

Class RegularQueryExpressionIndex

java.lang.Object

org.h2.engine.DbObject

org.h2.schema.SchemaObject

org.h2.index.Index

org.h2.index.QueryExpressionIndex

org.h2.index.RegularQueryExpressionIndex

All Implemented Interfaces:

SpatialIndex, HasSQL

public final class RegularQueryExpressionIndex
extends QueryExpressionIndex
implements SpatialIndex

A regular query expression 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
RegularQueryExpressionIndex(QueryExpressionTable table, java.lang.String querySQL, java.util.ArrayList<Parameter> originalParameters, SessionLocal session, int[] masks)	Creates a new instance of a regular query expression 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.
Cursor	findByGeometry(SessionLocal session, SearchRow first, SearchRow last, boolean reverse, SearchRow intersection)	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

RegularQueryExpressionIndex

public RegularQueryExpressionIndex(QueryExpressionTable table,
                                   java.lang.String querySQL,
                                   java.util.ArrayList<Parameter> originalParameters,
                                   SessionLocal session,
                                   int[] masks)

Creates a new instance of a regular query expression index.

Parameters:

table - the query expression table

querySQL - the query SQL

originalParameters - the original parameters

session - the session

masks - the masks

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

findByGeometry

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

Description copied from interface: SpatialIndex

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

Specified by:

findByGeometry in interface SpatialIndex

Parameters:

session - the session

first - the lower bound

last - the upper bound

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

intersection - the geometry which values should intersect with, or null for anything

Returns:

the cursor to iterate over the results