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
- 9251 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
What is meant by explain?
Which component is responsible for processing sql statements and selecting access paths?
What is a storage group (stogroup)?
How do I start db2 in windows?
What is view db2?
How to test SQL -911 error while developing COB-DB2 program
Explain about cursor stability?
What is buffer pool and list some of them?
What is the role of schema in the db2 database?
What is ibm db2 database?
What is the use of commit in db2?
What is with ur in db2?
What is null indicator in db2?
What is ibm db2 client?
What is copy pending and check pending in db2?
