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
How is the value function used?
Explain what are the various isolation levels possible?
can we view the access paths created by dbrm ? how ? thx
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
what is the sqlcode -501
What is view db2?
is it compulsory commitment control in journal?
What is a bind card?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What does reorg do in db2?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What is the difference between spufi and qmf?
What do you mean by between and in? Is between inclusive of specified range values?
Define data page.
