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 db2 and what is the use of db2 optimizer?
How is a typical db2 batch pgm executed?
Define db2 and its databases?
Explain db2.
Why select is not preferred in embedded sql programs?
what are bind concepts in db2 cobol?
Comment whether the cursor is closed during commit or not.
Define check constraint.
What are db2 tables?
How to execute stored procedure in db2 command editor?
What is the syntax for seeing the columns and data types of a table in the db2 database?
Give the name of some fields form sqlca.
How can we read records for specific member in CL? AND rpg?
How can you count the number of rows from a table tab?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?