Apache Derby Database Engine and Embedded JDBC Driver 10.17.1.0 · org.apache.derby.impl.sql.execute.xplain.XPLAINUtil

Field Summary

Modifier and Type	Field and Description
public static final String	CALL_STMT_TYPE
public static final String	DDL_STMT_TYPE
public static final String	DELETE_STMT_TYPE
public static final String	INSERT_STMT_TYPE
public static final String	ISOLATION_READ_COMMIT
public static final String	ISOLATION_READ_UNCOMMITED isolation level codes
public static final String	ISOLATION_REPEAT_READ
public static final String	ISOLATION_SERIALIZABLE
public static final String	LOCK_GRANULARITY_ROW
public static final String	LOCK_GRANULARITY_TABLE lock granularity
public static final String	LOCK_MODE_EXCLUSIVE lock modes
public static final String	LOCK_MODE_INSTANTENOUS_EXCLUSIVE
public static final String	LOCK_MODE_INSTANTENOUS_SHARE
public static final String	LOCK_MODE_SHARE
public static final String	NO_CODE
public static final String	OP_AGGREGATE
public static final String	OP_ANY
public static final String	OP_BULK
public static final String	OP_CASCADE
public static final String	OP_CONSTRAINTSCAN
public static final String	OP_CURRENT_OF
public static final String	OP_DELETE
public static final String	OP_DISTINCT
public static final String	OP_DISTINCTSCAN
public static final String	OP_FILTER
public static final String	OP_GROUP
public static final String	OP_HASHSCAN
public static final String	OP_HASHTABLE
public static final String	OP_INDEXSCAN
public static final String	OP_INSERT
public static final String	OP_JOIN_HASH
public static final String	OP_JOIN_HASH_LO
public static final String	OP_JOIN_NL
public static final String	OP_JOIN_NL_LO
public static final String	OP_LASTINDEXKEYSCAN
public static final String	OP_MATERIALIZE
public static final String	OP_NORMALIZE
public static final String	OP_ONCE
public static final String	OP_PROJ_RESTRICT
public static final String	OP_PROJECT
public static final String	OP_ROW
public static final String	OP_ROW_COUNT
public static final String	OP_ROWIDSCAN
public static final String	OP_SCROLL
public static final String	OP_SET
public static final String	OP_SET_EXCEPT
public static final String	OP_SET_INTERSECT
public static final String	OP_SORT
public static final String	OP_TABLESCAN the rs operator codes
public static final String	OP_UNION
public static final String	OP_UPDATE
public static final String	OP_VTI
public static final String	OP_VTI_RS
public static final String	OP_WINDOW
public static final String	SCAN_BITSET_ALL
public static final String	SCAN_BTREE
public static final String	SCAN_HEAP the scan info codes
public static final String	SCAN_SORT
public static final String	SELECT_APPROXIMATE_STMT_TYPE
public static final String	SELECT_STMT_TYPE the different statement type constants
public static final String	SORT_EXTERNAL sort info properties
public static final String	SORT_INTERNAL
public static final String	UPDATE_STMT_TYPE
public static final String	XPLAIN_FULL
public static final String	XPLAIN_ONLY the explain type constants
public static final String	YES_CODE yes no codes

Constructor Summary

Access	Constructor and Description
public	XPLAINUtil()

Method Summary

Modifier and Type	Method and Description
public static XPLAINScanPropsDescriptor	Returns: the filled descriptor extractScanProps(XPLAINScanPropsDescriptor the descriptor to fill with properties descriptor, Properties the provided scan props scanProps) helper method which extracts the right (non-internationalzed) scan properties of the scan info properties
public static XPLAINSortPropsDescriptor	Returns: the filled descriptor extractSortProps(XPLAINSortPropsDescriptor the descriptor to fill with properties descriptor, Properties the provided sort props sortProps) helper method which extracts the right (non-internationalzed) sort properties of the sort info properties object
public static Long	Returns: the quotient or null getAVGNextTime(long the long value for the dividend (the whole next time) dividend, long the long value for the divisor (the sum of all rows seen) divisor) Compute average, avoiding divide-by-zero problems.
public static String	getHashKeyColumnNumberString(int[] hashKeyColumns)
public static String	getIsolationLevelCode(String isolationLevel) util function, to resolve the isolation level and return a isolation level code
public static String	getLockGranularityCode(String lockString) util function, to resolve the lock granularity and return a lock granularity code
public static String	getLockModeCode(String lockString) util function, to resolve the lock mode, and return a lock mode code
public static String	getStatementType(String SQLText) This method helps to figure out the statement type and returns an appropriate return code, characterizing the stmt type.
public static String	getYesNoCharFromBoolean(boolean test)

