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 are the prerogatives?

828

How to find schema of a table in db2?

783

Give a brief description of db2 isolation levels?

818

Explain how can you do the explain of a dynamic sql statement?

885

What is null indicator in cobol db2?

810

What are catalog tables in db2?

816

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3355

How and when does the db2 enforces the unique key?

877

What is db2 and what is the use of db2 optimizer?

860

Mention the way of highlighting as well as putting a cursor to use in a cobol program.

870

What is null value in db2?

786

What is the purpose of using commit?

862

Name the lockable units in DB2?

925

What is dbrm library?

818

is it compulsory commitment control in journal?

2252