Costs vs. Assistant

Which indicates that a request that has a low cost in terms of explanation but a high consistent counter is calculated in autotrace? In this case, the cost was 100, and CR was millions.

+3
source share
2 answers

The cost can represent two different things depending on the version and regardless of whether you work in the calculation mode based on the processor or not.

In short, cost is the amount of time that the optimizer expects to complete a query, but it is expressed in units of the amount of time it takes to read one block. For example, if Oracle expects one read block to take 1 ms and the request takes 20 ms, then the cost is 20.

: () (, ), , get , , . Oracle , , .

, , - " ". . : http://www.centrexcc.com/Tuning%20by%20Cardinality%20Feedback.ppt.pdf

+3

- -, . , , - , , , , .

, , , . .

, , , , , , , , , ( ROWS PLAN_TABLE , ). , , , CBO - , .

Oracle ?

+3

Source: https://habr.com/ru/post/1697778/


All Articles