.
This means IN is very quick if the IN value list consists entirely of
constants.
Thanks,
VisolveDB Team
- Original Message -
From: "Ratheesh K J" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, August 01, 2006 10:22 AM
Subject: IN or OR? whats the diff?
Hello all,
Just w
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 );
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 Bha
