SYS.V$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.

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.

Ignore the elementId column. It is unused.