For what purpose would you copy statistics between databases?
A . So that stored outline execution plans can be modified in the source database.
B. To configure an accurate model of a production environment on a test system.
C . So that the data dictionaries between the two databases can be synchronized.
D . So that the data in the schema tables will be the same.
Explanation:
Answer B: Many times the statistics gathered in a test environment are not equivalent to those gathered in the production environment because data distribution and volume are not the same. By copying statistics from one environment to the next, you can get a more accurate performance analysis on SQL statements.
No comments:
Post a Comment