Order of clauses in SELECT...WHERE

Situation:

SELECT *
FROM A, B
WHERE
A.CHILDID=B.PARENTID
AND B.STATUS='GOOD' Say for the sake of argument that B.ParentID is not indexed in table B, but B.STATUS is.

Does putting changing the order of the WHERE clauses have any effect on the index usage and/or performance?

e.g.

SELECT *
FROM A, B
WHERE
B.STATUS='GOOD'
AND A.CHILDID=B.PARENTID Received on Fri Oct 04 2002 - 04:02:16 CEST