Subject | About conditions in SQL query. |
---|---|
Author | William Gonz�les S. |
Post date | 2006-02-13T13:29:37Z |
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
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