Inherited from java.lang.Object:: clone equals finalize getClass hashCode notify notifyAll toString wait wait wait

Field Detail

CALL_STMT_TYPE	back to summary
public static final String CALL_STMT_TYPE

DDL_STMT_TYPE	back to summary
public static final String DDL_STMT_TYPE

DELETE_STMT_TYPE	back to summary
public static final String DELETE_STMT_TYPE

INSERT_STMT_TYPE	back to summary
public static final String INSERT_STMT_TYPE

ISOLATION_READ_COMMIT	back to summary
public static final String ISOLATION_READ_COMMIT

ISOLATION_READ_UNCOMMITED	back to summary
public static final String ISOLATION_READ_UNCOMMITED isolation level codes

ISOLATION_REPEAT_READ	back to summary
public static final String ISOLATION_REPEAT_READ

ISOLATION_SERIALIZABLE	back to summary
public static final String ISOLATION_SERIALIZABLE

LOCK_GRANULARITY_ROW	back to summary
public static final String LOCK_GRANULARITY_ROW

LOCK_GRANULARITY_TABLE	back to summary
public static final String LOCK_GRANULARITY_TABLE lock granularity

LOCK_MODE_EXCLUSIVE	back to summary
public static final String LOCK_MODE_EXCLUSIVE lock modes

LOCK_MODE_INSTANTENOUS_EXCLUSIVE	back to summary
public static final String LOCK_MODE_INSTANTENOUS_EXCLUSIVE

LOCK_MODE_INSTANTENOUS_SHARE	back to summary
public static final String LOCK_MODE_INSTANTENOUS_SHARE

LOCK_MODE_SHARE	back to summary
public static final String LOCK_MODE_SHARE

NO_CODE	back to summary
public static final String NO_CODE

OP_AGGREGATE	back to summary
public static final String OP_AGGREGATE

OP_ANY	back to summary
public static final String OP_ANY

OP_BULK	back to summary
public static final String OP_BULK

OP_CASCADE	back to summary
public static final String OP_CASCADE

OP_CONSTRAINTSCAN	back to summary
public static final String OP_CONSTRAINTSCAN

OP_CURRENT_OF	back to summary
public static final String OP_CURRENT_OF

OP_DELETE	back to summary
public static final String OP_DELETE

OP_DISTINCT	back to summary
public static final String OP_DISTINCT

OP_DISTINCTSCAN	back to summary
public static final String OP_DISTINCTSCAN

OP_FILTER	back to summary
public static final String OP_FILTER

OP_GROUP	back to summary
public static final String OP_GROUP

OP_HASHSCAN	back to summary
public static final String OP_HASHSCAN

OP_HASHTABLE	back to summary
public static final String OP_HASHTABLE

OP_INDEXSCAN	back to summary
public static final String OP_INDEXSCAN

OP_INSERT	back to summary
public static final String OP_INSERT

OP_JOIN_HASH	back to summary
public static final String OP_JOIN_HASH

OP_JOIN_HASH_LO	back to summary
public static final String OP_JOIN_HASH_LO

OP_JOIN_NL	back to summary
public static final String OP_JOIN_NL

OP_JOIN_NL_LO	back to summary
public static final String OP_JOIN_NL_LO

OP_LASTINDEXKEYSCAN	back to summary
public static final String OP_LASTINDEXKEYSCAN

OP_MATERIALIZE	back to summary
public static final String OP_MATERIALIZE

OP_NORMALIZE	back to summary
public static final String OP_NORMALIZE

OP_ONCE	back to summary
public static final String OP_ONCE

OP_PROJ_RESTRICT	back to summary
public static final String OP_PROJ_RESTRICT

OP_PROJECT	back to summary
public static final String OP_PROJECT

OP_ROW	back to summary
public static final String OP_ROW

