|
Hi,
Does the order of the conditions in a where clause make a difference? I have a query that includes the columns that map to a unique index. If I put the conditions containing these columns first in the where clause the query executes very quickly. If I put other conditions first then the query takes over 30 seconds to run. Is this expected or is this a bug? If this is expected where could I have found this in the documentation?
Thanks,
John |
- RE: Query Performance Question John O. Hampton, Jr.
- RE: Query Performance Question John O. Hampton, Jr.
- Re: Query Performance Question Peter Willadt
- Re: Query Performance Question John Hampton
