What do you need to do before you do EXPLAIN ?
Answer / naveen87ginjupalli
The Plan_table is created under the AUTHID.
| Is This Answer Correct ? | 5 Yes | 0 No |
What is the difference between cursor and select statement?
what is the use of cursors?
What is a page in db2?
Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?
What's The Percentage Free Space ?
Write a query to extract first 5 characters of a name in the column Stud_Name?
How can you do the explain of a dynamic sql statement?
How to know the primary key of a table without defining the primary key in the table?
What is role in db2?
What parameters are used to control the free space in DB2?
What is bufferpool in db2?
What is the difference between primary key & unique index ?