IN Clause

Database
Enthusiast

IN Clause

Hi Experts,

Can anyone tell me the difference between below 2 queries . I know result will be same for both the queries but which one will better performance and why ?

delete from tableA where columnA=123;

vs

delete from tableA where columnA in (123);

Thanks,

Nieshant

1 REPLY
Enthusiast

Re: IN Clause

There is no difference.

Roland Wenzlofsky