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

If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

694

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

575

What is db2? Explain.

593

Which component is responsible for db2 startup and shutdown?

617

What is coalesce in db2?

674

What is the result of open cursor statement?

627

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

4166

What is the physical storage length of date data type?

718

What is a db2 collection?

599

What is db2?

735

What is commit in db2?

587

What is the use of with ur in db2?

608

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

1667

How do I import a csv file into db2?

553

What is the difference between using bind () and rebind () methods of naming class?

779