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 role of union all and union
How do you select a row using indexes in db2?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What is bind in db2?
What is db2? Explain.
Explain various types of locks in db2?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What is a cursor in programming?
What kind of database is db2?
What is difference between alias and synonym in db2?
What is the role of schema in the db2 database?
What are db2 objects?
What is the result of open cursor statement?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What is runstats db2?