Interested to Buy Any Domain ? << Click Here >> for more details...
What is the diffrence between IN and EXISTS.which one is
faster.
- 3 Answers
- 8787 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 you have more than one key in a database?
Which join is default?
How is data stored in sql?
What is a primary key example?
What is the non-clustered index in sql?
What is Materialized View? In What Scenario we Use Materialized View?
Is t sql a programming language?
What is oracle sql called?
what are the t string functions available in tsql? : Transact sql
What is left join in postgresql?
What is recursive join in sql?
What is sequence in sql?
What is plpgsql language?
what is meant by urlencode and urldocode? : Sql dba
who introduced sql?
