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 dbrm? When it will be created?

1029

How can you find out the # of rows updated after an update statement?

1116

What is lock escalation in db2?

1033

What is the use of value function?

1151

What is a db2 collection?

1046

Is it possible using max on a char column?

1139

What are the bind parameters ibm db2?

1053

What is the difference between spufi and qmf?

1132

What is dclgen in db2?

1149

What are types of indexes?

1074

Which component is responsible for db2 startup and shutdown?

1035

What is difference between rollback and commit?

1160

What are db2 tables?

1125

How does cobol compile db2 program?

1060

What is cursor in dbms?

1069