Connecting Tech Pros Worldwide Help | Site Map
bytes > topic > mysql > answers

Using IN or OR

Newbie
  
Join Date: Nov 2008
Posts: 1
#1: Nov 26 '08
in MySQL queries, which one is more performance optimized between IN and OR operators.
mwasif's Avatar
Moderator
  
Join Date: Jul 2006
Location: Pakistan
Posts: 718
#2: Nov 26 '08

re: Using IN or OR

I don't think there is any performance difference.
Atli's Avatar
Moderator
  
Join Date: Nov 2006
Location: Iceland
Posts: 3,739
#3: Nov 26 '08

re: Using IN or OR

Everything in MySQL is optimized for performance. I doubt it very very much that minor syntax differences like these would affect the performance.

You could always simply try them both out and see for yourself.
mwasif's Avatar
Moderator
  
Join Date: Jul 2006
Location: Pakistan
Posts: 718
#4: Nov 27 '08

re: Using IN or OR

You can use EXPLAIN to compare the performance of both the queries.
Reply

Tags
performance, query, using in, using or

« previous question | next question »

Similar MySQL Database bytes

/bytes/development

/bytes/it

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,272 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml
it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

About Bytes | Copyright 1995-2009 BYTES. All rights Reserved