Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / s
EXPLAIN, determines the access path that will be used by
DB2 to execute that particular SQL statment. The results
are written to the PLAN table.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is the physical storage length of time data type?
How is a typical db2 batch pgm executed?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
Define declaration generator (dclgen).
What is data manager?
What is the difference between cursor and select statement?
What is check constraint in db2?
What is dbrm? What it contains?
What is a cursor in programming?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
How can record locking be achieved in those DB2 versions which do not support it?
is it compulsory commitment control in journal?
What is temporal table in db2?
What is the default page size of buffer pools?
What is nvl in db2?
