SYS.GV$INDEX_ADVICE_OUTPUT
This view contains a list of index recommendations from the last recorded capture at the specified level. It also returns an executable CREATE INDEX
SQL statement for creating the recommended index.
Usage with TimesTen Scaleout
This view contains the contents of the SYS.V$INDEX_ADVICE_OUTPUT view for every element in the database.
Usage with TimesTen Classic
This view contains data for the database to which the application is connected. It has the same contents as SYS.V$INDEX_ADVICE_OUTPUT.
Related view
Columns
See ttIndexAdviceCaptureOutput 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 an element in the database. Ignore this column in TimesTen Classic.