Oracle hint on multiple indexes with multiple join statement

Refresh

4 days ago

Views

15 time

2

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?

0 answers

Смотреть фильмы онлайн бабушка легкого поведения 2 фильм бесплатно