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.

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum