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

What is the difference between db2 and oracle?

0 Answers  


What is dclgen (declaration generator)?

0 Answers  


What is the difference between cursor and select statement?

0 Answers  


How does one remove entries from the SCT02 table?

1 Answers  


What is concurrency?

0 Answers  






Define declaration generator (dclgen).

0 Answers  


What is cloudant database?

0 Answers  


How Plan is created while executing the query using SPUFI?

3 Answers  


can you use symbolic parameters in JOB?

5 Answers   IBM,


What is consistency token in db2?

0 Answers  


What do you need to do before you do EXPLAIN ?

1 Answers  


What are types of indexes?

0 Answers  


Categories