Operands

The following operands are used in the abstract plan syntax statements:

Table 33-1: Identifiers used

Identifier

Describes

table_name

The name of a base table, that is, a user or system table

correlation_name

The correlation name specified for a table in a query

derived_table

A table that results from the scan of a stored table

stored_table

A base table or a worktable

worktable_name

The name of a worktable

view_name

The name of a view

index_name

The name of an index

subquery_id

An integer identifying the order of the subqueries in the query

table_name and view_name can be specified using the notation database.owner.object_name.