Interested to Buy Any Domain ? << Click Here >> for more details...
What is the diffrence between IN and EXISTS.which one is
faster.
- 3 Answers
- 8797 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 the difference between nested subquery and correlated subquery?
Cite the differences between execution of triggers and stored procedures?
What are the operators used in select statements?
how can we optimize or increase the speed of a mysql select query? : Sql dba
Define SQL and state the differences between SQL and other conventional programming Languages?
What is the difference between functions, procedures, and packages in pl/sql?
how would you enter characters as hex numbers? : Sql dba
What is dense_rank in sql?
How to display Row Number with Records in Oracle SQL Plus?
What are the two characteristics of a primary key?
what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba
What is nosql example?
What is foreign key and example?
What is sql resultset?
Explain the working of primary key?
