Interested to Buy Any Domain ? << Click Here >> for more details...
What is the specific need of Plan and..where are the tables
in DB2 are physically saved
- 3 Answers
- 9297 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / amit
plan is nothing but executable form of sql statements and
formed by one or more dbrms, it is used for run the program,
without plan it will not run.
physically tables are stored in table space of data base.
but the information of table is tabulated in system
table 'sysibm.systable'
correct me if i am wrong
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
Mention the location where the output received from explain statement is stored.
What is a db2 cursor?
What is data manager?
Can we update view in db2?
What is db2 catalog database?
What is cursor stability in db2?
What is difference between rollback and commit?
What is the clustering index in the db2 database?
How do I copy a table in db2?
Is ibm db2 free?
What is a db2 package?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
How many databases can be created inside an instance in db2 ?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What is rebind in db2?
