Interested to Buy Any Domain ? << Click Here >> for more details...
What is the diffrence between IN and EXISTS.which one is
faster.
- 3 Answers
- 8952 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
Which tcp/ip port does sql server run on? How can it be changed? : Sql dba
Why do we use joins in sql?
What is memory optimized table?
What are the operators used in select statements?
Can we create view in stored procedure?
What is the difference between microsoft access and sql?
What is java sql drivermanager?
what is a constraint? : Sql dba
Inline the values in PL/SQL, what does it mean.?
Do foreign keys improve performance?
How does one load ebcdic data? : aql loader
How many types of triggers are there in pl sql?
What is rtm stands for?
Can dml statements be used in pl/sql?
What is raid? How does it help storage of databases?
