The following operands are used in the abstract plan syntax statements:
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.
