Interested to Buy Any Domain ? << Click Here >> for more details...
What is RUNSTATS?
- 3 Answers
- 7806 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
Answer / kathir
this utility is giving information about the tablespace and
indexspace of statistics.
| Is This Answer Correct ? | 0 Yes | 0 No |
Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)
how to resolve -811 sqlcode .give clear explaination
how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none
Which transaction use a command thread ?
what is copy pending and check pending ?
What is the difference between a package and a plan?
6 Answers Infosys, L&T, Mphasis,
What do you need to do before you do EXPLAIN ?
How do I optimize a query in db2?
When DB2 connection fails, will online program work or give errors.
What is a dbrm in db2?
What is a PLAN table? How will you use it? Give the various fields of PLAN table?
What is query for your birthday date should be in hours,minute and seconds format?
COBOL 
