IN or OR? whats the diff?

[Ratheesh K J]

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