Interested to Buy Any Domain ? << Click Here >> for more details...
What is the diffrence between IN and EXISTS.which one is
faster.
- 3 Answers
- 9054 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
Explain what is a subquery ?
how to get a list of all tables in a database? : Sql dba
is mysql query is case sensitive? : Sql dba
Which is faster union or join?
What is coalesce sql?
What is sql constant?
Sql technical questions
Which sorts rows in sql?
Explain the difference between drop and truncate commands in sql?
What is the best free sql database?
Explain the update statement in sql
What is trigger in sql?
What is recursive stored procedure?
Which is faster view or stored procedure?
Write an sql query to select all records from the table?
