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 |
When Can you be sure that a query will return only one row?
What is the self-referencing constraint?
What is dclgen in db2?
What does the CHECK Utility do ?
What are some SQL aggregates and other built-in functions?
What will the FREE command do to a plan?
Generally if I want to select the names starting with c I need to use c% But how could I code to select the data which contains % as a part of data.
What are the various locks available?
What are the various data types available in db2?
What are iseries servers?
how to resolve -818 error. how to see timestamp token in load module and plan
What is bind and rebind in db2?