Plan is an executable form of sql statements,But what
exactly resides inside a Plan. what are the details inside
Plan.
Answer Posted / vaibhav
Plan contains DBRM(machine level SQL statements) and
Optimized Access Path.
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
How can we read records for specific member in CL? AND rpg?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
Explain about mirror activator disk mirroring?
What is the purpose of rollback and commit?
Which component is responsible for processing sql statements and selecting access paths?
How and when does the db2 enforces the unique key?
What is the result of open cursor statement?
How will you return the number of records in table?
What is coalesce in db2?
What is iseries database?
What is a db2 collection?
What types of tables are there in the db2 database?
How do I add a column to an existing table in db2?
What is db2 bind process?
Mention data types used in db2 ?