Answer Posted / mainframe.rahulz
EXPLAIN stores output in PLAN_TABLE
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is a db2 table?
How to create db2 table in mainframe?
What is the clustering index in the db2 database?
What is iseries database?
How can you find out the # of rows updated after an update statement?
How can you quickly find out the # of rows updated after an update statement?
What is a bind card?
Explain package in db2 and its advantages?
How is deadlock resolved?
Is db2 relational database?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What is a bind in db2?
What type of database is db2?
Outputs of explain are with matchcols = 0. What does this signify?
What is innodb buffer pool?