View Full Version : Speed of mysql query

07-27-2011, 08:59 PM
Is there a difference between the speed of these two queries

SELECT * FROM table WHERE field1='blabla' and field2='blabla'

SELECT * FROM table WHERE field2='blabla' and field1='blabla'

Old Pedant
07-27-2011, 09:48 PM
Shouldn't be.

Speed differences could occur based on what fields are indexed. But if the same field (or fields) are indexed in both versions, speed should be identical or nearly so.