The INDEX hint forces a given index scan for a given table. In this case, the optimizer does not proceed to evaluate if there are any other indexes that can be used to build the access plan or whether a table scan is better for the given query.
The optional keyword REVERSE returns the rows in the reverse order. In this case, the query executor begins with the last page of the index and starts returning the rows in the descending (reverse) key order of the index.
In table‑name.index‑name, the table‑name is a fully qualified table name which can include the catalog‑name and schema‑name.
Examples:
SELECT --(* vendor(SOLID), product(Engine), option(hint) -- INDEX TAB1.IDX1 *)-- * FROM TAB1 WHERE I > 100
SELECT --(* vendor(SOLID), product(Engine), option(hint) -- INDEX MyCatalog.mySchema.TAB1.IDX1 *)-- * FROM TAB1 WHERE I > 100
SELECT --(* vendor(SOLID), product(Engine), option(hint) -- INDEX REVERSE MyCatalog.mySchema.TAB1.IDX1 *)-- * FROM TAB1 WHERE I > 100