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
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What is meant by union and union all?
What is isolation level in db2?
What is null in db2?
What is bind package and plan in db2?
Why select is not preferred in embedded sql programs?
What is cursor stability in db2?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What do you mean by commit and rollback?
Is db2 relational database?
What is a storage group (stogroup)?
List out the three types of page locks that can be held.
Which are the db2 tools to protect integrity of the database?
Give a brief description of db2 isolation levels?
Define buffer pool.
