can we view the access paths created by dbrm ? how ? thx
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?
What is the self-referencing constraint?
Can we able to find all the Table names under a Particular Plan?
What is meant by explain?
Can we declare cursor in Procudere division or open the cursor in the Working storage section. Is there any particular rules in the usage of cursors lifecycle
How many databases can be created inside an instance in db2 ?
What is a composite index and how does it differ from a multiple index?
How can we read records for specific member in CL? AND rpg?
quary for 1> fetch last record 2> fetch in reverse order 3> fetch last 5 row 4> fetch second last record (their is no primary key) i think concept of count can be use for this in 4th
What do you mean by NOT NULL WITH DEFAULT? When will you use it?
How to get Top 10 Salaries from a Table
What db2 400?