What is the diffrence between IN and EXISTS.which one is
faster.
Answer Posted / neha
In the in clause, the inner query is executed first, hence if the inner query return less data than the outer query, then use IN clause, in the other scenario, user exists clause.
Also, in the exists clause the inner query always reference outer query's table, which may or may not be the case with in IN clause.
Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
Is sql pronounced sequel or sql?
What is percent sign in sql?
What is the default isolation level in sql server? : Transact sql
what are date and time data types in mysql? : Sql dba
What is a relationship and what are they?
how to use regular expression in pattern match conditions? : Sql dba
What is latest version of sql?
What is where clause in sql?
Does pl/sql support create command?
Can we use update in sql function?
How to read xml file in oracle pl sql?
Is it possible to link two groups inside a cross products after the cross products group has been created?
What normalization means?
What are the advantages of normalization?
what is top in tsql? : Transact sql