Subject About conditions in SQL query.
Author William Gonz�les S.
Hello all.
I have a question about the order in 'WHERE' statement
in SQL queries. If I have:

1)
select * from SOME_TABLE
where (OBJECT_ID=100)
and (ACTIVE=1)

FB searchs first for OBJECT_ID matches and then for
ACTIVE in the results?

2)
select * from SOME_TABLE
where (ACTIVE=1)
and (OBJECT_ID=100)

FB searchs first for ACTIVE matches and then for
OBJECT_ID in the results?
-----------------------

or the order of conditions in WHERE does not matter to
FB?

Thanks in advance,
William GS

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com