Hello,

Is it permissible to order a clause such that the search term is the
first item (in the clause)?

standard:
field1 IN (123, 654, 789)

in question:
123 IN (field1, field2, field3)

I am interested to know if the optimizer treats this any differently
if anybody can shed any light on it (except for the obvious difference
in the above queries!)

Thanks,


Andy

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to