Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the EXPLAIN statement?
- 1 Answers
- 5054 Views
- I also Faced
- E-Mail Answers
Explain the EXPLAIN statement?..
Answer / 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 |
More DB2 Interview Questions
what is a trigger and types of triggers
How will you delete duplicate records from a table?
What is dclgen (declaration generator)?
How do you define a correlated name?
What do you mean by NOT NULL WITH DEFAULT? When will you use it?
Where can you declare a cursor in a cobol-db2 program?
Is schema the same as database?
Where are plans stored?
Mention the various locks that are available in db2.
Can we able to find all the Table names under a Particular Plan?
Explain about open switch business continuity software?
What are catalog tables in db2?
COBOL 
