Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between IN and EXISTS operators in
SQL Server?
- 9 Answers
- 67287 Views
- ASD Lab, CSC, Intelligroup, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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.
| Is This Answer Correct ? | 146 Yes | 14 No |
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
| Is This Answer Correct ? | 106 Yes | 15 No |
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.
| Is This Answer Correct ? | 27 Yes | 8 No |
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
| Is This Answer Correct ? | 29 Yes | 16 No |
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
| Is This Answer Correct ? | 7 Yes | 7 No |
Answer / raja
in operator returns the condition satisfied rows only
But in exists operator if any condition satisfied it will returns all the rows.
| Is This Answer Correct ? | 6 Yes | 15 No |
1. How to fetch all the duplicate records from the table. 2. How to fetch the second highest salary from the table.
What is checkpoint in sql server?
What is perspective, have you ever created perspective? : sql server analysis services, ssas
How do I start and stop sql server?
what are triggers? : Sql server database administration
Explain aggregate functions?
What is transaction server isolation?
What is normalization of database? What are its benefits?
what is raid and what are different types of raid configurations? : Sql server database administration
Difference between sql server 2000 and sql server 2005?
11 Answers Aditi Tech, eInfochips, GE, HCL, IBM, Masim Infotech, NIIT, Satyam, Systems Domain,
What are the different types of backup avaible in SQL SErver
How to find Duplicate Records In table?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
