What do you need to do before you do EXPLAIN?
Answer / s
Create the Plan_table to holds the results of the explain.
| Is This Answer Correct ? | 5 Yes | 0 No |
What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?
What is innodb buffer pool?
Hi this is sures. i need to practice the ibm mainframes.could u telme how can i get userid from IBM.how much cost they will collect for one user id.can send me the details please.thanq
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
Describe major components of db2?
What is a Cartesian product?
How do I copy a table in db2?
There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 employes........
is it compulsory commitment control in journal?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What is explain plan in db2?
How is a typical DB2 batch program executed ?