title: Oracle hint on multiple indexes with multiple join statement
body: <p>I have a query as below :</p>
  
  <pre><code>SELECT /*+ INDEX(A T1_IX01) INDEX(A T1_IX02) INDEX(B T2_IX01) INDEX(C T2_IX01)*/
         *
  FROM   T1 A
  JOIN   T2 B
  ON     A.SOURCE = B.C1
  JOIN   T2 C
  ON     A.TARGET = C.C1;
  </code></pre>
  
  <p>and i need to use 2 indexes from T1 I created with SOURCE column and another with TARGET column which has mapped value with T2's C1 which is indexed as well.</p>
  
  <p>With current state, it does only use one index from T1 which is stated as first hint but not the later one. <strong>To summarize, I would like to use two different indexes created on same table for two separate joins.</strong></p>
  
  <p>Why and how should i solve this issue to get faster result?</p>