Interested to Buy Any Domain ? << Click Here >> for more details...
what is Runstats? Whem will u choose to runatats?
- 1 Answers
- 13185 Views
- Danske, I also Faced
- E-Mail Answers
Answer Posted / s
RUNSTATS is run when there is heavy insert/update activity
that changes the characteristics of the data to a great
extent. Follow REORG with RUNSTATS. Usually after REORG to
record the organized data so that optimizer chooses a
better access path.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Discuss about db2 bind?
If I have a view which is a join of two or more tables, can this view be updateable?
define clustering index.
What is meant by union and union all?
What kind of database is db2?
How to resolve deadlock issue
Why do chiropractors use drop table?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What is the function of logging in the db2 database?
What is the maximum size of a char data type in db2?
What is check constraint. Explain with example.
How to retrieve rows from a db2 table in embedded sql?
How and when does the db2 enforces the unique key?
Explain db2.
Explain in detail about buffer manager and its functionalities?
