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
Is schema the same as database?
Explain the function done by data manager?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
List out the three types of page locks that can be held.
What is check constraint. Explain with example.
How do I connect my db2 database to ibm?
Is db2 relational database?
What is data manager?
What r the comman abends in db2, jcl and cobol???????
What is reorg and runstats in db2?
What does db2 plan contain?
What is the use of db2 optimizer?
is it compulsory commitment control in journal?
what is a corelated subquerry?
