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 |
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
what are the max. & min. no. of partitions allowed in a partition tablespace?
cursor with hold explain ?
What can the SET option of the Repair Utility accomplish?
What is the difference between SYNONYM and ALIAS?
What is sqlca’s maximum length?
what is a collection?
In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.
How can you count the number of rows from a table tab?
What is the purpose of the WHENEVER statement?
What is the result of open cursor statement?
What are concurrency issues?