Re: Order of clauses in SELECT...WHERE

Changing the order will not affect the performance. Ideally, you should index all the join columns

mstanbrook_at_yahoo.com (Michael Stanbrook) wrote in message news:<4df22773.0210031802.e46997c_at_posting.google.com>...
> 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 - 11:28:50 CEST