Interested to Buy Any Domain ? << Click Here >> for more details...
What else is there in the PLAN apart from the access path?
- 1 Answers
- 5220 Views
- I also Faced
- E-Mail Answers
Answer / s
The Plan contains the executable SQL code(if DBRMs are
directly bound to the plan) with its access path as well as
the consistency token that will be checked against the
contoken in the load module at execution time.
| Is This Answer Correct ? | 3 Yes | 0 No |
What is package in db2 mainframe?
How can record locking be achieved in those DB2 versions which do not support it?
What is rct?
select distinct(empid),distinct(dept),name from EMP will the above query work?
How do you retrieve the first 5 characters of firstname column of db2 table emp?
How to check sequence on a table in db2?
Define db2 and its databases?
If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?
How many clustering indexes can be defined for a table?
what is a plan and how do you refer the plan in the program?
What is a PLAN table? How will you use it? Give the various fields of PLAN table?
What is the use of DELGEN in DB2? Can we Write the program with out using it?
COBOL 
