Hi, I have a query which goes something like,
from T1 Left Outer Join T2 On T1.D = T2.M
where T1.A = 'zz' and T1.B = "yy"
Should I have a index on T1.A,T1.B and a seperate index on T1.D or should I combine them into one??