6.1.7 Information displayed for an access path (alphabetical order)

The following table lists in alphabetical order and describes the information that is displayed for an access path.

Table 6‒1: Information displayed for an access path (alphabetical order)
First letter	Output information	Description	Classification
`B`	`BUILD` `COLUMN`	If hash join is applied as the table joining method, information about the joined columns in the outer table is output. If a hash filter is applied, hash filter information is also output.	Hash retrieval information (`BUILD COLUMN` and `PROBE COLUMN`)
`B`	`BUILD` `COLUMN`	If hash execution is applied as the method for processing subqueries that do not contain external reference columns, information about the column resulting from the subquery is output. If hash execution is applied as the method for processing subqueries that contain external reference columns, information about the column to be compared with the external reference column specified in the subquery is output. If a hash filter is applied, hash filter information is also output.	Information about subqueries
`C`	`CHUNK`	The chunk skip condition is used.	Information related to indexes
	`CHUNK` `AND` `SEGMENT`	The chunk skip condition and the segment skip condition are both used.	Information related to indexes
	`COLUMN`	The grouping method that uses the characteristics of column store tables is performed.	Grouping methods
	`COLUMN STORE`	The table-data storage format is column store format.	Table-data storage format
	`CREATE FILTER`	The number of the hash filter created based on the column value for the column name shown in `BUILD COLUMN` is output.	Hash retrieval information (`BUILD COLUMN` and `PROBE COLUMN`)
	`CREATE FILTER`		Information about subqueries
	`CREATE` `GLOBAL` `WORK` `TABLE` `(WORK` `TABLE` `work-table-number)`	A global work table is created.	Work table creation information
	`CREATE` `LOCAL` `WORK` `TABLE` `(WORK` `TABLE` `work-table-number)`	A local work table is created. A unique work table number is assigned to each work table.	Work table creation information
	`CROSS` `JOIN`	A cross join is specified.	Information related to table joining methods
`D`	`DELEGATION`	Subquery processing delegation specification is enabled.	Subquery processing delegation specification
	`DELETE` `STATEMENT`	A `DELETE` statement is executed.	SQL statements executed
	`DERIVED` `TABLE(correlation-name, query-name, or table-identifier))`	A derived table, viewed table, or query name is specified.	Specification of derived tables
	`DISTINCT`	This item indicates that duplicate removal will be performed.	Information about duplicate removal
`F`	`FILTER`	A hash filter is applied during hash execution for the subquery processing method.	Subquery processing methods
	`FILTER`	A hash filter is applied during hash join for the table joining method.	Table joining method
	`FULL` `OUTER` `JOIN(LEFT)` `FULL` `OUTER` `JOIN(RIGHT)`	An outer join performed by a `FULL` `OUTER` `JOIN` is specified.	Information related to table joining methods
	`FUNCTION NAME`	The type of system-defined function that is executed.	Information about table function derived tables
`G`	`GLOBAL` `HASH` `GROUPING`	Global hash grouping is executed. Work tables might be created if there are rows that cannot be processed in the hash table area.	Grouping methods
	`GLOBAL` `HASH` `UNIQUE`	Duplication in the retrieval results has been eliminated by using one of the following methods: Hash execution for the method for processing the set operation Hash execution for the method for processing `SELECT DISTINCT` Global hash grouping for the grouping method Work tables are created if there are rows that cannot be processed in the hash table area.	Processing method for duplicate removal
	`GROUPING`	Grouping that does not use work tables is performed.	Grouping methods
	`GROUPING SET`	Grouping processing is performed multiple times.	Grouping methods Information about the grouping
`H`	`(HASH)`	When a hash join is performed, `(HASH)` indicates that the range index that is defined for a column that is to be matched with a hash table is used. When hash execution is performed as the processing method for a subquery, `(HASH)` indicates that the range index that is defined for a column that is to be matched with a hash table is used.	Information related to indexes
	`HASH` `JOIN`	A hash join is performed in the table join processing. If there is an `=` condition that compares columns in two tables, a hash join might be performed. If there are rows that cannot be processed in the hash table area, work tables might be created.	Table joining method (tree view) Table joining method (details view)
	`HAVING`	The `HAVING` clause is specified. This item might also be displayed when a derived table is expanded even though the `HAVING` clause is not specified.	`HAVING` clause specification
`I`	`INDEX`	The grouping method that uses the characteristics of B-tree indexes is performed.	Grouping methods
	`INDEX` `COLUMN`	Information related to indexed columns. For B-tree indexes, the name of the indexed column, the key value sort order, and the search condition are output. For text indexes and range indexes, the name of the indexed column is output.	Information related to indexes
	`INDEX` `NAME`	Indicates the index name.	Information related to indexes
	`INDEX` `SCAN(schema-name.table-identifier(query-name-or-correlation-name))`	An index scan is performed in the table retrieval processing. If there is a query name or a correlation name, it is displayed.	Table retrieval method (tree view) Table retrieval method (details view)
	`INDEX` `TYPE`	The index type (B-tree index, text index, or range index).	Information related to indexes
	`INNER` `JOIN`	An inner join is specified.	Information related to table joining methods
	`INSERT` `STATEMENT`	An `INSERT` statement is executed.	SQL statements executed
