Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / avinash
It provide the summary information about the
characteristics of data available in table, indexes etc.
DB2 records these information into the CATLOG table and use
this information to decide on the access path to data
during the bind process. To obtain the statistics you can
query the catalog table.
| Is This Answer Correct ? | 8 Yes | 4 No |
Post New Answer View All Answers
What is the usage of open cursor command?
What is the difference between cursor and select statement?
How to resolve deadlock issue
Why do we bind in db2?
Where do you specify them?
What is performance tuning db2?
What are the various isolation levels possible?
What is the purpose of rollback and commit?
What are the uses of db2 optimizer?
Mention the different locking levels that are available in db2.
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
Where can you declare a cursor in a cobol-db2 program?
What are the benefits of using the db2 database?
List out the buffer pools in db2
What is table space in db2?
