Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between IN and EXISTS operators in
SQL Server?
- 9 Answers
- 67582 Views
- ASD Lab, CSC, Intelligroup, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What happens on checkpoint?
How to connect a database with sql express.?
What are the differences between union, intersect, and minus operators?
How to rebuild master databse?
Why is the need for data conversion transformations?
What is a covering index?
What are the different types of backups avaialabe in sql server 2005?
What should be the fill factor for indexes created on tables? : sql server database administration
What is the data type of time?
How to use copy and concatenate commands in SQL?
What are the limitations/drawbacks or ssrs 2008 r2?
Mention the different authentication modes in sql server.
What are the properties of sub-query?
How can you find out which stored procedures are recompiling?
how can a database be repaired? : Sql server administration
