Package org.h2.index
Class MetaIndex
java.lang.Object
org.h2.engine.DbObject
org.h2.schema.SchemaObject
org.h2.index.Index
org.h2.index.MetaIndex
- All Implemented Interfaces:
HasSQL
The index implementation for meta data tables.
-
Field Summary
FieldsFields inherited from class org.h2.index.Index
columnIds, columns, indexColumns, indexType, table, 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 -
Method Summary
Modifier and TypeMethodDescriptionvoid
add
(SessionLocal session, Row row) Add a row to the index.void
Check if renaming is allowed.void
close
(SessionLocal session) Close this index.find
(SessionLocal session, SearchRow first, SearchRow last) Find a row or a list of rows and create a cursor to iterate over the result.int
getColumnIndex
(Column col) Get the index of a column in the list of index columnsdouble
getCost
(SessionLocal session, int[] masks, TableFilter[] filters, int filter, SortOrder sortOrder, AllColumnsForPlan allColumnsSet) Estimate the cost to search for rows given the search mask.Construct the CREATE ...long
Get the used disk space for this index.Get the message to show in a EXPLAIN statement.long
getRowCount
(SessionLocal session) Get the row count of this table, for the given session.long
getRowCountApproximation
(SessionLocal session) Get the approximated row count for this table.boolean
isFirstColumn
(Column column) Check if the given column is the first for this indexboolean
Check if the index needs to be rebuilt.void
remove
(SessionLocal session) Remove the index.void
remove
(SessionLocal session, Row row) Remove a row from the index.void
truncate
(SessionLocal session) Remove all rows from the index.Methods inherited from class org.h2.index.Index
canFindNext, canGetFirstOrLast, canScan, checkIndexColumnTypes, compareRows, findFirstOrLast, findNext, getColumns, getCostRangeIndex, getCreateSQLForCopy, getDuplicateKeyException, getDuplicatePrimaryKeyMessage, getIndexColumns, getIndexType, getRow, getRowFactory, getTable, getType, getUniqueColumnCount, getUniqueRowFactory, isFindUsingFullTableScan, isHidden, isRowIdIndex, mayHaveNullDuplicates, removeChildrenAndResources, update
Methods inherited from class org.h2.schema.SchemaObject
getSchema, getSQL, getSQL
Methods inherited from class org.h2.engine.DbObject
getChildren, getComment, getCreateSQLForMeta, getDatabase, getDropSQL, getId, getModificationId, getName, invalidate, isTemporary, isValid, rename, setComment, setModified, setObjectName, setTemporary, toString
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
Methods inherited from interface org.h2.util.HasSQL
getTraceSQL
-
Field Details
-
meta
-
scan
private final boolean scan
-
-
Constructor Details
-
MetaIndex
-
-
Method Details
-
close
Description copied from class:Index
Close this index. -
add
Description copied from class:Index
Add a row to the index. -
remove
Description copied from class:Index
Remove a row from the index. -
find
Description copied from class:Index
Find a row or a list of rows and create a cursor to iterate over the result. -
getCost
public double getCost(SessionLocal session, int[] masks, TableFilter[] filters, int filter, SortOrder sortOrder, AllColumnsForPlan allColumnsSet) 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 classIndex
- Parameters:
session
- the sessionmasks
- per-column comparison bit masks, null means 'always false', see constants in IndexConditionfilters
- all joined table filtersfilter
- the current table filter indexsortOrder
- the sort orderallColumnsSet
- the set of all columns- Returns:
- the estimated cost
-
truncate
Description copied from class:Index
Remove all rows from the index. -
remove
Description copied from class:Index
Remove the index. -
getColumnIndex
Description copied from class:Index
Get the index of a column in the list of index columns- Overrides:
getColumnIndex
in classIndex
- Parameters:
col
- the column- Returns:
- the index (0 meaning first column)
-
isFirstColumn
Description copied from class:Index
Check if the given column is the first for this index- Overrides:
isFirstColumn
in classIndex
- Parameters:
column
- the column- Returns:
- true if the given columns is the first
-
checkRename
public void checkRename()Description copied from class:DbObject
Check if renaming is allowed. Does nothing when allowed.- Overrides:
checkRename
in classDbObject
-
needRebuild
public boolean needRebuild()Description copied from class:Index
Check if the index needs to be rebuilt. This method is called after opening an index.- Specified by:
needRebuild
in classIndex
- Returns:
- true if a rebuild is required.
-
getCreateSQL
Description copied from class:DbObject
Construct the CREATE ... SQL statement for this object.- Overrides:
getCreateSQL
in classIndex
- Returns:
- the SQL statement
-
getRowCount
Description copied from class:Index
Get the row count of this table, for the given session.- Specified by:
getRowCount
in classIndex
- Parameters:
session
- the session- Returns:
- the row count
-
getRowCountApproximation
Description copied from class:Index
Get the approximated row count for this table.- Specified by:
getRowCountApproximation
in classIndex
- Parameters:
session
- the session- Returns:
- the approximated row count
-
getDiskSpaceUsed
public long getDiskSpaceUsed()Description copied from class:Index
Get the used disk space for this index.- Overrides:
getDiskSpaceUsed
in classIndex
- Returns:
- the estimated number of bytes
-
getPlanSQL
Description copied from class:Index
Get the message to show in a EXPLAIN statement.- Overrides:
getPlanSQL
in classIndex
- Returns:
- the plan
-