use index hint oracle code example
Example: oracle index hint
SELECT /*+ parallel(8) full(<table_name_or_alias>) index(<table_name_or_alias> <index_name>) */...
SELECT /*+ parallel(8) full(<table_name_or_alias>) index(<table_name_or_alias> <index_name>) */...