Check out example codes for "oracle index hint". It will help you in understanding the concepts better.
Code Example 1
SELECT /*+ parallel(8) full(<table_name_or_alias>) index(<table_name_or_alias> <index_name>) */...
Learn ReactJs, React Native from akashmittal.com