Interested to Buy Any Domain ? << Click Here >> for more details...
Where is the access path logic created by the DB2 Optimizer
stored?
- 1 Answers
- 8446 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
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
How to restart a DB2 program?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
B37 abend during spufi?
Is db2 a database?
Explain the function of data manager.
How is deadlock resolved?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
How do you concatenate the firstname and lastname from emp table to give a complete name?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
How do you pull up a query which was previously saved in qmf?
How to compare data between two tables in db2?
Is ibm db2 free?
What is the use of value function?
What is the difference between cursor stability and repeatable read isolation levels?
