CBO
czmmiao
这个作者很懒,什么都没留下…
展开
-
The CBO and Indexes: An Introduction (Absolute Beginners)
One of the more common questions I get asked and one of the most common questions asked in the various Oracle related forums is the general question of why doesn’t the CBO choose to use a particular...原创 2014-06-27 17:27:43 · 131 阅读 · 0 评论 -
The Query Optimizer
The Query OptimizerThis chapter discusses SQL processing, optimization methods, and how the query optimizer (usually called the optimizer) chooses a specific plan to execute SQL.The chapter cont...原创 2014-06-30 07:32:45 · 369 阅读 · 0 评论 -
double trouble
double troubleFiled under: Execution plans,Performance,Tuning — Jonathan Lewis @ 7:06 pm BST May 18,2010 In the latest Quiz Night, I asked how you could make a query more efficient by changin...原创 2014-06-30 07:32:18 · 199 阅读 · 0 评论 -
The CPU Costing Model: A Few Thoughts Part V (Reality)
There’s plenty more I could talk about regarding the CBO CPU costing model and system statistics but I’ll make this my final little comment on this subject for now. As previously discussed, the CPU ...原创 2014-06-29 10:45:52 · 127 阅读 · 0 评论 -
OPTIMIZER_INDEX_CACHING Parameter
As previously discussed, the CBO assumes the actual costs and overheads associated with all I/Os to be the same, regardless of the type of I/O, unless told otherwise via the optimizer_index_cost_adj...原创 2014-06-29 10:45:22 · 228 阅读 · 0 评论 -
The CBO CPU Costing Model: Indexes vs. Full Table Scans
As previously promised, I thought I might look at how the CBO goes about costing a Full Table Scan (FTS) with system statistics and the CPU costing model, so we can understand why the CBO may have ch...原创 2014-06-28 09:50:52 · 142 阅读 · 0 评论 -
The CPU Costing Model – A Few Thoughts Part II
As previously discussed, the formula used by the CBO using the CPU costing model is basically: (sum of all the single block I/Os x average wait time for a single block I/O + sum of all the multiblock...原创 2014-06-28 09:47:52 · 105 阅读 · 0 评论 -
The CPU Costing Model: A Few Thoughts Part I
In the coming days, I’ll post a series of little entries highlighting a specific point in relation to the use of system statistics and the CPU cost model. In myprevious post, we looked at how the cos...原创 2014-06-28 09:46:53 · 165 阅读 · 0 评论 -
The CBO CPU Costing Model and Indexes – Another Introduction
I’ve previously discussed some basic concepts and formulas regarding how the CBO derives index related costings via the I/O costing model. Time to look at system statistics and the CPU costing model ...原创 2014-06-28 09:44:48 · 120 阅读 · 0 评论 -
The CBO and Indexes: OPTIMIZER_INDEX_COST_ADJ Part III
After a bit of a layoff to organise a few upcoming overseas trips, while watching plenty of Ashes Cricket and the brilliantly funny “Flight Of The Conchords” DVDs, it’s about time I got back to my hu...原创 2014-06-28 07:44:59 · 104 阅读 · 0 评论 -
The CBO and Indexes: OPTIMIZER_INDEX_COST_ADJ Part III
After a bit of a layoff to organise a few upcoming overseas trips, while watching plenty of Ashes Cricket and the brilliantly funny “Flight Of The Conchords” DVDs, it’s about time I got back to my hu...原创 2014-06-27 22:43:46 · 102 阅读 · 0 评论 -
The CBO and Indexes: OPTIMIZER_INDEX_COST_ADJ Part II
In OPTIMIZER_INDEX_COST_ADJ Part I, I discussed how this parameter can significantly impact the overall cost of an index related execution path by “adjusting” the overall costs by the percentage den...原创 2014-06-27 22:42:41 · 132 阅读 · 0 评论 -
The CBO and Indexes: OPTIMIZER_INDEX_COST_ADJ Part I
In the previous entry regarding The CBO and Indexes, we saw how the CBO with a query that selected 5 distinct values in an IN list, representing 5% of the data, decided to use a FTS because the costs...原创 2014-06-27 22:41:18 · 99 阅读 · 0 评论 -
The CBO and Indexes: Introduction Continues …
OK, I previously briefly covered how the CBO calculates the basic cost of an index range scan. Yes, those cardinality/rows values in the execution plans are vitally important as they highlight whethe...原创 2014-06-27 22:40:19 · 152 阅读 · 0 评论 -
The CPU Costing Model: A Few Thoughts Part IV (Map of the Problematique)
It’s called the CPU Costing model because among other things, it includes the time associated with performing CPU operations. The CPU Costing model formula once again: (sum of all the single block I...原创 2014-06-30 07:32:47 · 149 阅读 · 0 评论