|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectorg.apache.derby.impl.sql.execute.xplain.XPLAINUtil
public class XPLAINUtil
This class contains helper methods, which support the System Table Visitor.
Field Summary | |
---|---|
static java.lang.String |
CALL_STMT_TYPE
|
static java.lang.String |
DDL_STMT_TYPE
|
static java.lang.String |
DELETE_STMT_TYPE
|
static java.lang.String |
INSERT_STMT_TYPE
|
static java.lang.String |
ISOLATION_READ_COMMIT
|
static java.lang.String |
ISOLATION_READ_UNCOMMITED
isolation level codes |
static java.lang.String |
ISOLATION_REPEAT_READ
|
static java.lang.String |
ISOLATION_SERIALIZABLE
|
static java.lang.String |
LOCK_GRANULARITY_ROW
|
static java.lang.String |
LOCK_GRANULARITY_TABLE
lock granularity |
static java.lang.String |
LOCK_MODE_EXCLUSIVE
lock modes |
static java.lang.String |
LOCK_MODE_INSTANTENOUS_EXCLUSIVE
|
static java.lang.String |
LOCK_MODE_INSTANTENOUS_SHARE
|
static java.lang.String |
LOCK_MODE_SHARE
|
static java.lang.String |
NO_CODE
|
static java.lang.String |
OP_AGGREGATE
|
static java.lang.String |
OP_ANY
|
static java.lang.String |
OP_BULK
|
static java.lang.String |
OP_CASCADE
|
static java.lang.String |
OP_CONSTRAINTSCAN
|
static java.lang.String |
OP_CURRENT_OF
|
static java.lang.String |
OP_DELETE
|
static java.lang.String |
OP_DISTINCT
|
static java.lang.String |
OP_DISTINCTSCAN
|
static java.lang.String |
OP_FILTER
|
static java.lang.String |
OP_GROUP
|
static java.lang.String |
OP_HASHSCAN
|
static java.lang.String |
OP_HASHTABLE
|
static java.lang.String |
OP_INDEXSCAN
|
static java.lang.String |
OP_INSERT
|
static java.lang.String |
OP_JOIN_HASH
|
static java.lang.String |
OP_JOIN_HASH_LO
|
static java.lang.String |
OP_JOIN_NL
|
static java.lang.String |
OP_JOIN_NL_LO
|
static java.lang.String |
OP_LASTINDEXKEYSCAN
|
static java.lang.String |
OP_MATERIALIZE
|
static java.lang.String |
OP_NORMALIZE
|
static java.lang.String |
OP_ONCE
|
static java.lang.String |
OP_PROJ_RESTRICT
|
static java.lang.String |
OP_PROJECT
|
static java.lang.String |
OP_ROW
|
static java.lang.String |
OP_ROW_COUNT
|
static java.lang.String |
OP_ROWIDSCAN
|
static java.lang.String |
OP_SCROLL
|
static java.lang.String |
OP_SET
|
static java.lang.String |
OP_SET_EXCEPT
|
static java.lang.String |
OP_SET_INTERSECT
|
static java.lang.String |
OP_SORT
|
static java.lang.String |
OP_TABLESCAN
the rs operator codes |
static java.lang.String |
OP_UNION
|
static java.lang.String |
OP_UPDATE
|
static java.lang.String |
OP_VTI
|
static java.lang.String |
OP_VTI_RS
|
static java.lang.String |
OP_WINDOW
|
static java.lang.String |
SCAN_BITSET_ALL
|
static java.lang.String |
SCAN_BTREE
|
static java.lang.String |
SCAN_HEAP
the scan info codes |
static java.lang.String |
SCAN_SORT
|
static java.lang.String |
SELECT_APPROXIMATE_STMT_TYPE
|
static java.lang.String |
SELECT_STMT_TYPE
the different statement type constants |
static java.lang.String |
SORT_EXTERNAL
sort info properties |
static java.lang.String |
SORT_INTERNAL
|
static java.lang.String |
UPDATE_STMT_TYPE
|
static java.lang.String |
XPLAIN_FULL
|
static java.lang.String |
XPLAIN_ONLY
the explain type constants |
static java.lang.String |
YES_CODE
yes no codes |
Constructor Summary | |
---|---|
XPLAINUtil()
|
Method Summary | |
---|---|
static XPLAINScanPropsDescriptor |
extractScanProps(XPLAINScanPropsDescriptor descriptor,
java.util.Properties scanProps)
helper method which extracts the right (non-internationalzed) scan properties of the scan info properties |
static XPLAINSortPropsDescriptor |
extractSortProps(XPLAINSortPropsDescriptor descriptor,
java.util.Properties sortProps)
helper method which extracts the right (non-internationalzed) sort properties of the sort info properties object |
static java.lang.Long |
getAVGNextTime(long dividend,
long divisor)
Compute average, avoiding divide-by-zero problems. |
static java.lang.String |
getHashKeyColumnNumberString(int[] hashKeyColumns)
|
static java.lang.String |
getIsolationLevelCode(java.lang.String isolationLevel)
util function, to resolve the isolation level and return a isolation level code |
static java.lang.String |
getLockGranularityCode(java.lang.String lockString)
util function, to resolve the lock granularity and return a lock granularity code |
static java.lang.String |
getLockModeCode(java.lang.String lockString)
util function, to resolve the lock mode, and return a lock mode code |
static java.lang.String |
getStatementType(java.lang.String SQLText)
This method helps to figure out the statement type and returns an appropriate return code, characterizing the stmt type. |
static java.lang.String |
getYesNoCharFromBoolean(boolean test)
|
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Field Detail |
---|
public static final java.lang.String ISOLATION_READ_UNCOMMITED
public static final java.lang.String ISOLATION_READ_COMMIT
public static final java.lang.String ISOLATION_REPEAT_READ
public static final java.lang.String ISOLATION_SERIALIZABLE
public static final java.lang.String LOCK_MODE_EXCLUSIVE
public static final java.lang.String LOCK_MODE_INSTANTENOUS_EXCLUSIVE
public static final java.lang.String LOCK_MODE_SHARE
public static final java.lang.String LOCK_MODE_INSTANTENOUS_SHARE
public static final java.lang.String LOCK_GRANULARITY_TABLE
public static final java.lang.String LOCK_GRANULARITY_ROW
public static final java.lang.String OP_TABLESCAN
public static final java.lang.String OP_INDEXSCAN
public static final java.lang.String OP_HASHSCAN
public static final java.lang.String OP_DISTINCTSCAN
public static final java.lang.String OP_LASTINDEXKEYSCAN
public static final java.lang.String OP_HASHTABLE
public static final java.lang.String OP_ROWIDSCAN
public static final java.lang.String OP_CONSTRAINTSCAN
public static final java.lang.String OP_JOIN_NL
public static final java.lang.String OP_JOIN_HASH
public static final java.lang.String OP_JOIN_NL_LO
public static final java.lang.String OP_JOIN_HASH_LO
public static final java.lang.String OP_UNION
public static final java.lang.String OP_SET
public static final java.lang.String OP_SET_INTERSECT
public static final java.lang.String OP_SET_EXCEPT
public static final java.lang.String OP_INSERT
public static final java.lang.String OP_UPDATE
public static final java.lang.String OP_DELETE
public static final java.lang.String OP_CASCADE
public static final java.lang.String OP_VTI
public static final java.lang.String OP_BULK
public static final java.lang.String OP_DISTINCT
public static final java.lang.String OP_NORMALIZE
public static final java.lang.String OP_ANY
public static final java.lang.String OP_SCROLL
public static final java.lang.String OP_MATERIALIZE
public static final java.lang.String OP_ONCE
public static final java.lang.String OP_VTI_RS
public static final java.lang.String OP_ROW
public static final java.lang.String OP_PROJECT
public static final java.lang.String OP_FILTER
public static final java.lang.String OP_AGGREGATE
public static final java.lang.String OP_PROJ_RESTRICT
public static final java.lang.String OP_SORT
public static final java.lang.String OP_GROUP
public static final java.lang.String OP_CURRENT_OF
public static final java.lang.String OP_ROW_COUNT
public static final java.lang.String OP_WINDOW
public static final java.lang.String SCAN_HEAP
public static final java.lang.String SCAN_BTREE
public static final java.lang.String SCAN_SORT
public static final java.lang.String SCAN_BITSET_ALL
public static final java.lang.String SELECT_STMT_TYPE
public static final java.lang.String SELECT_APPROXIMATE_STMT_TYPE
public static final java.lang.String INSERT_STMT_TYPE
public static final java.lang.String UPDATE_STMT_TYPE
public static final java.lang.String DELETE_STMT_TYPE
public static final java.lang.String CALL_STMT_TYPE
public static final java.lang.String DDL_STMT_TYPE
public static final java.lang.String XPLAIN_ONLY
public static final java.lang.String XPLAIN_FULL
public static final java.lang.String SORT_EXTERNAL
public static final java.lang.String SORT_INTERNAL
public static final java.lang.String YES_CODE
public static final java.lang.String NO_CODE
Constructor Detail |
---|
public XPLAINUtil()
Method Detail |
---|
public static java.lang.String getYesNoCharFromBoolean(boolean test)
public static java.lang.String getHashKeyColumnNumberString(int[] hashKeyColumns)
public static java.lang.String getLockModeCode(java.lang.String lockString)
public static java.lang.String getIsolationLevelCode(java.lang.String isolationLevel)
public static java.lang.String getLockGranularityCode(java.lang.String lockString)
public static java.lang.String getStatementType(java.lang.String SQLText)
public static XPLAINScanPropsDescriptor extractScanProps(XPLAINScanPropsDescriptor descriptor, java.util.Properties scanProps)
descriptor
- the descriptor to fill with propertiesscanProps
- the provided scan props
public static XPLAINSortPropsDescriptor extractSortProps(XPLAINSortPropsDescriptor descriptor, java.util.Properties sortProps)
descriptor
- the descriptor to fill with propertiessortProps
- the provided sort props
public static java.lang.Long getAVGNextTime(long dividend, long divisor)
dividend
- the long value for the dividend (the whole next time)divisor
- the long value for the divisor (the sum of all rows seen)
|
Built on Thu 2010-12-23 20:49:13+0000, from revision ??? | ||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |