Apa Saja yang Ada Setelah Tanda "/*+" Part 1

Table-access Hints

• INDEX ( Alias_Name Index_Name)
  This directs Oracle, when possible, to access the alias Alias_Name using the index named Index_Name. Repeat this hint for each index/alias combination you need to control.
• FULL ( Alias_Name)
  This directs Oracle, when possible, to access the alias Alias_Name using a full table scan. Repeat this hint for each full table scan you require.
• INDEX_DESC ( Alias_Name Index_Name)
  This directs Oracle, when possible, to access the alias Alias_Name using the index named Index_Name, reaching the rows in descending order (the reverse of the normal index-sorted order). Repeat this hint for each index/alias combination you need to control, although it is unlikely you will need it more than once in a query.

Taken from Dan Tow's SQL Tuning