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
- 9481 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
How do I add a column to a table in db2?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
What's The Error Code For Unique Index Voilation?
What is the role of union all and union
Define buffer pool.
Who uses db2?
List down the data types in the db2 database.
What are foreign keys in db2?
What is lock escalation in db2?
What is collection in db2 bind?
How do you pull up a query which was previously saved in qmf?
Explain the contention situations caused by locks?
List some fields from sqlca?
What is the connection string to connect to the DB2 Database ?
What do you mean by cursor?
