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 maximum size of varchar data type in db2?
When reorg is used?
How do I delete a table in db2?
What is db2 look?
How can you find out the # of rows updated after an update statement?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is a dbrm in db2?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
How to run db2 command in windows?
What is a cursor in programming?
What is a storage group (stogroup)?
What is meant by union and union all?
Is db2 a programming language?
Discuss about db2 bind?
What is the use of runstats in db2?