Interested to Buy Any Domain ? << Click Here >> for more details...
What is the diffrence between IN and EXISTS.which one is
faster.
- 3 Answers
- 8948 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
Which function is used to return remainder in a division operator in sql?
Is sql scripting language?
How can you load multi line records? : aql loader
Can pl sql procedure have a return statement?
Difference between truncate, delete and drop commands?
How do I count duplicates in sql?
Does access use sql?
Is sql a microsoft product?
Define commit?
What are the benefits of pl sql?
what is the difference between cluster and non cluster index? : Sql dba
What is a boolean in sql?
what is self join and what is the requirement of self join? : Sql dba
What is a Mapplet?
How many types of sql are there?
