- 博客(4)
- 收藏
- 关注
转载 查询计划中集的势(Cardinality)的计算
当使用CBO模 式的优化器时,oracle在生成查询计划时,会计算各个访问路径的代价,选择代价最小的访问路径 作为查询计划。这个选择过程我们可以通过做一个10053的trace来 观察。 ...
2010-05-04 13:06:24
95
转载 EXISTS, NOT EXISTS, IN, and NOT IN
Optimizing SQL usually gives the most significant results when DBAs are called upon to “make the system run fast...
2010-04-26 15:36:19
82
转载 Managing Optimizer Statistics Paper
Over the past couple days I’ve been reading through the recent paper by Karen Morton entitled “Managing Stat...
2010-04-26 15:33:27
79
转载 Null-Aware Anti-Join
[0006] A common type of query that is optimized is a query that contains a subquery whose join condition involv...
2010-04-26 15:27:39
101
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人