What is the diffrence between IN and EXISTS.which one is
faster.
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 coalesce in sql?
Are pl sql variables case sensitive?
What is indexing oracle sql?
Which column of the user triggers data dictionary view displays the database event that will fire the trigger?
What is pl sql commands?
What is data definition language?
What is a full join?
Is sql procedural language?
How can we store rows in PL/SQL using array?
Which is faster union or join?
What are the types of variables use in pl sql?
What is sql and explain its components?
Can variables be used in sql statements?
how do you know the version of your mysql server? : Sql dba
How many types of tables are there?