Interested to Buy Any Domain ? << Click Here >> for more details...
What is a PLAN table? How will you use it? Give the various
fields of PLAN table?
- 1 Answers
- 4343 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / sneha
Plan is an access path for your program to access the DB2 table. During precompilation process, the SQL queries are converted into executable statements and stored in DBRM (Database Request Module). This DBRM will have a consistency token. During the bind step, this DBRM will be read and a plan will be produced. Few important parameters we include in Bind job is ISOLATION LEVEL ( how one transaction needs to be separated from another transaction which does some data modification on the table), QUALIFIER etc.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Is db2 relational database?
Why do chiropractors use drop table?
How to check last update on table in db2?
What is the difference between nvl and coalesce?
Explain about mirror activator disk mirroring?
Explain how can you do the explain of a dynamic sql statement?
List some fields from sqlca?
What is null value in db2?
define clustering index.
Which is faster delete or truncate?
How do I import a csv file into db2?
What are the various data types available in db2?
How is deadlock resolved?
What is the function of logging in the db2 database?
How do I create a view in db2?
