oracle multiple index hint code example
Example: 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>) */...
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>) */...