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

What is null value in db2?

563


How to execute stored procedures?

620


What is the maximum number of columns in a db2 table?

723


Explain in detail about buffer manager and its functionalities?

564


What is drop table?

583






What is dbrm?

637


What is the difference between db2 and oracle?

673


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

612


What are the contents of a dclmgen?

628


Can we insert update delete in view?

573


What are types of indexes?

593


What are the rules for db2 programming?

641


What is host variable in db2 cobol?

602


What is dbrm in db2 database?

586


What is query_cache_limit?

541