What is RUNSTATS?

Answers were Sorted based on User's Feedback



What is RUNSTATS?..

Answer / 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

What is RUNSTATS?..

Answer / srinivasa yadav

RUNSTATS:- RUNSTATS IS A UTILITY
IT IS GET THE LATEST INFORMATION OF TABLESPACE,
INDEX AND e.t.c

Is This Answer Correct ?    1 Yes 0 No

What is RUNSTATS?..

Answer / kathir

this utility is giving information about the tablespace and
indexspace of statistics.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB2 Interview Questions

How does cobol compile db2 program?

0 Answers  


Explain about rct in db2?

0 Answers  


What is table space in db2?

0 Answers  


What is the difference between cursor and select statement?

0 Answers  


What is lock contention?

1 Answers  






How to resolve -805 error in DB2?

1 Answers   Cap Gemini,


How does DB2 store NULL physically?

2 Answers  


Can a array declared with an index be displayed(readable format) in spool?

4 Answers   Syntel, UST,


When will you chose to run RUNSTATS?

1 Answers  


how can i pull up a query which was previously stored in qmf

3 Answers  


What is a precompiler?

2 Answers  


what is the maximum number of tables that can be joined ?

8 Answers   IBM, TCS,


Categories