public class SpatialTreeIndex extends BaseIndex implements SpatialIndex
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 |
---|
SpatialTreeIndex(Table table,
int id,
String indexName,
IndexColumn[] columns,
IndexType indexType,
boolean persistent,
boolean create,
Session session)
Constructor.
|
Modifier and Type | Method and Description |
---|---|
void |
add(Session session,
Row row)
Add a row to the index.
|
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 |
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 |
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.
|
Cursor |
findFirstOrLast(Session session,
boolean first)
Find the first (or last) value of this index.
|
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.
|
static long |
getCostRangeIndex(int[] masks,
long rowCount,
Column[] columns)
Compute spatial index cost
|
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.
|
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.
|
canFindNext, canScan, checkIndexColumnTypes, commit, compareRows, containsNullAndAllowMultipleNull, createLookupBatch, findNext, getColumnIndex, getColumns, getCostRangeIndex, getCreateSQL, getCreateSQLForCopy, getDropSQL, getDuplicateKeyException, getIndexColumns, getIndexType, getPlanSQL, getRow, getTable, 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
canFindNext, canScan, commit, compareRows, createLookupBatch, findNext, getColumnIndex, getColumns, getIndexColumns, getIndexType, getPlanSQL, getRow, getTable, isRowIdIndex, setSortedInsertMode
getSchema, isHidden
getChildren, getComment, getCreateSQL, getCreateSQLForCopy, getDatabase, getDropSQL, getId, getName, getSQL, getType, isTemporary, removeChildrenAndResources, rename, setComment, setTemporary
public SpatialTreeIndex(Table table, int id, String indexName, IndexColumn[] columns, IndexType indexType, boolean persistent, boolean create, Session session)
table
- the table instanceid
- the index idindexName
- the index namecolumns
- the indexed columns (only one geometry column allowed)persistent
- whether the index should be persistedindexType
- the index type (only spatial index)create
- whether to create a new indexsession
- the session.public void add(Session session, Row row)
Index
public void remove(Session session, Row row)
Index
public Cursor find(TableFilter filter, SearchRow first, SearchRow last)
Index
public Cursor find(Session session, SearchRow first, SearchRow last)
Index
public Cursor findByGeometry(TableFilter filter, SearchRow first, SearchRow last, SearchRow intersection)
SpatialIndex
findByGeometry
in interface SpatialIndex
filter
- the table filter (which possibly knows about additional
conditions)first
- the lower boundlast
- the upper boundintersection
- the geometry which values should intersect with, or
null for anythingpublic static long getCostRangeIndex(int[] masks, long rowCount, Column[] columns)
masks
- Search maskrowCount
- Table row countcolumns
- Table columnspublic 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 void checkRename()
DbObjectBase
checkRename
in interface DbObject
checkRename
in class DbObjectBase
public boolean needRebuild()
Index
needRebuild
in interface 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 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
Copyright © 2017 JBoss by Red Hat. All rights reserved.