SELECT A.A,B.B FROM TABLEA AS A JOIN TABLEB AS B ON A.A=B.B AND A.AA=B.BB WHERE A.A=1
SELECT A.A,B.B FROM TABLEA AS A JOIN TABLEB AS B ON A.A=B.B AND A.AA=B.BB AND A.A=1
create index idx_a_aa on TABLEA(A,AA) create index idx_a_aa on TABLEB(B,BB) SELECT A.A,B.B FROM TABLEA join A TABLEB AS B on A.A=B.B AND A.AA=B.BB AND A.A=1
SELECT A.A,B.B
FROM TABLEA AS A JOIN TABLEB AS B ON A.A=B.B AND A.AA=B.BB
WHERE A.A=1
FROM TABLEA AS A JOIN TABLEB AS B
ON A.A=B.B AND A.AA=B.BB AND A.A=1
create index idx_a_aa on TABLEB(B,BB)
SELECT A.A,B.B
FROM TABLEA join A TABLEB AS B on A.A=B.B AND A.AA=B.BB AND A.A=1