When will you chose to run RUNSTATS?

Answer Posted / deepak dada

is the utility which contains the statical info of the
table supply it to optimiser ane fron where it is used for
accessing the data base

Is This Answer Correct ?    4 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to find schema of a table in db2?

572


Mention data types used in db2 ?

679


How do I import data from excel to db2?

615


can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

1806


How to fetch the last row from the table in SQL (db2)?

1039






What is a db2 tablespace?

602


What is the connection string to connect to the DB2 Database ?

614


How to compare data between two tables in db2?

660


What is the use of db2 optimizer?

611


How and when does the db2 enforces the unique key?

615


What is dbrm? When it will be created?

600


Explain about rct.

654


What is declare cursor?

613


What is db2 purescale?

551


Explain what are the various isolation levels possible?

610