|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectorg.h2.engine.DbObjectBase
org.h2.schema.SchemaObjectBase
org.h2.index.BaseIndex
org.h2.index.ScanIndex
public class ScanIndex
The scan index is not really an 'index' in the strict sense, because it can not be used for direct lookup. It can only be used to iterate over all rows of a table. Each regular table has one such object, even if no primary key or indexes are defined.
Field Summary |
---|
Fields inherited from class org.h2.index.BaseIndex |
---|
columnIds, columns, indexColumns, indexType, isMultiVersion, table |
Fields inherited from class org.h2.engine.DbObjectBase |
---|
comment, database, trace |
Fields inherited from interface org.h2.engine.DbObject |
---|
AGGREGATE, COMMENT, CONSTANT, CONSTRAINT, FUNCTION_ALIAS, INDEX, RIGHT, ROLE, SCHEMA, SEQUENCE, SETTING, TABLE_OR_VIEW, TRIGGER, USER, USER_DATATYPE |
Constructor Summary | |
---|---|
ScanIndex(RegularTable table,
int id,
IndexColumn[] columns,
IndexType indexType)
|
Method Summary | |
---|---|
void |
add(Session session,
Row row)
Add a row to this index. |
boolean |
canGetFirstOrLast()
Check if this index can quickly find the first or last value. |
void |
checkRename()
Check if this object can be renamed. |
void |
close(Session session)
Close this index. |
void |
commit(int operation,
Row row)
Commit the operation for a row. |
Cursor |
find(Session session,
SearchRow first,
SearchRow last)
Create a cursor to iterate over a number of rows. |
Cursor |
findFirstOrLast(Session session,
boolean first)
Find the first (or last) value of this index. |
int |
getColumnIndex(Column col)
Get the index of a column in the list of index columns |
double |
getCost(Session session,
int[] masks)
Calculate the cost to find rows. |
java.lang.String |
getCreateSQL()
Build a SQL statement to re-create this object. |
java.lang.String |
getPlanSQL()
Get the message to show in a EXPLAIN statement. |
Row |
getRow(Session session,
long key)
Get the row with the given key. |
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 this index needs to be re-built. |
void |
remove(Session session)
Remove the index. |
void |
remove(Session session,
Row row)
Remove a row from the index. |
void |
truncate(Session session)
Truncate the index. |
Methods inherited from class org.h2.index.BaseIndex |
---|
canFindNext, compareKeys, compareRows, containsNullAndAllowMultipleNull, findNext, getColumnListSQL, getColumns, getCostRangeIndex, getCreateSQLForCopy, getDropSQL, getDuplicateKeyException, getIndexColumns, getIndexType, getLookupCost, getRootPageId, getTable, getType, initBaseIndex, isHidden, removeChildrenAndResources |
Methods inherited from class org.h2.schema.SchemaObjectBase |
---|
getSchema, getSQL, initSchemaObjectBase |
Methods inherited from class org.h2.engine.DbObjectBase |
---|
getChildren, getComment, getDatabase, getId, getModificationId, getName, initDbObjectBase, invalidate, isTemporary, 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.schema.SchemaObject |
---|
getSchema |
Methods inherited from interface org.h2.engine.DbObject |
---|
getChildren, getComment, getDatabase, getId, getModificationId, getName, getSQL, isTemporary, rename, setComment, setModified, setTemporary |
Constructor Detail |
---|
public ScanIndex(RegularTable table, int id, IndexColumn[] columns, IndexType indexType)
Method Detail |
---|
public void remove(Session session)
BaseIndex
remove
in interface Index
remove
in class BaseIndex
session
- the sessionpublic void truncate(Session session)
BaseIndex
truncate
in interface Index
truncate
in class BaseIndex
session
- the sessionpublic java.lang.String getCreateSQL()
DbObjectBase
getCreateSQL
in interface DbObject
getCreateSQL
in class BaseIndex
public void close(Session session)
BaseIndex
close
in interface Index
close
in class BaseIndex
session
- the sessionpublic Row getRow(Session session, long key)
Index
getRow
in interface Index
getRow
in class BaseIndex
session
- the sessionkey
- the unique key
public void add(Session session, Row row)
BaseIndex
add
in interface Index
add
in class BaseIndex
session
- the sessionrow
- the row to addpublic void commit(int operation, Row row)
Index
commit
in interface Index
commit
in class BaseIndex
operation
- the operation typerow
- the rowpublic void remove(Session session, Row row)
BaseIndex
remove
in interface Index
remove
in class BaseIndex
session
- the sessionrow
- the rowpublic Cursor find(Session session, SearchRow first, SearchRow last)
BaseIndex
find
in interface Index
find
in class BaseIndex
session
- the sessionfirst
- the first row to return (null if no limit)last
- the last row to return (null if no limit)
public double getCost(Session session, int[] masks)
BaseIndex
getCost
in interface Index
getCost
in class BaseIndex
session
- the sessionmasks
- the condition mask
public long getRowCount(Session session)
Index
session
- the session
public int getColumnIndex(Column col)
Index
getColumnIndex
in interface Index
getColumnIndex
in class BaseIndex
col
- the column
public void checkRename()
DbObjectBase
checkRename
in interface DbObject
checkRename
in class DbObjectBase
public boolean needRebuild()
BaseIndex
needRebuild
in interface Index
needRebuild
in class BaseIndex
public boolean canGetFirstOrLast()
BaseIndex
canGetFirstOrLast
in interface Index
canGetFirstOrLast
in class BaseIndex
public Cursor findFirstOrLast(Session session, boolean first)
BaseIndex
findFirstOrLast
in interface Index
findFirstOrLast
in class BaseIndex
session
- the sessionfirst
- true for the first value, false for the last
public long getRowCountApproximation()
Index
public java.lang.String getPlanSQL()
Index
getPlanSQL
in interface Index
getPlanSQL
in class BaseIndex
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |