It is impractical to give strict guidelines on gathering optimizer statistics that cover all situations. This is because there are too many factors to consider. This section considers a number of example environments and how wgn_stats might be used in each.
In practice, the best approach is to choose the scenario that best matches your environment, measure how long the statistics gathering takes, and consider how frequently to execute this based on your business needs and the impact the gathering may have on other operations.
This section contains the following topics:
|
Copyright © 2014 CA.
All rights reserved.
|
|