Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between IN and EXISTS operators in
SQL Server?
- 9 Answers
- 67171 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 is the difference between delete and truncate statements?
What stored by the master?
How do clustered indexes store data?
Explain how to use linked server?
mention different types of relationships in the dbms?
What does it mean to normalize a database and why would you do it?
What are secondary xml indexes?
What keyword you will use to get schema appended to the result set of a ‘for xml’ query?
How to get a list of columns in a view using "sys.columns" in ms sql server?
Can you move the resources after pausing the node? : sql server database administration
What is a scheduled job or what is a scheduled task?
How to locate and take substrings with charindex() and substring() functions?
What is the difference between the application object and session object?
What are the methods used to protect against sql injection attack?
how can u get last observation in an unknown dataset ?
