Answer Posted / s
RUNSTATS does not reclaim space nor orders records, its the
REORG utility that will reorganize the data records.
RUNSTATS collects statistics about the data in the table
like, cardinality statistics, frequency statistics that
will be used by the optimizer to determine a good access
path.
| Is This Answer Correct ? | 30 Yes | 3 No |
Post New Answer View All Answers
What are foreign keys in db2?
What is the difference between drop table and delete table?
What is db2? Explain.
Why cursor is used in db2?
What is the role of the data page in the db2 database?
How do I start db2 in windows?
Explain various types of locks in db2?
What is the use of value function?
B37 abend during spufi?
When do you specify the isolation level?
what are bind concepts in db2 cobol?
What is db2 command?
What is a buffer in memory?
What is the default page size of buffer pools?
How does db2 sample database connect?