`J`	`JOIN` `TYPE`	Join type	Information related to table joining methods
`K`	`KEY` `SCAN`	A key scan is performed in the table retrieval processing.	Table retrieval method (tree view) Table retrieval method (details view)
`L`	`LIMIT` `offset,row_count`	The `LIMIT` clause is specified. If the offset row count is not specified, the offset row count is not displayed. If dynamic parameters are specified for either or both of the offset row count and limit row count, `?` `PARAMETER` is displayed.	`LIMIT` clause specification
	`LEFT` `OUTER` `JOIN`	An outer join performed by a `LEFT` `OUTER` `JOIN` is specified.	Information related to table joining methods
	`LOCAL` `HASH` `GROUPING`	Local hash grouping is performed. If there are rows that cannot be processed in the hash grouping area, work tables might be created.	Grouping methods
`N`	`NESTED` `LOOP` `JOIN`	A nested loop join is performed in the table join processing.	Table joining methods (tree view) Table joining methods (details view)
`O`	`ORDER`	Sequential execution, not out-of-order execution, is applied.	Sequential execution
`P`	`PROBE` `COLUMN`	If hash join is applied as the table joining method, information about the joined columns in the inner table is output. If a hash filter is applied, hash filter information is also output.	Hash retrieval information (`BUILD COLUMN` and `PROBE COLUMN`)
	`PROBE` `COLUMN`	If hash execution is applied as the method for processing subqueries that do not contain external reference columns, column information to be compared with the result of the subquery specified in the search condition is output. If hash execution is applied as the method for processing subqueries that contain external reference columns, information about the external reference column specified in the subquery is output. If a hash filter is applied, hash filter information is also output.	Information about subqueries
	`PURGE` `CHUNK` `STATEMENT`	A `PURGE` `CHUNK` statement is executed.	SQL statements executed
`Q`	`QUERY`	A query other than a subquery or a derived table is specified.	Query types
`Q`	`QUERY` `SCAN(QUERY` `query-tree-number)`	A query scan is performed.	Query scan
`R`	`RECURSIVE`	This item indicates that a recursive query will be run.	Specification of set operations
`R`	`RIGHT` `OUTER` `JOIN`	An outer join performed by a `RIGHT` `OUTER` `JOIN` is specified.	Information related to table joining methods
`S`	`SEGMENT`	The segment skip condition is used.	Information related to indexes
	`SELECT` `STATEMENT`	A `SELECT` statement is executed.	SQL statements executed
	`SET` `OPERATION`	A set operation is specified.	Specification of set operations
	`SET` `OPERATION` `TYPE`	The type of set operation that is executed.	Information related to set operations
	`SKIP` `COND`	Type of range index condition.	Information related to indexes
	`SORT` `GROUPING`	Sort grouping is performed.	Grouping methods
	`SORTING` `{BYTE\|ISO}`	Sort processing by the `ORDER` `BY` clause is performed. This information might not be displayed even though the `ORDER` `BY` clause is specified.	Sort processing
	`SPECIFIC`	Set operation method specification is enabled.	Set operation method specification
		Subquery processing method specification is enabled.	Subquery processing method specification
		The grouping method specification specified in the `GROUP` `BY` clause is enabled.	Grouping methods
		`SELECT` deduplication method specification is enabled.	`SELECT` deduplication method specification
		The index specification is enabled.	Index specification
		Join method specification is enabled.	Join method specification
	`SPECIFIC` `DISABLED`	The index specification is disabled.	Index specification
	`SPECIFIC` `DISABLED`	The join method specification is disabled.	Join method specification
	`SUBQUERY`	A subquery processing method other than nested loop execution or hash execution is applied.	Subquery processing methods
	`SUBQUERY` `HASH`	Hash execution is applied as the subquery processing method.
	`SUBQUERY` `LOOP`	Nested loop execution is applied as the subquery processing method.
`T`	`TABLE` `FUNCTION` `DERIVED` `TABLE(correlation name)`	A table function derived table is specified.	Specification of table function derived table
	`TABLE` `SCAN`	A table scan is performed in the table retrieval processing.	Table retrieval method (tree view) Table retrieval method (details view)
	`TABLE` `VALUE` `CONSTRUCTOR` `SCAN`	Table value constructors are retrieved.	Information retrieved for table value constructors
`U`	`UNIQUE`	This unique index does not violate the uniqueness constraint.	Information related to indexes
	`UNIQUE` `INVALID`	This unique index violates the uniqueness constraint.	Information related to indexes
	`UPDATE` `STATEMENT`	An `UPDATE` statement is executed.	SQL statements executed
	`USE FILTER`	The number of the hash filter to be used is output.	Hash retrieval information (`BUILD COLUMN` and `PROBE COLUMN`)
	`USE FILTER`	The number of the hash filter to be used is output.	Information about subqueries
	`USING` `CACHE`	Cache is used to store the results of a subquery.	Subquery cache usage information
	`USING` `COST`	Cost information is collected in relation to a table or index.	Collecting cost information
`W`	`WINDOW`	A window function is specified.	Specification of window functions
`W`	`WORK` `TABLE` `SCAN(WORK` `TABLE` `work-table-number)`	A work table is scanned. A unique work table number is assigned to each work table.	Work table scan

To Page Top