Subject | WHERE optimization |
---|---|
Author | Alexander Tabakov |
Post date | 2003-02-13T09:47:10Z |
Hi again,
Does anybody know the order in which the predicates from the WHERE clause
of a SELECT statement execute.
For example
WHERE
PREDICATE_1 and PREDICATE_2 and PREDICATE_3
which one is first
--
Best regards,
Alexander mailto:saho@...
Does anybody know the order in which the predicates from the WHERE clause
of a SELECT statement execute.
For example
WHERE
PREDICATE_1 and PREDICATE_2 and PREDICATE_3
which one is first
--
Best regards,
Alexander mailto:saho@...