What is the diffrence between IN and EXISTS.which one is
faster.
- 3 Answers
- 8292 Views
- Infogain, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
what is sql server agent? : Sql dba
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
Can we create foreign key without primary key?
difference between anonymous blocks and sub-programs.
Can we write dml inside a function in sql server?
what is a table in a database ? : Sql dba
How do you use join?
How do I run sql profiler?
How many sql statements are used? Define them.
what is dbms? : Sql dba
What are schema-level triggers?
What is sql stand for?
How to handle bulk data?
How delete all records from table in sql?
How many primary keys can a table have?
