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
What is the use of runstats in db2?
How is the value function used?
How do you concatenate the firstname and lastname from emp table to give a complete name?
What is universal database?
What does runstats do in db2?
What is explain plan in db2?
What is concurrency?
Define db2.
What is the usage of open cursor command?
How do I import data from excel to db2?
What is view db2?
What is null indicator in cobol db2?
What do you mean by between and in? Is between inclusive of specified range values?
How do you eliminate duplicate values in db2?
How do I copy a table in db2?