All Forums Database
Niesh20us 78 posts Joined 06/13
08 Oct 2015
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

oshun 43 posts Joined 07/10
08 Oct 2015

There is no difference.

visit my private blog at http://www.dwhpro.com

You must sign in to leave a comment.