what is Runstats? Whem will u choose to runatats?
Answer / 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 |
How can you display the current date & current time ?
How to execute stored procedure in db2 command editor?
Mention the definition of cobol in varchar field.
What is cursor stability?
What are column-name qualifiers used?
is it possible to get -811 error when you use cursors. why?
how to copy the host variables from ps file into cobol program other than include statement
What is a db2 collection?
What does reorg do in db2?
what is commit & rollback? When and where is used while compiling a cobol-db2 program?
What is a DB2 bind?
Why do chiropractors use drop table?