Which will be faster out of these two queries

Which will be faster out of these two queries - one with OR or one with IN?

Posted by Swati Agarwal in Database | SQL Server on Nov 21, 2012

Do you know the answer for this question? Post it below.

This Feature is Sponsored By

500+ c# and .NET interview questions and answer videos.

Posted by Mahesh Patel on Nov 27, 2012

IN. Because While you use "OR" condition that means your sql select two set of record of index while "IN" is select one record set as per index

Posted by Ajay suwalka on May 06, 2013

Almost no difference.. Just checked it on 65000 rows with random values. Values are compared separately at run time whether they are using IN CLAUSE or using OR CLAUSE in query sql server usage same mechanism for both.

Related Questions

PREMIUM SPONSORS

DynamicPDF Developer Components Infragistics Nevron

TRENDING NOW

What is difference between C++ and C# Which is the first version of C# language. How to develop XNA Apps in Visual Studio 2012? How to Fetch Different Values in LINQ? How to Retrieve Column Names of a Table in SQL Server 2012? How to create Backup of Database in SQL Server 2012? How a table is truncating using LINQ How to Get Marquee Feature Without Marquee Tag in HTML5? How to enabled form validation in html5? How to import Data to Excel SpreadSheet in .NET

MOST LIKED QUESTIONS

Why do you want to leave your current company? In which situation(s), the use of "Delegate" is a good idea? Which namespaces are necessary to create a localized application? In which assembly MVC framework is defined ? What is difference between C++ and C# How a table is truncating using LINQ Types of Polymorphism How to declares a two-dimensional array in C#? What is Polymorphism? How does VB.NET/C# achieve polymorphism? I have some dll that developed by ASP application,can i use reuse that dll to ASP.net application,Is it possible ,How Explain?

In Focus

Related Questions