Small Correction: With explain(Yes) option, Access path or optimizer's

what is the steps followed in EXPLAIN Process or EXPLAIN
command. (Explain is for identifying the optimized access
path but how or what is the steps for doing the EXPLAIN)

Question Posted / bob

4 Answers
9168 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / bob

Small Correction: With explain(Yes) option, Access path or optimizer's strategy/information will be stored in package_owner.plan_table

Is This Answer Correct ?

6 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are packages in db2?

1071

Is ibm db2 free?

1063

What is database alias db2?

1177

What is ibm db2 used for?

1128

What is sqlca’s maximum length?

1246

What is dbrm? What it contains?

1212

What is rct?

1287

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

4370

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

7200

What is a bind in db2?

1100

What are the contents of a dclmgen?

1176

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

1141

How will you return the number of records in table?

986

What is plan in cobol db2?

1201

Differentiate between cs and rr isolation levels? Where do you specify them?

1115