SYS.PLAN

The PLAN table contains the execution plan generated by the TimesTen query optimizer. See Viewing SQL Query Plans in the Oracle TimesTen In-Memory Database Operations Guide.

Columns

Column name	Type	Description
`STEP`	`TT_INTEGER NOT NULL`	Ordinal number of the operation, starting at 1
`LEVEL`	`TT_INTEGER NOT NULL`	Level of this operation in the plan tree
`OPERATION`	`TT_CHAR(127) NOT NULL`	Type of operation `TblLkSerialScan` - full table scan `RowLkSerialScan` - full table scan `TblLkRangeScan` - range scan `RowLkRangeScan` - range scan `TblLkHashScan` - hash lookup `RowLkHashScan` - hash lookup `TblLkRowidScan` - rowid lookup `RowLkRowidScan` - rowid lookup `TblLkUpdate` - update of one or more rows `RowLkUpdate` - update of one or more rows `TblLkDelete` - delete of one or more rows `RowLkDelete` - delete of one or more rows `TblLkInsert` - insert of one or more rows `RowLkInsert` - insert of one or more rows `TmpTtreeScanTmpHashScan` - creation of a temporary index `NestedLoop [OuterJoin \| SemiJoin]` - nested loop join (with optional outer join or semijoin) `MergeJoin` - merge join `OrderBy` - row sort (requires extra temp space) `SortedDistinct` - identification of distinct rows from a sorted list (requires minimal extra space) `Distinct` - identification of distinct rows from an unsorted list (requires extra temporary space) `SortedGroupBy` - identification of distinct groups from a sorted list (requires minimal extra space) `GroupBy` - identification of distinct groups from an unsorted list (requires extra temp space) `TmpTable` - materialization of intermediate results (requires extra temporary space) `TblLkUpdView` - update of a view based on changes to detail table(s) `RowLkUpdView` - update of a view based on changes to detail table(s) `OracleInsert` - flushed changes to the Oracle database `ZeroTblScan` - evaluation of a predicate on a single set of values (no scan required) `ViewUniqueMatchScan` - unique identification of those view rows that need to be updated (requires extra temp space)
`TBLNAME`	`TT_CHAR(31)`	Name of table scanned at this step Column is `NULL` if no table is scanned.
`IXNAME`	`TT_CHAR(31)`	Name of index used at this step Range index names may have a "`(D)`" after the name, which indicates a descending scan. Column is `NULL` if no index is scanned.
`PRED`	`TT_VARCHAR(1024) NOT INLINE`	Predicate applied during table or index scan or join Column is `NULL` if no predicate applies.
`OTHERPRED`	`TT_VARCHAR(1024) NOT INLINE`	Predicate applied after table or index scan or join Column is `NULL` if no predicate applies.
`MISC`	`TT_VARCHAR` `(65536)` `NOT` `INLINE`	Stores constraint information, including the type of the constraint and, where applicable, the index name and the table name of the unique or foreign key constraints.