Achelous01

2

votes
0

answer
15

views

Oracle hint on multiple indexes with multiple join statement

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 ma...
Achelous01