When will you chose to run RUNSTATS?
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 |
What are the levels of isolation available with DB2V4
What does a deadlock mean in DB2?
What is buffrpool? Where we use it ?
What is package in cobol db2?
Name some fields from SQLCA.
What are the 2 sqlcodes that are returned?
What is correlated subquery?
wht happens if we close cursor with cursor with hold option?
Suppose if I need to update a column, how you do that using cursor?
Why select is not preferred in embedded sql programs?
Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?
What is a result table?