Ratheesh K J wrote:
Hello all,
Just wanted to know if using IN in the where clause is better than OR in terms
of performance.
that is :
Are these both same in terms of performance
SELECT * FROM TABLE
WHERE ( COLUMN = 1 OR COLUMN = 2 );
SELECT * FROM TABLE
WHERE COLUMN IN ( 1, 2 );
thanks,
Ratheesh Bhat K J
They are the same.
You can verify that mysql treats them the same by putting EXPLAIN in front of
each. See the manual for details
<http://dev.mysql.com/doc/refman/4.1/en/explain.html>.
Michael
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]