Answer Posted / mainframe.rahulz
EXPLAIN stores output in PLAN_TABLE
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What are foreign keys in db2?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
What is runstats utility in db2?
Which isolation level provides maximum concurrency?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
How do you find the maximum value in a column in db2?
What is db2 connect?
How to find primary key of a table in db2?
What is the difference between using bind () and rebind () methods of naming class?
What is dclgen (declaration generator)?
What is netezza database?
What are packages in db2?
What are the two types of logging in the db2 database? Explain them.