Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
Thread: Speed of mysql query
07-27-2011, 09:59 PM #1
- Join Date
- Nov 2008
- Thanked 0 Times in 0 Posts
Speed of mysql query
Is there a difference between the speed of these two queries
SELECT * FROM table WHERE field1='blabla' and field2='blabla'Code:
SELECT * FROM table WHERE field2='blabla' and field1='blabla'
07-27-2011, 10:48 PM #2
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.