Answer / neha

In the in clause, the inner query is executed first, hence if the inner query return less data than the outer query, then use IN clause, in the other scenario, user exists clause.

Also, in the exists clause the inner query always reference outer query's table, which may or may not be the case with in IN clause.

Answer / 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.

Answer / manoranjan sethy

Exist operator always faster then In operator.
because assume that we gave value like in(10) then what is does? it will search my entire table and wherever 10 is found it will return as output.
but in exist operator if 10 found then optimizer will stop the searching process that is how exist gives more performance.

ii) In operator all ways conduct pattern search process but exist conduction boolean state of search process.

Can a view be updated/inserted/deleted?If Yes under what conditions?

3 Answers  

---

Why truncate is used in sql?

0 Answers  

---

What is a schema sql?

0 Answers  

---

How can i insert data inro a table with 3 columns using FORALL?

2 Answers   Oracle,

---

display your age in months?

2 Answers  

---

what are date and time functions in mysql? : Sql dba

0 Answers  

---

Which are the different case manipulation functions in sql?

0 Answers  

---

How to maintain the history of code changes of pl/sql?

3 Answers  

---

What is different between union and minus?

7 Answers   Accenture, TCS,

---

how do you count the duplicate records in a table

10 Answers   Tech Mahindra,

---

table having two columns - entity,zone enity zone pen east pen west pen north pen south pen east pencil east pencil east pencil west I want the output as : entity east west north south pen 2 1 1 1 pencil 2 1 0 0

2 Answers  

---

Can I learn sql in a week?

0 Answers  

---