Statements involving larger tables and joins of two or more tables are more likely to exhibit a change in query access plan as a result of the improved cardinality estimate.
This helps Design Advisor to better estimate how much database performance would be improved by creating new indexes.
这能够帮助Design Advisor更好地估计创建新的索引能够对数据库性能有多大的改进。
3
The new algorithm is also used in parameter estimate, and the results of linear estimate and nonlinear estimate all show the effective of the improved algorithm.