what is Runstats? Whem will u choose to runatats?
Answer Posted / s
RUNSTATS is run when there is heavy insert/update activity
that changes the characteristics of the data to a great
extent. Follow REORG with RUNSTATS. Usually after REORG to
record the organized data so that optimizer chooses a
better access path.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How to view db2 table structure?
List out the buffer pools in db2
What are the contents of dclgen?
What are iseries servers?
What is null in db2?
What is sqlca’s maximum length?
What is the role of the data page in the db2 database?
What is db2 plan table?
How many databases can be created inside an instance in db2 ?
Why db2 is called db2?
What is null indicator in cobol db2?
What db2 400?
What is the role of union all and union
Mention the definition of cobol in varchar field.
What kind of database is db2?