Hello folks!

Is it true that query performance will be enhanced if you place the
arguments in your where clause in a position such that the "most
prevalent" filters are towards the left?

So if I wanted to query a table that had fields for Gender and Color
and Pants and I wanted to see people who wear red pants the where
cluase would be

Where Gender='M' and Color='Red'

INSTEAD OF

Where color ='Red' and Gender='M'

So that the argument that removes the most records goes first.
Obviously, index and other criteria come into play as well.

I think the performace will not be affected if you place arguments in
different order. Check it with query analyser by setting show execution
plan

Madhivanan

[quoted text, click to view]
arguments in your where clause in a position such that the "most
prevalent" filters are towards the left? <<

No. And stepping on a bug does not cause rain.

[quoted text, click to view]

This was a holdover from the 6.5 optimizer days I believe. But has not been
true since then.


[quoted text, click to view]