What is the specific need of Plan and..where are the tables
in DB2 are physically saved
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 query_cache_limit?
How do I create a view in db2?
What is rct?
What is meant by explain?
What are the different types of base tables?
Why select is not preferred in embedded sql programs?
How would you find out the total number of rows in a db2 table?
How do I import data from excel to db2?
What is the use of commit in db2?
What is the maximum length of sqlca?
How does a cursor work?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
How can you quickly find out the # of rows updated after an update statement?
What is check constraint in db2?
What is bind in db2?