|
|||||||||
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.ViewIndex
public class ViewIndex
This object represents a virtual index for a query. Actually it only represents a prepared SELECT statement.
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 | |
---|---|
ViewIndex(TableView view,
java.lang.String querySQL,
java.util.ArrayList<Parameter> originalParameters,
boolean recursive)
|
|
ViewIndex(TableView view,
ViewIndex index,
Session session,
int[] masks)
|
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. |
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. |
double |
getCost(Session session,
int[] masks)
Calculate the cost to find rows. |
java.lang.String |
getPlanSQL()
Get the message to show in a EXPLAIN statement. |
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. |
Session |
getSession()
|
boolean |
isRecursive()
|
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 |
setRecursive(boolean value)
|
void |
truncate(Session session)
Truncate the index. |
Methods inherited from class org.h2.index.BaseIndex |
---|
canFindNext, commit, compareKeys, compareRows, containsNullAndAllowMultipleNull, findNext, getColumnIndex, getColumnListSQL, getColumns, getCostRangeIndex, getCreateSQL, getCreateSQLForCopy, getDropSQL, getDuplicateKeyException, getIndexColumns, getIndexType, getLookupCost, getRootPageId, getRow, 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 ViewIndex(TableView view, java.lang.String querySQL, java.util.ArrayList<Parameter> originalParameters, boolean recursive)
public ViewIndex(TableView view, ViewIndex index, Session session, int[] masks)
Method Detail |
---|
public Session getSession()
public java.lang.String getPlanSQL()
Index
getPlanSQL
in interface Index
getPlanSQL
in class BaseIndex
public void close(Session session)
BaseIndex
close
in interface Index
close
in class BaseIndex
session
- the sessionpublic void add(Session session, Row row)
BaseIndex
add
in interface Index
add
in class BaseIndex
session
- the sessionrow
- the row to addpublic void remove(Session session, Row row)
BaseIndex
remove
in interface Index
remove
in class BaseIndex
session
- the sessionrow
- the rowpublic double getCost(Session session, int[] masks)
BaseIndex
getCost
in interface Index
getCost
in class BaseIndex
session
- the sessionmasks
- the condition mask
public 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 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 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 void setRecursive(boolean value)
public long getRowCount(Session session)
Index
session
- the session
public long getRowCountApproximation()
Index
public boolean isRecursive()
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |