access path can be viewed by specifying the EXPLAIN Parameter in the bind

can we view the access paths created by dbrm ? how ? thx

Question Posted / shweta agarwal

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

Please Help Members By Posting Answers For Below Questions

What is a bind card?

1142

Explain about rct.

1025

What is node in db2?

986

How do I delete a table in db2?

1007

What is dclgen in db2?

1082

What is load replace in db2?

936

How to check sequence on a table in db2?

994

How to run db2 command in windows?

1136

How does db2 sample database connect?

972

What is with ur in db2?

1242

What is explain in db2?

959

How can you classify the locks in db2?

1032

What is package in cobol db2?

1076

What is innodb buffer pool?

977

How to rename a table in DB2 ?

1030