Package | Description |
---|---|
org.h2.command.dml |
Contains DML (data manipulation language) and related SQL statements.
|
org.h2.constraint |
Database constraints such as check constraints, unique constraints, and referential constraints.
|
org.h2.engine |
Contains high level classes of the database and classes that don't fit in another sub-package.
|
org.h2.expression |
Expressions include mathematical operations, conditions, simple values, and functions.
|
org.h2.index |
Various table index implementations, as well as cursors to navigate in an index.
|
org.h2.mvstore.db |
Helper classes to use the MVStore in the H2 database.
|
org.h2.result |
Implementation of row and internal result sets.
|
org.h2.table |
Classes related to a table and table meta data.
|
Modifier and Type | Method and Description |
---|---|
TableFilter |
SelectListColumnResolver.getTableFilter() |
TableFilter |
Select.getTopTableFilter() |
Modifier and Type | Method and Description |
---|---|
ArrayList<TableFilter> |
Select.getTopFilters() |
Modifier and Type | Method and Description |
---|---|
void |
Select.addTableFilter(TableFilter filter,
boolean isTop)
Add a table to the query.
|
void |
SelectUnion.setEvaluatable(TableFilter tableFilter,
boolean b) |
abstract void |
Query.setEvaluatable(TableFilter tableFilter,
boolean b)
Change the evaluatable flag.
|
void |
Select.setEvaluatable(TableFilter tableFilter,
boolean b) |
void |
Delete.setTableFilter(TableFilter tableFilter) |
void |
Update.setTableFilter(TableFilter tableFilter) |
Modifier and Type | Method and Description |
---|---|
void |
ConstraintCheck.setTableFilter(TableFilter filter) |
Modifier and Type | Method and Description |
---|---|
void |
Session.pushSubQueryInfo(int[] masks,
TableFilter[] filters,
int filter,
SortOrder sortOrder)
Add a subquery info on top of the subquery info stack.
|
Modifier and Type | Method and Description |
---|---|
TableFilter |
ExpressionColumn.getTableFilter() |
Modifier and Type | Method and Description |
---|---|
void |
Comparison.addFilterConditions(TableFilter filter,
boolean outerJoin) |
void |
Expression.addFilterConditions(TableFilter filter,
boolean outerJoin)
Add conditions to a table filter if they can be evaluated.
|
void |
ConditionNot.addFilterConditions(TableFilter filter,
boolean outerJoin) |
void |
ConditionAndOr.addFilterConditions(TableFilter filter,
boolean outerJoin) |
static HashSet<Column> |
ExpressionVisitor.allColumnsForTableFilters(TableFilter[] filters)
Get the set of columns of all tables.
|
void |
ExpressionColumn.createIndexConditions(Session session,
TableFilter filter) |
void |
Comparison.createIndexConditions(Session session,
TableFilter filter) |
void |
Expression.createIndexConditions(Session session,
TableFilter filter)
Create index conditions if possible and attach them to the table filter.
|
void |
ConditionIn.createIndexConditions(Session session,
TableFilter filter) |
void |
ValueExpression.createIndexConditions(Session session,
TableFilter filter) |
void |
CompareLike.createIndexConditions(Session session,
TableFilter filter) |
void |
ConditionInConstantSet.createIndexConditions(Session session,
TableFilter filter) |
void |
ConditionInSelect.createIndexConditions(Session session,
TableFilter filter) |
void |
ConditionAndOr.createIndexConditions(Session session,
TableFilter filter) |
void |
Subquery.setEvaluatable(TableFilter tableFilter,
boolean b) |
void |
JavaFunction.setEvaluatable(TableFilter tableFilter,
boolean b) |
void |
ExpressionColumn.setEvaluatable(TableFilter tableFilter,
boolean b) |
void |
Wildcard.setEvaluatable(TableFilter tableFilter,
boolean b) |
void |
Alias.setEvaluatable(TableFilter tableFilter,
boolean b) |
void |
ConditionExists.setEvaluatable(TableFilter tableFilter,
boolean b) |
void |
Comparison.setEvaluatable(TableFilter tableFilter,
boolean b) |
void |
SequenceValue.setEvaluatable(TableFilter tableFilter,
boolean b) |
abstract void |
Expression.setEvaluatable(TableFilter tableFilter,
boolean value)
Tell the expression columns whether the table filter can return values
now.
|
void |
ConditionIn.setEvaluatable(TableFilter tableFilter,
boolean b) |
void |
ValueExpression.setEvaluatable(TableFilter tableFilter,
boolean b) |
void |
CompareLike.setEvaluatable(TableFilter tableFilter,
boolean b) |
void |
Variable.setEvaluatable(TableFilter tableFilter,
boolean value) |
void |
Function.setEvaluatable(TableFilter tableFilter,
boolean b) |
void |
Operation.setEvaluatable(TableFilter tableFilter,
boolean b) |
void |
JavaAggregate.setEvaluatable(TableFilter tableFilter,
boolean b) |
void |
ConditionInConstantSet.setEvaluatable(TableFilter tableFilter,
boolean b) |
void |
ConditionInSelect.setEvaluatable(TableFilter tableFilter,
boolean b) |
void |
Aggregate.setEvaluatable(TableFilter tableFilter,
boolean b) |
void |
Rownum.setEvaluatable(TableFilter tableFilter,
boolean b) |
void |
ConditionNot.setEvaluatable(TableFilter tableFilter,
boolean b) |
void |
ConditionAndOr.setEvaluatable(TableFilter tableFilter,
boolean b) |
void |
ExpressionList.setEvaluatable(TableFilter tableFilter,
boolean b) |
void |
Parameter.setEvaluatable(TableFilter tableFilter,
boolean b) |
Modifier and Type | Method and Description |
---|---|
IndexLookupBatch |
BaseIndex.createLookupBatch(TableFilter[] filters,
int filter) |
IndexLookupBatch |
ViewIndex.createLookupBatch(TableFilter[] filters,
int filter) |
IndexLookupBatch |
Index.createLookupBatch(TableFilter[] filters,
int filter)
Creates new lookup batch.
|
IndexLookupBatch |
MultiVersionIndex.createLookupBatch(TableFilter[] filters,
int filter) |
Cursor |
BaseIndex.find(TableFilter filter,
SearchRow first,
SearchRow last) |
Cursor |
SpatialTreeIndex.find(TableFilter filter,
SearchRow first,
SearchRow last) |
Cursor |
TreeIndex.find(TableFilter filter,
SearchRow first,
SearchRow last) |
Cursor |
Index.find(TableFilter filter,
SearchRow first,
SearchRow last)
Find a row or a list of rows and create a cursor to iterate over the
result.
|
Cursor |
MultiVersionIndex.find(TableFilter filter,
SearchRow first,
SearchRow last) |
Cursor |
SpatialTreeIndex.findByGeometry(TableFilter filter,
SearchRow first,
SearchRow last,
SearchRow intersection) |
Cursor |
ViewIndex.findByGeometry(TableFilter filter,
SearchRow first,
SearchRow last,
SearchRow intersection) |
Cursor |
SpatialIndex.findByGeometry(TableFilter filter,
SearchRow first,
SearchRow last,
SearchRow intersection)
Find a row or a list of rows and create a cursor to iterate over the
result.
|
double |
PageBtreeIndex.getCost(Session session,
int[] masks,
TableFilter[] filters,
int filter,
SortOrder sortOrder,
HashSet<Column> allColumnsSet) |
double |
FunctionIndex.getCost(Session session,
int[] masks,
TableFilter[] filters,
int filter,
SortOrder sortOrder,
HashSet<Column> allColumnsSet) |
double |
SpatialTreeIndex.getCost(Session session,
int[] masks,
TableFilter[] filters,
int filter,
SortOrder sortOrder,
HashSet<Column> allColumnsSet) |
double |
RangeIndex.getCost(Session session,
int[] masks,
TableFilter[] filters,
int filter,
SortOrder sortOrder,
HashSet<Column> allColumnsSet) |
double |
ScanIndex.getCost(Session session,
int[] masks,
TableFilter[] filters,
int filter,
SortOrder sortOrder,
HashSet<Column> allColumnsSet) |
double |
PageDataIndex.getCost(Session session,
int[] masks,
TableFilter[] filters,
int filter,
SortOrder sortOrder,
HashSet<Column> allColumnsSet) |
double |
TreeIndex.getCost(Session session,
int[] masks,
TableFilter[] filters,
int filter,
SortOrder sortOrder,
HashSet<Column> allColumnsSet) |
double |
HashIndex.getCost(Session session,
int[] masks,
TableFilter[] filters,
int filter,
SortOrder sortOrder,
HashSet<Column> allColumnsSet) |
double |
PageDelegateIndex.getCost(Session session,
int[] masks,
TableFilter[] filters,
int filter,
SortOrder sortOrder,
HashSet<Column> allColumnsSet) |
double |
LinkedIndex.getCost(Session session,
int[] masks,
TableFilter[] filters,
int filter,
SortOrder sortOrder,
HashSet<Column> allColumnsSet) |
double |
NonUniqueHashIndex.getCost(Session session,
int[] masks,
TableFilter[] filters,
int filter,
SortOrder sortOrder,
HashSet<Column> allColumnsSet) |
double |
MetaIndex.getCost(Session session,
int[] masks,
TableFilter[] filters,
int filter,
SortOrder sortOrder,
HashSet<Column> allColumnsSet) |
double |
ViewIndex.getCost(Session session,
int[] masks,
TableFilter[] filters,
int filter,
SortOrder sortOrder,
HashSet<Column> allColumnsSet) |
double |
Index.getCost(Session session,
int[] masks,
TableFilter[] filters,
int filter,
SortOrder sortOrder,
HashSet<Column> allColumnsSet)
Estimate the cost to search for rows given the search mask.
|
double |
MultiVersionIndex.getCost(Session session,
int[] masks,
TableFilter[] filters,
int filter,
SortOrder sortOrder,
HashSet<Column> allColumnsSet) |
protected long |
BaseIndex.getCostRangeIndex(int[] masks,
long rowCount,
TableFilter[] filters,
int filter,
SortOrder sortOrder,
boolean isScanIndex,
HashSet<Column> allColumnsSet)
Calculate the cost for the given mask as if this index was a typical
b-tree range index.
|
Constructor and Description |
---|
IndexCursor(TableFilter filter) |
ViewIndex(TableView view,
ViewIndex index,
Session session,
int[] masks,
TableFilter[] filters,
int filter,
SortOrder sortOrder)
Constructor for plan item generation.
|
Modifier and Type | Method and Description |
---|---|
Cursor |
MVSpatialIndex.find(TableFilter filter,
SearchRow first,
SearchRow last) |
Cursor |
MVSpatialIndex.findByGeometry(TableFilter filter,
SearchRow first,
SearchRow last,
SearchRow intersection) |
double |
MVSpatialIndex.getCost(Session session,
int[] masks,
TableFilter[] filters,
int filter,
SortOrder sortOrder,
HashSet<Column> allColumnsSet) |
double |
MVDelegateIndex.getCost(Session session,
int[] masks,
TableFilter[] filters,
int filter,
SortOrder sortOrder,
HashSet<Column> allColumnsSet) |
double |
MVSecondaryIndex.getCost(Session session,
int[] masks,
TableFilter[] filters,
int filter,
SortOrder sortOrder,
HashSet<Column> allColumnsSet) |
double |
MVPrimaryIndex.getCost(Session session,
int[] masks,
TableFilter[] filters,
int filter,
SortOrder sortOrder,
HashSet<Column> allColumnsSet) |
Modifier and Type | Method and Description |
---|---|
Column |
SortOrder.getColumn(int index,
TableFilter filter)
Get the column for the given table filter, if the sort column is for this
filter.
|
Modifier and Type | Method and Description |
---|---|
TableFilter[] |
SubQueryInfo.getFilters() |
TableFilter[] |
Plan.getFilters()
The the list of tables.
|
TableFilter |
TableFilter.getJoin() |
TableFilter |
TableFilter.getNestedJoin() |
TableFilter |
ColumnResolver.getTableFilter()
Get the table filter.
|
TableFilter |
TableFilter.getTableFilter() |
TableFilter |
SingleColumnResolver.getTableFilter() |
Modifier and Type | Method and Description |
---|---|
void |
TableFilter.TableFilterVisitor.accept(TableFilter f)
This method is called for each nested or joined table filter.
|
void |
TableFilter.addJoin(TableFilter filter,
boolean outer,
boolean nested,
Expression on)
Add a joined table.
|
static IndexLookupBatch |
JoinBatch.createFakeIndexLookupBatch(TableFilter filter)
Create fake index lookup batch for non-batched table filter.
|
PlanItem |
Table.getBestPlanItem(Session session,
int[] masks,
TableFilter[] filters,
int filter,
SortOrder sortOrder,
HashSet<Column> allColumnsSet)
Get the best plan for the given search mask.
|
PlanItem |
TableView.getBestPlanItem(Session session,
int[] masks,
TableFilter[] filters,
int filter,
SortOrder sortOrder,
HashSet<Column> allColumnsSet) |
PlanItem |
TableFilter.getBestPlanItem(Session s,
TableFilter[] filters,
int filter,
HashSet<Column> allColumnsSet)
Get the best plan item (index, cost) to use use for the current join
order.
|
PlanItem |
Plan.getItem(TableFilter filter)
Get the plan item for the given table.
|
Index |
Table.getScanIndex(Session session,
int[] masks,
TableFilter[] filters,
int filter,
SortOrder sortOrder,
HashSet<Column> allColumnsSet)
Get the scan index for this table.
|
Index |
TableView.getScanIndex(Session session,
int[] masks,
TableFilter[] filters,
int filter,
SortOrder sortOrder,
HashSet<Column> allColumnsSet) |
JoinBatch |
TableFilter.prepareJoinBatch(JoinBatch jb,
TableFilter[] filters,
int filter)
Attempt to initialize batched join.
|
void |
JoinBatch.register(TableFilter filter,
IndexLookupBatch lookupBatch)
Register the table filter and lookup batch.
|
void |
TableFilter.setEvaluatable(TableFilter filter,
boolean b)
Update the filter and join conditions of this and all joined tables with
the information that the given table filter and all nested filter can now
return rows or not.
|
Constructor and Description |
---|
JoinBatch(int filtersCount,
TableFilter additionalFilter) |
Plan(TableFilter[] filters,
int count,
Expression condition)
Create a query plan with the given order.
|
SubQueryInfo(SubQueryInfo upper,
int[] masks,
TableFilter[] filters,
int filter,
SortOrder sortOrder) |
Copyright © 2017 JBoss by Red Hat. All rights reserved.