What is RUNSTATS?
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 |
wht happens if we close cursor with cursor with hold option?
What is explain plan in db2?
Which isolation level provides maximum concurrency?
What is a bind card?
What is the SQL Communications Area and what are some of its key fields?
How to know the primary key of a table without defining the primary key in the table?
How do I add a column to a table in db2?
when i am trying to update a table having 1000 rows. the program abends.how we will come to know the last successful updated row was. we are not using any commit operations
Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?
wht are the restrictions for union ?
What's the maximum number of characters that a tablename can have?
How to restart a DB2 program?