When will you chose to run RUNSTATS?
- 1 Answers
- 9552 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
Is it possible to update a primary key value? If not, what is the error code given? If yes, can more than 1 primary key column be updated at a time?
How to insert more than one record using insert?
Mention the definition of cobol in varchar field.
How many buffer pools are available in db2?
What is DCLGEN?
What is query for your birthday date should be in hours,minute and seconds format?
Which components manage deadlocks in db2?
Which is faster delete or truncate?
How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?
What is phantom read in db2?
What is the maximum length of sqlca?
When do you specify the isolation level? How?
COBOL 
