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 maximum size of a char data type in db2?

777

How can the duplicate values be eliminated from db2 select?

871

Explain dclgen.

943

What is a system catalog table in db2?

850

What is copy pending and check pending in db2?

758

What are the 2 sqlcodes that are returned?

876

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2678

Which command is used to connect to a database in DB2 ? Give the Syntax.

843

Is ibm db2 open source?

829

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

945

Define data page.

832

What db2 400?

908

What does db2 mean?

782

How to restart a DB2 program?

1600

When do you specify the isolation level?

799