Statistics Collection
This is a discussion on Statistics Collection within the DB2 forums, part of the Database category; I want to collect statistics about the data values in tables to decide the access path for the optimizer. How ...
-
Statistics Collection
I want to collect statistics about the data values in tables to decide the access path for the optimizer. How can I do this. If there is any utility or command kindly mention the syntax for the same.
-
12-19-2006, 03:33 PM #2
- Join Date
- Apr 2006
- Answers
- 124
RUNSTATS is the DB2 utility that is used to collect statistics about the data values in tables which can be used by the optimizer to decide the access path.
Reply With QuoteConnect
Exforsys e-Newsletter
Enhance Technical and Soft Skills every week, get our Job Interview Questions and Answers eBook free when you subscribe.
Subscribe and Get Free Bonus PDF Book
