1. System Tables and Views Reference
  2. System Tables and Views 
  3. SYS.V$OPT_JOIN_ORDER

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.

Usage with TimesTen Scaleout

This view contains data for the local element.

Usage with TimesTen Classic

This view contains data for the database to which the application is connected. It has the same contents as SYS.GV$OPT_JOIN_ORDER.

Related view

SYS.GV$OPT_JOIN_ORDER

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.

In addition to these columns, the view contains the elementId column of type TT_INTEGER NOT NULL that contains the element id for the element to which the application is connected. Ignore this column in TimesTen Classic.