Tweet
I have a simple join statement
The indexes are
TBLA (A,B,C,D,E,F)
TBLB (A,B,C,D,E,F)
When I look at the advised indexes it comes up with index (F,E,D,C,A,B) for TBLB but none for TBLA. Why does it want the columns in a different order? What am I missing? Working with the statement in visual explain it says its doing index probes so everything seems to be in place.
Code:
SELECT LO.ID
INTO : H
FROM QTEMP / TBLA GR
LEFT OUTER JOIN TBLB AS LO
ON GR .A = LO.A
AND GR .B = LO.B
AND GR .C = LO.C
AND GR .D = LO.D
AND GR .E = LO.E
AND GR .F = LO.F
TBLA (A,B,C,D,E,F)
TBLB (A,B,C,D,E,F)
When I look at the advised indexes it comes up with index (F,E,D,C,A,B) for TBLB but none for TBLA. Why does it want the columns in a different order? What am I missing? Working with the statement in visual explain it says its doing index probes so everything seems to be in place.
Comment