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


Please Help Members By Posting Answers For Below Questions

What is coalesce in sql?

533


Are pl sql variables case sensitive?

563


What is indexing oracle sql?

536


Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

572


What is pl sql commands?

534






What is data definition language?

591


What is a full join?

502


Is sql procedural language?

533


How can we store rows in PL/SQL using array?

639


Which is faster union or join?

466


What are the types of variables use in pl sql?

479


What is sql and explain its components?

567


Can variables be used in sql statements?

531


how do you know the version of your mysql server? : Sql dba

488


How many types of tables are there?

477