SYS.V$OPT_JOIN_ORDER

This view contains data about the join order of the last prepared or executed SQL statement (SELECT, UPDATE, DELETE, and INSERT SELECT) in the current transaction.

Columns

See ttOptShowJoinOrder in the Oracle TimesTen In-Memory Database Reference for information on the columns in this view, including the column name, data type, and description.

Ignore the elementId column. It is unused.