Explain the EXPLAIN statement?
- 1 Answers
- 4620 Views
- I also Faced
- E-Mail Answers
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 |
can any one give the list of some important sql abend codes which r frequently asked in interviews?
how can you access index
What is the maximum No of rows per page?
What is db2 isolation?
Once you create a view, where would information about the view be stored?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What os does db2 run on?
How is the value function used?
what are bind concepts in db2 cobol?
What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?
how 2 resolve the -311 sqlcode
My SQL is not performing well. Describe how will you fine tune it?
COBOL 
