CBO
lemontree1123
这个作者很懒,什么都没留下…
展开
-
CBO估计执行计划需要参考的三项
Estimator The estimator determines the overall cost of a given execution plan. The estimator generates three different types of measures to achieve this goal: Selectivity This measure represe原创 2015-05-06 14:29:09 · 763 阅读 · 0 评论 -
What causes Cardinality to be wrong?
What causes Cardinality to be wrong? 1>Data Skews 2>Multiple single column predicates on a table --->>>解决方案为收集扩展统计信息 3>A function wrapped where clause predicate 4>No statistics or Stale St翻译 2015-08-03 20:14:33 · 600 阅读 · 0 评论