Re: Order of clauses in SELECT...WHERE

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
No. The hardcoded literal combined with equality, does though.

Hth

Sybrand Bakker
Senior Oracle DBA Received on Fri Oct 04 2002 - 09:34:42 CEST