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
What is difference between rollback and commit?
How would the varchar column remarks defined?
What does a deadlock mean in DB2?
What is the role of the data page in the db2 database?
What are db2 objects?
What action db2 takes when a program aborts in the middle of a transaction?
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?
Define sqlca.
What is buffer pool and list some of them?
What is the use of with ur in db2?
What is a Foreign Key?
What is the maximum size of varchar data type in db2?
Why cursor is used in db2?
Is db2 a mainframe?
What is the difference between spufi and qmf?