DB2 can implement a join in three ways using a merge join,
a nested join or a hybrid join. Explain the differences?
- 1 Answers
- 2943 Views
- I also Faced
- E-Mail Answers
Answer / Harendra Singh
In DB2, a Merge Join combines rows from two input tables based on a common key. A Nested Loop Join scans one table and repeatedly looks for matches in the other table. A Hybrid Join uses both Merge and Nested Loop techniques to optimize performance.
| Is This Answer Correct ? | 0 Yes | 0 No |
What techniques will be used to avoid deadlock??
how to copy the host variables from ps file into cobol program other than include statement
What is the difference between cursor and select statement?
what's the best lock size that you could use when you create a tablespace?
in the CURSOR declare statement, if i am using an where clause and trying to compare the value with a host-varialble. EXEC SQL DECLARE C1 CURSOR FOR SELECT DEPTNO, DEPTNAME, MGRNO FROM DEPARTMENT WHERE ADMRDEPT = :ADM-DEPT Where would i need to provide value to this host-variable in the where clause. how could i pass value to this host-variable to check it.
What are the isolation levels possible ?
What are the disadvantages of PAGE level lock?
If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?
How do I add a column in db2?
What is a buffer in memory?
On the create tablespace, what does the CLOSE parameter do?
What is the SQL query to select, delete and get count of duplicate rows in DB2?
COBOL 
