What is the diffrence between IN and EXISTS.which one is
faster.
Answers were Sorted based on User's Feedback
Answer / neha
In the in clause, the inner query is executed first, hence if the inner query return less data than the outer query, then use IN clause, in the other scenario, user exists clause.
Also, in the exists clause the inner query always reference outer query's table, which may or may not be the case with in IN clause.
Is This Answer Correct ? | 4 Yes | 1 No |
Answer / rashmi
> we use IN gives better performance when there is less number of record in a table (up to 999 records), But for large number records EXIST give better performance.
>In may or may not depends a sub query all time, But EXIST always depend on a sub query.
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / 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 |
What is the process of copying data from table a to table b?
Can we enter data in a table in design view?
When do we use triggers?
wht is the difference between truncat,drop in sqlserver wht is the difference between function and stored procedure
What is synchronized subquery?
How do I enable sql encryption?
what are the differences between char and nchar? : Sql dba
what is the difference between varray and table data type..please expalain with some examples... under what situation you will go for varray..instead of index by table...
what are the 'mysql' command line options? : Sql dba
what is the difference between join and union? : Sql dba
Two Methods of retrieving SQL?
7 Answers Atiric Software, Microsoft, Oracle, TCS, Wipro,
Explain the components of sql?