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
How to get the ddl of a table in db2?
How do I create a view in db2?
Which component is responsible for db2 startup and shutdown?
Explain about rct.
What is declare cursor?
Is schema the same as database?
What is bind in db2?
Is db2 a mainframe database?
What's The Percentage Free Space ?
Is db2 relational database?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
How does cobol compile db2 program?
What is a storage group (stogroup)?
define clustering index.
What are host variables in db2?