I have a query as below :
SELECT /*+ INDEX(A T1_IX01) INDEX(A T1_IX02) INDEX(B T2_IX01) INDEX(C T2_IX02)*/ * FROM T1 A JOIN T2 B ON A.SOURCE = B.C1 JOIN T2 C ON A.TARGET = C.C1;
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.
With current state, it does only use one index from T1 which is stated as first hint but not the later one. Why and how should i solve this issue to get faster result?