Interested to Buy Any Domain ? << Click Here >> for more details...
Where is the access path logic created by the DB2 Optimizer
stored?
- 1 Answers
- 8368 Views
- I also Faced
- E-Mail Answers
Answer Posted / s
It is stored as bound plans/packages in the DSNDB01
directory in SKCT02, SKPT01 tablespaces.
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
What is dbrm library?
What is db2 bind process?
What is db2 and what is the use of db2 optimizer?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
How can we read records for specific member in CL? AND rpg?
Define sqlca.
What is bind package and plan in db2?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What db2 400?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
Explain what are the various isolation levels possible?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What kind of database is db2?
What is a bind card?
