Answer / parnita

In pair wise comparison we write like this:"where (MGR_ID,
DEPT_ID) IN (SUBQUERY)"IN non pair wise comparison we write
like this:"where (MGR_ID) IN (SUBQUERY)and (DEPT_ID) IN
(SUBQUERY)"In first one we are checking two columns
simultaneously ...

Answer / taroon

See the thing is in pairwise comparison, we are taking the
columns which are of composite key type, so that the
comparisons will be very effective. But nonpairwise
comparisons are like multi_row subqueries with IN operator,
where we are checking single column values.

But the results will be different in both the cases. Just
try. If you want some examples regarding that, just do let
me know.

Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?

0 Answers  

---

what protocol both networks use? : Sql server database administration

0 Answers  

---

What's new in sql management studio for sql server? : sql server management studio

0 Answers  

---

What is the Disadvantage of indexed sequential file.

0 Answers   HCL,

---

What is the optimization being performed in oracle and SQL Server?

0 Answers   Cap Gemini,

---

What are the advantages of policy management?

0 Answers  

---

What is merge replication?

0 Answers  

---

How to turn on the mssql api module in php?

0 Answers  

---

What is data source view or dsv? : sql server analysis services, ssas

0 Answers  

---

Define tool Manage Statistics in SQL Server 2000 query ?

0 Answers   NA,

---

What is difference between stored procedure and function?

3 Answers   L&T,

---

What is model database? : SQL Server Architecture

0 Answers  

---