Answer Posted / s
EXPLAIN, determines the access path that will be used by
DB2 to execute that particular SQL statment. The results
are written to the PLAN table.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Why cursor is used in db2?
How to check last update on table in db2?
What is the difference between cursor and select statement?
What is a bind card?
What is coalesce in db2?
What is cursor with hold option in db2?
What is the use of runstats in db2?
What is runstats db2?
How does coalesce work?
What are the rules for db2 programming?
What is the maximum size of varchar data type in db2?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What is the difference between dbm cfg and db cfg file in db2 ?
What do you mean by rollback?
What is catalog database in db2?