What is the diffrence between IN and EXISTS.which one is
faster.
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 operator is used in query for pattern matching?
Why triggers are used?
what is log shipping? : Sql dba
How does left join work in sql?
How do you update f as m and m as f from the below table testtable?
What are some emotional triggers?
What is 19 null in sql?
What do you understand by pl/sql records?
What schema means?
Write the alter statement to enable all the triggers on the t.students table.
When is a declare statement required?
Explain what is a view?
What is sql entity?
What is the use of function in sql?
Which data dictionary views have the information on the triggers that are available in the database?