Plan contains DBRM(machine level SQL statements) and Optimized Access Pat

Plan is an executable form of sql statements,But what
exactly resides inside a Plan. what are the details inside
Plan.

Question Posted / vaibhav

Answer Posted / vaibhav

Plan contains DBRM(machine level SQL statements) and
Optimized Access Path.

Is This Answer Correct ?

6 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is db2 and what is the use of db2 optimizer?

1110

What is ibm db2 client?

1006

What is a bind in db2?

1105

what is a corelated subquerry?

1169

Why do we use cursor?

1162

How do we specify index to include or not during bind process.

2175

Explain the function done by data manager?

1331

What is cursor with hold option in db2?

1136

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

1289

what is diffrence b/w file-aid tool and file-aid utility???

4959

What is ibm db2 connect?

1055

How do you pull up a query which was previously saved in qmf?

1205

What types of tables are there in the db2 database?

1101

What is the use of reorg in db2?

1137

Why do chiropractors use drop table?

1164