Interested to Buy Any Domain ? << Click Here >> for more details...
can we view the access paths created by dbrm ? how ? thx
- 2 Answers
- 7053 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / shweta agarwal
access path can be viewed by specifying the EXPLAIN
Parameter in the bind JCL as YES..
synatx
EXPLAIN(YES).
| Is This Answer Correct ? | 24 Yes | 0 No |
Post New Answer View All Answers
What is collection in db2 bind?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
Can one database have multiple instances?
How can you count the number of rows from a table tab?
How do you select a row using indexes in db2?
Is it possible using max on a char column?
What is clone table?
Differentiate between cs and rr isolation levels? Where do you specify them?
How do you eliminate duplicate values in db2?
How can you do the explain of a dynamic sql statement?
What is the difference between plan and package in db2?
What is image copy in db2?
What is cursor stability in db2?
What is db2 stogroup?
What parameters are used to control the free space in DB2?
