Interested to Buy Any Domain ? << Click Here >> for more details...
What is the diffrence between IN and EXISTS.which one is
faster.
- 3 Answers
- 8914 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
Can we call stored procedure in function?
When is a declare statement required?
What is the difference between rollback and rollback to statements?
what is a database transaction? : Sql dba
how to drop an existing view in mysql? : Sql dba
What are the benefits of triggers?
What are the benefits of pl/sql packages?
What are transaction and its controls?
What does pl sql stand for?
What are hotfixes and patches?
what is oracle database ? : Sql dba
Does user triggers have entry for trigger with compilation errors?
What is sql*loader and what is it used for?
What are the ddl commands?
how can we optimize or increase the speed of a mysql select query? : Sql dba
