You need to sign in to do that
Don't have an account?

Which clause is better IN or OR
select id from account where name='123' or name='345' or name='456';
or
select id from account where name IN ('123','345','456');
Which one you all think is optimized more. Or both are same??
IN will be the better option always for large no of options.
If this post is helpful please throw Kudos.If this post solves your problem kindly mark it as solution.
Thanks
There's also a great webinar that you find interesting here: http://wiki.developerforce.com/page/Webinar:_Inside_the_Force.com_Query_Optimizer_(2013-Apr)