public class XPLAINUtil
extends java.lang.Object
Modifier and Type | Field and Description |
---|---|
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 and Description |
---|
XPLAINUtil() |
Modifier and Type | Method and Description |
---|---|
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) |
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
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 propspublic static XPLAINSortPropsDescriptor extractSortProps(XPLAINSortPropsDescriptor descriptor, java.util.Properties sortProps)
descriptor
- the descriptor to fill with propertiessortProps
- the provided sort propspublic 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)Apache Derby V10.13 Internals - Copyright © 2004,2016 The Apache Software Foundation. All Rights Reserved.