table names in hint in oracle query code example
Example 1: oracle index hint
SELECT /*+ parallel(8) full(<table_name_or_alias>) index(<table_name_or_alias> <index_name>) */...
Example 2: oracle index hint multiple tables example
SELECT /*+ parallel(8) full(<table_1_name_or_alias>) index(<table_1_name_or_alias> <index_1_name>) index(<table_2_name_or_alias> <index_2_name>) */...