can we view the access paths created by dbrm ? how ? thx
Answer Posted / krishna
I think not possible. information about
access path stored in database catalog.
access path is stored in DB DIRECTORY, it can be used by
DB2 internally. no one can access the dB2 directory
if wrong please post right answer
| Is This Answer Correct ? | 1 Yes | 7 No |
Post New Answer View All Answers
Can one database have multiple instances?
How to execute stored procedure in db2 command editor?
What is db2 plan table?
What is role in db2?
Comment whether the cursor is closed during commit or not.
What is the use of commit in db2?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What is null value in db2?
What is the physical storage length of date data type?
What is a db2 schema?
List down the data types in the db2 database.
Who uses db2?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
Discuss about db2 bind?
What is difference between isnull and coalesce?