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 difference between plan and package in db2?
How to create db2 table in mainframe?
What is a cursor in programming?
What type of database is db2?
What are union and union all?
What are db2 tables?
What is dbrm? What it contains? When it will be created?
What is cobol db2?
Is it possible using max on a char column?
What is null indicator in db2?
What is syscat in db2?
What is the physical storage length of time data type?
Is db2 a database?
What is difference between alias and synonym in db2?
What does db2 blu stand for?