OP_ROW_COUNT	back to summary
public static final String OP_ROW_COUNT

OP_ROWIDSCAN	back to summary
public static final String OP_ROWIDSCAN

OP_SCROLL	back to summary
public static final String OP_SCROLL

OP_SET	back to summary
public static final String OP_SET

OP_SET_EXCEPT	back to summary
public static final String OP_SET_EXCEPT

OP_SET_INTERSECT	back to summary
public static final String OP_SET_INTERSECT

OP_SORT	back to summary
public static final String OP_SORT

OP_TABLESCAN	back to summary
public static final String OP_TABLESCAN the rs operator codes

OP_UNION	back to summary
public static final String OP_UNION

OP_UPDATE	back to summary
public static final String OP_UPDATE

OP_VTI	back to summary
public static final String OP_VTI

OP_VTI_RS	back to summary
public static final String OP_VTI_RS

OP_WINDOW	back to summary
public static final String OP_WINDOW

SCAN_BITSET_ALL	back to summary
public static final String SCAN_BITSET_ALL

SCAN_BTREE	back to summary
public static final String SCAN_BTREE

SCAN_HEAP	back to summary
public static final String SCAN_HEAP the scan info codes

SCAN_SORT	back to summary
public static final String SCAN_SORT

SELECT_APPROXIMATE_STMT_TYPE	back to summary
public static final String SELECT_APPROXIMATE_STMT_TYPE

SELECT_STMT_TYPE	back to summary
public static final String SELECT_STMT_TYPE the different statement type constants

SORT_EXTERNAL	back to summary
public static final String SORT_EXTERNAL sort info properties

SORT_INTERNAL	back to summary
public static final String SORT_INTERNAL

UPDATE_STMT_TYPE	back to summary
public static final String UPDATE_STMT_TYPE

XPLAIN_FULL	back to summary
public static final String XPLAIN_FULL

XPLAIN_ONLY	back to summary
public static final String XPLAIN_ONLY the explain type constants

YES_CODE	back to summary
public static final String YES_CODE yes no codes

Constructor Detail

XPLAINUtil	back to summary
public XPLAINUtil()

Method Detail

extractScanProps

back to summary

public static XPLAINScanPropsDescriptor extractScanProps(XPLAINScanPropsDescriptor descriptor, Properties scanProps)

helper method which extracts the right (non-internationalzed) scan properties of the scan info properties

Parameters

descriptor:XPLAINScanPropsDescriptor: the descriptor to fill with properties
scanProps:Properties: the provided scan props

Returns:XPLAINScanPropsDescriptor

the filled descriptor

extractSortProps

back to summary

public static XPLAINSortPropsDescriptor extractSortProps(XPLAINSortPropsDescriptor descriptor, Properties sortProps)

helper method which extracts the right (non-internationalzed) sort properties of the sort info properties object

Parameters

descriptor:XPLAINSortPropsDescriptor: the descriptor to fill with properties
sortProps:Properties: the provided sort props

Returns:XPLAINSortPropsDescriptor

the filled descriptor

getAVGNextTime

back to summary

public static Long getAVGNextTime(long dividend, long divisor)

Compute average, avoiding divide-by-zero problems.

Parameters

dividend:long: the long value for the dividend (the whole next time)
divisor:long: the long value for the divisor (the sum of all rows seen)

Returns:Long

the quotient or null

getHashKeyColumnNumberString	back to summary
public static String getHashKeyColumnNumberString(int[] hashKeyColumns)

getIsolationLevelCode	back to summary
public static String getIsolationLevelCode(String isolationLevel) util function, to resolve the isolation level and return a isolation level code

getLockGranularityCode	back to summary
public static String getLockGranularityCode(String lockString) util function, to resolve the lock granularity and return a lock granularity code

getLockModeCode	back to summary
public static String getLockModeCode(String lockString) util function, to resolve the lock mode, and return a lock mode code

getStatementType	back to summary
public static String getStatementType(String SQLText) This method helps to figure out the statement type and returns an appropriate return code, characterizing the stmt type.

getYesNoCharFromBoolean	back to summary
public static String getYesNoCharFromBoolean(boolean test)

public Class XPLAINUtil

Field Summary

Constructor Summary

Method Summary

Field Detail

Constructor Detail

Method Detail