Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


What is the diffrence between IN and EXISTS.which one is
faster.

Answers were Sorted based on User's Feedback



What is the diffrence between IN and EXISTS.which one is faster...

Answer / 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

What is the diffrence between IN and EXISTS.which one is faster...

Answer / rashmi

> we use IN gives better performance when there is less number of record in a table (up to 999 records), But for large number records EXIST give better performance.
>In may or may not depends a sub query all time, But EXIST always depend on a sub query.

Is This Answer Correct ?    2 Yes 1 No

What is the diffrence between IN and EXISTS.which one is faster...

Answer / manoranjan sethy

Exist operator always faster then In operator.
because assume that we gave value like in(10) then what is does? it will search my entire table and wherever 10 is found it will return as output.
but in exist operator if 10 found then optimizer will stop the searching process that is how exist gives more performance.

ii) In operator all ways conduct pattern search process but exist conduction boolean state of search process.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer



More SQL PLSQL Interview Questions

What are the operators used in select statements?

0 Answers  


What are the types of keys?

0 Answers  


when a procedure /package is getting invalidated?

4 Answers   TCS,


What are the key differences between SQL and PL SQL?

0 Answers  


What is keys and its types?

0 Answers  






Explain the select statement in sql?

0 Answers  


What is the source code of a program?

0 Answers  


What is type and rowtype in pl sql?

0 Answers  


what is the difference between a having clause and a where clause? : Sql dba

0 Answers  


What will you get by the cursor attribute sql%rowcount?

0 Answers  


What is sap sql anywhere?

0 Answers  


what does it mean to have quoted_identifier on? : Sql dba

0 Answers  






Categories