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 sqlca’s maximum length?

1176

What is an instance in db2?

1031

What is declare cursor?

1110

What is the difference between db2 and oracle?

1125

What is db2 purescale?

993

What is consistency token in db2?

1134

How to rename a table in DB2 ?

1086

Define db2 and its databases?

1053

What are iseries servers?

1071

List out the three types of page locks that can be held.

1145

What are catalog tables in db2?

1044

On which levels locks can be applied?

1121

What is temporal table in db2?

1034

What do you mean by between and in? Is between inclusive of specified range values?

1088

what is the responsibility of the construction superintendent

2140