columnIds, columns, indexColumns, indexType, isMultiVersion, table
comment, database, trace
AGGREGATE, COMMENT, CONSTANT, CONSTRAINT, FUNCTION_ALIAS, INDEX, RIGHT, ROLE, SCHEMA, SEQUENCE, SETTING, TABLE_OR_VIEW, TRIGGER, USER, USER_DATATYPE
Constructor and Description |
---|
MVSecondaryIndex(Database db,
MVTable table,
int id,
String indexName,
IndexColumn[] columns,
IndexType indexType) |
Modifier and Type | Method and Description |
---|---|
void |
add(Session session,
Row row)
Add a row to the index.
|
void |
addBufferedRows(List<String> bufferNames)
Add all the index data from the buffers to the index.
|
void |
addRowsToBuffer(List<Row> rows,
String bufferName)
Add the rows to a temporary storage (not to the index yet).
|
boolean |
canFindNext()
Check if the index can get the next higher value.
|
boolean |
canGetFirstOrLast()
Check if the index can directly look up the lowest or highest value of a
column.
|
void |
checkRename()
Check if this object can be renamed.
|
void |
close(Session session)
Close this index.
|
Cursor |
find(Session session,
SearchRow first,
SearchRow last)
Find a row or a list of rows and create a cursor to iterate over the
result.
|
Cursor |
findFirstOrLast(Session session,
boolean first)
Find the first (or last) value of this index.
|
Cursor |
findNext(Session session,
SearchRow higherThan,
SearchRow last)
Find a row or a list of rows that is larger and create a cursor to
iterate over the result.
|
double |
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.
|
long |
getDiskSpaceUsed()
Get the used disk space for this index.
|
long |
getRowCount(Session session)
Get the row count of this table, for the given session.
|
long |
getRowCountApproximation()
Get the approximated row count for this table.
|
MVTable |
getTable()
Get the table on which this index is based.
|
boolean |
needRebuild()
Check if the index needs to be rebuilt.
|
void |
remove(Session session)
Remove the index.
|
void |
remove(Session session,
Row row)
Remove a row from the index.
|
void |
truncate(Session session)
Remove all rows from the index.
|
canScan, checkIndexColumnTypes, commit, compareRows, containsNullAndAllowMultipleNull, createLookupBatch, find, getColumnIndex, getColumns, getCostRangeIndex, getCreateSQL, getCreateSQLForCopy, getDropSQL, getDuplicateKeyException, getIndexColumns, getIndexType, getPlanSQL, getRow, getType, initBaseIndex, isHidden, isRowIdIndex, removeChildrenAndResources, setSortedInsertMode
getSchema, getSQL, initSchemaObjectBase
getChildren, getComment, getDatabase, getId, getModificationId, getName, initDbObjectBase, invalidate, isTemporary, rename, setComment, setModified, setObjectName, setTemporary, toString
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
canScan, commit, compareRows, createLookupBatch, find, getColumnIndex, getColumns, getIndexColumns, getIndexType, getPlanSQL, getRow, isRowIdIndex, setSortedInsertMode
getSchema, isHidden
getChildren, getComment, getCreateSQL, getCreateSQLForCopy, getDatabase, getDropSQL, getId, getName, getSQL, getType, isTemporary, removeChildrenAndResources, rename, setComment, setTemporary
public MVSecondaryIndex(Database db, MVTable table, int id, String indexName, IndexColumn[] columns, IndexType indexType)
public void addRowsToBuffer(List<Row> rows, String bufferName)
MVIndex
addRowsToBuffer
in interface MVIndex
rows
- the rowsbufferName
- the name of the temporary storagepublic void addBufferedRows(List<String> bufferNames)
MVIndex
addBufferedRows
in interface MVIndex
bufferNames
- the names of the temporary storagepublic void add(Session session, Row row)
Index
public void remove(Session session, Row row)
Index
public Cursor find(Session session, SearchRow first, SearchRow last)
Index
public MVTable getTable()
Index
public double getCost(Session session, int[] masks, TableFilter[] filters, int filter, SortOrder sortOrder, HashSet<Column> allColumnsSet)
Index
getCost
in interface Index
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 columnspublic void remove(Session session)
Index
public void truncate(Session session)
Index
public boolean canGetFirstOrLast()
Index
canGetFirstOrLast
in interface Index
public Cursor findFirstOrLast(Session session, boolean first)
Index
findFirstOrLast
in interface Index
session
- the sessionfirst
- true if the first (lowest for ascending indexes) or last
value should be returnedpublic boolean needRebuild()
Index
needRebuild
in interface Index
public long getRowCount(Session session)
Index
getRowCount
in interface Index
session
- the sessionpublic long getRowCountApproximation()
Index
getRowCountApproximation
in interface Index
public long getDiskSpaceUsed()
Index
getDiskSpaceUsed
in interface Index
public boolean canFindNext()
Index
canFindNext
in interface Index
canFindNext
in class BaseIndex
public Cursor findNext(Session session, SearchRow higherThan, SearchRow last)
BaseIndex
public void checkRename()
DbObjectBase
checkRename
in interface DbObject
checkRename
in class DbObjectBase
Copyright © 2017 JBoss by Red Hat. All rights reserved.