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


Please Help Members By Posting Answers For Below Questions

Which operator is used in query for pattern matching?

599


Why triggers are used?

535


what is log shipping? : Sql dba

589


How does left join work in sql?

490


How do you update f as m and m as f from the below table testtable?

1011






What are some emotional triggers?

547


What is 19 null in sql?

508


What do you understand by pl/sql records?

507


What schema means?

500


Write the alter statement to enable all the triggers on the t.students table.

642


When is a declare statement required?

645


Explain what is a view?

573


What is sql entity?

505


What is the use of function in sql?

511


Which data dictionary views have the information on the triggers that are available in the database?

730