Interested to Buy Any Domain ? << Click Here >> for more details...
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
can we view the access paths created by dbrm ? how ? thx
What is the difference between oracle and db2?
Comment whether the cursor is closed during commit or not.
What are host variables in db2?
Explain the function done by data manager?
What is page size in db2?
Define check constraint.
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
How do you select a row using indexes in db2?
How do I add a column to a table in db2?
Explain correlated sub-queries.
What is load utility in db2?
Which is faster delete or truncate?
What kind of database is db2?
What is the picture clause of null indicator variable?
