CBO
lemontree1123
这个作者很懒,什么都没留下…
展开
专栏收录文章
- 默认排序
- 最新发布
- 最早发布
- 最多阅读
- 最少阅读
-
CBO估计执行计划需要参考的三项
EstimatorThe estimator determines the overall cost of a given execution plan. The estimator generates three different types of measures to achieve this goal:SelectivityThis measure represe原创 2015-05-06 14:29:09 · 828 阅读 · 0 评论 -
What causes Cardinality to be wrong?
What causes Cardinality to be wrong?1>Data Skews2>Multiple single column predicates on a table --->>>解决方案为收集扩展统计信息3>A function wrapped where clause predicate4>No statistics or Stale St翻译 2015-08-03 20:14:33 · 697 阅读 · 0 评论
分享