Answer / monal

HERE'S THE SIMPLE ANSWER:
WHEN YOU USE 'IN', WHILE CHECKING FOR WHERE CONDITION SQL
SERVER ENGINE DOES WHOLE TABLE SCAN.
IF YOU USE 'EXISTS' AS SOON AS ENGINE FINDS THE REQUIRED
ROW IT WILL STOP EXECUTING QUERY AND GOING FURTHER SCANNING
TABLE.

SO BASICALLY EXISTS IS FASTER AS COMPARED TO IN.

Answer / vijaykumar dolli

using the IN clause, you're telling the rule-based
optimizer that you want the inner query to drive the outer
query (think: IN = inside to outside).

When you write EXISTS in a where clause, you're telling the
optimizer that you want the outer query to be run first,
using each value to fetch a value from the inner query
(think: EXISTS = outside to inside).

Thank you

Answer / pranab

IN:

Returns true if a specified value matches any value in a
sub-query or a list.

Exists:

Returns true if a sub-query contains any rows.

Answer / navneet sharma

IN work like a OR in sql query but in is faster than OR in
case of IN server will search whole table
EXISTS is use to find the required row and does not search
whole table

Answer / arslan

the basic difference between in and exists

let's take the example of for loop in c++ and in loops when you write break statement it will iterates until the condition of break statement will true this like exist and in
if you didn't put break in it then it will execute the whole loop

Answer / raja

in operator returns the condition satisfied rows only

But in exists operator if any condition satisfied it will returns all the rows.

Answer / s. raban

see my answers

Answer / x

No Difference

Answer / santhosh

Spelling Different

List some major differences between triggers and stored procedures?

0 Answers  

How to retrieve range of 10th rows to 20 th rows from total rows from a database table.? (Not from Dataset)

10 Answers   Cognizant, Infosys,

After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas

0 Answers  

What is the maximum number of instances in 32 bit and 64 bit sql server 2012?

0 Answers  

Explain what role entity and relationship play in an ER diagram.

0 Answers  

in tabase table having a column in it empname field is there which having 5 duplicate values is there i want deleted all the duplicates i want showing only one name only.

7 Answers  

What is pivot and unpivot?

0 Answers  

What are audit control procedures?

0 Answers   Ernst Young, Thomson Reuters,

Explain indexed views and partitioned view with their syntax.

0 Answers  

What are the types of stored procedures in an sql server?

0 Answers  

What is Trace flag?

1 Answers   Wipro,

What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

0 Answers