Query Efficency Question

[fmrock]

I am trying to make a query more efficient, and was wondering if it makes a difference the order of the clause in the join

FROM 
	ACCOUNT A 
	JOIN CHARGES C ON ((A.ACCTCPCODE = C.CPCODE) AND (A.ACCTCODE = C.ACCOUNT))
WHERE

OR

FROM 
	ACCOUNT A 
	JOIN CHARGES C ON ((C.CPCODE=A.ACCTCPCODE) AND (C.ACCOUNT=A.ACCTCODE))
WHERE

 

[BJCooperIT]

Did you run an explain plan? It would tell you if changing the order makes a difference.

^{Beware of false knowledge; it is more dangerous than ignorance. ~George Bernard Shaw}
Consultant Developer/Analyst Oracle, Forms, Reports & PL/SQL (Windows)
My website: www.EmuProductsPlus.com

 

[sem]

fmrock:
No, it doesn't matter.

BJCooperIT:
2 similar plans may produce different workload, e.g. in case of compound indexes. At least it was in older Oracle versions, where the order of predicates mattered.

Regards, Dima

http://seminihin.narod.ru