What is RUNSTATS?

Answer Posted / s

RUNSTATS is a utility to collect statistics of the
tablespace that will be used by the optimizer to generate
best cost access paths.

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is alias in db2?

569


What are the different types of base tables?

585


What is the maximum size of varchar data type in db2?

645


What is dbrm? What it contains?

682


When the like statement is used?

640






How can you quickly find out the # of rows updated after an update statement?

632


Why do chiropractors use drop table?

661


How can you classify the locks in db2?

636


What's The Error Code For Unique Index Voilation?

651


Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

613


Which command is used to connect to a database in DB2 ? Give the Syntax.

602


How to find schema of a table in db2?

570


How can you count the number of rows from a table tab?

637


What kind of database is db2?

572


What is the difference between spufi and qmf?

639