H2 Database Engine 2.3.232 · org.h2.index.RecursiveIndex

Modifier and Type	Field and Description
private final SessionLocal	createSession

Access	Constructor and Description
public	RecursiveIndex(QueryExpressionTable the query expression table table, String the query SQL querySQL, ArrayList<Parameter> the original parameters originalParameters, SessionLocal the session session) Creates a new instance of a recursive index.

Method Summary

Modifier and Type	Method and Description
public Cursor	find(SessionLocal the session session, SearchRow the first row, or null for no limit first, SearchRow the last row, or null for no limit last, boolean if true, iterate in reverse (descending) order reverse) Implements abstract org.h2.index.Index.find. Find a row or a list of rows and create a cursor to iterate over the result.
public double	getCost(SessionLocal the session session, int[] per-column comparison bit masks, null means 'always false', see constants in IndexCondition masks, TableFilter[] all joined table filters filters, int the current table filter index filter, SortOrder the sort order sortOrder, AllColumnsForPlan the set of all columns allColumnsSet) Implements abstract org.h2.index.Index.getCost. Estimate the cost to search for rows given the search mask.
public boolean	isExpired() Implements abstract org.h2.index.QueryExpressionIndex.isExpired.

Inherited from org.h2.index.QueryExpressionIndex:: add checkRename close getPlanSQL getQuery getRowCount getRowCountApproximation needRebuild remove remove truncate

Field Detail

createSession	back to summary
private final SessionLocal createSession

Constructor Detail

RecursiveIndex	back to summary
public RecursiveIndex(QueryExpressionTable table, String querySQL, ArrayList<Parameter> originalParameters, SessionLocal session) Creates a new instance of a recursive index. Parameters table:QueryExpressionTable the query expression table querySQL:String the query SQL originalParameters:ArrayList<Parameter> the original parameters session:SessionLocal the session

RecursiveIndex

back to summary

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

Creates a new instance of a recursive index.

Parameters

table:QueryExpressionTable: the query expression table
querySQL:String: the query SQL
originalParameters:ArrayList<Parameter>: the original parameters
session:SessionLocal: the session

Method Detail

find	back to summary
public Cursor find(SessionLocal session, SearchRow first, SearchRow last, boolean reverse) Implements abstract org.h2.index.Index.find. Doc from org.h2.index.Index.find. Find a row or a list of rows and create a cursor to iterate over the result. Parameters session:SessionLocal the session first:SearchRow the first row, or null for no limit last:SearchRow the last row, or null for no limit reverse:boolean if true, iterate in reverse (descending) order Returns:Cursor the cursor to iterate over the results Annotations @Override

find

back to summary

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

Implements abstract org.h2.index.Index.find.

Doc from org.h2.index.Index.find.

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

Parameters

session:SessionLocal: the session
first:SearchRow: the first row, or null for no limit
last:SearchRow: the last row, or null for no limit
reverse:boolean: if true, iterate in reverse (descending) order

Returns:Cursor

the cursor to iterate over the results

Annotations

@Override

getCost	back to summary
public double getCost(SessionLocal session, int[] masks, TableFilter[] filters, int filter, SortOrder sortOrder, AllColumnsForPlan allColumnsSet) Implements abstract org.h2.index.Index.getCost. Doc from org.h2.index.Index.getCost. 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. Parameters session:SessionLocal the session masks:int[] per-column comparison bit masks, null means 'always false', see constants in IndexCondition filters:TableFilter[] all joined table filters filter:int the current table filter index sortOrder:SortOrder the sort order allColumnsSet:AllColumnsForPlan the set of all columns Returns:double the estimated cost Annotations @Override

getCost

back to summary

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

Implements abstract org.h2.index.Index.getCost.

Doc from org.h2.index.Index.getCost.

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.

Parameters

session:SessionLocal: the session
masks:int[]: per-column comparison bit masks, null means 'always false', see constants in IndexCondition
filters:TableFilter[]: all joined table filters
filter:int: the current table filter index
sortOrder:SortOrder: the sort order
allColumnsSet:AllColumnsForPlan: the set of all columns

Returns:double