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 the latest version of ibm db2?

1325

What is concurrency?

1295

Can we update view in db2?

1049

What is runstats utility in db2?

1066

What is deadlock in db2?

1114

List some fields from sqlca?

1098

what is utility for parm lib

2416

What is phantom read in db2?

1220

What is database reorganization?

1178

Comment whether the cursor is closed during commit or not.

1162

How can we retrieve the total number of records in RPG & CLLE?

705

Is db2 relational database?

1039

Is it possible using max on a char column?

1188

How to fetch the last row from the table in SQL (db2)?

1690

Explain about open switch business continuity software?

1180