What is the diffrence between IN and EXISTS.which one is
faster.
- 3 Answers
- 8296 Views
- Infogain, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What is the current version of postgresql?
What does count (*) do in sql?
how can you see all indexes defined for a table? : Sql dba
what is the difference between cluster and non cluster index? : Sql dba
What are the datatypes available in pl/sql ?
What is query syntax?
Why is a trigger used?
what is a materialized view? : Sql dba
Why use truncate instead of delete?
what is 'trigger' in sql? : Sql dba
What are sql objects?
What is spool?
How does sql store data?
Does group by remove duplicates?
Why is stored procedure faster than query?
