Answer Posted / subathra

IN: Inner query executes first and drives the outer query.
EXISTS: Outer query executes first and compares tge rows
retrived with the inner query.
Consider table tab1 has 1000 rows and table tab2 has 1000
rows.
IN: select t1.empid from tab1 t1 where t1.code in (select
t2.code from tab2 t2) -- All rows in t1 will read with t2
and the effect is 1000 X 1000 rows.
EXISTS: select t1.empid from tab1 t1 where exists (select 1
from tab2 t2 where t1.code=t2.code) -- Max of 1 row will be
read for each row of t1 and thus reduces the processing
overhead.
Thumb rule:
1) If the majority of the filtering are in the sub query
then use IN.
1) If the majority of the filtering are in the outer query
then use EXISTS.

how to drop an existing table in mysql? : Sql dba

981

---

Can we group by two columns in sql?

942

---

Explain the working of primary key?

1033

---

What is an intersect?

1042

---

Give the order of sql select?

1084

---

Explain the uses of database trigger.

1053

---

Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

952

---

How to get unique records from a table?

896

---

Can sql developer connect to db2?

981

---

Are null values same as that of zero or a blank space?

965

---

Do we need commit after truncate?

1028

---

how is myisam table stored? : Sql dba

996

---

What are types of exception?

873

---

How do I count duplicates in sql?

1024

---

Write an sql query to select all records from the table?

967

---