Statistics does not reflect execution plan
Hi everyone,
Oracle database server 11.2.0.3 using ASM (grid 11.2.0.3)
The ORDER table has 17Millions records in it. If you look at the explain plan obtained in autotrace mode, and if my understanding of the cost is correct, it does not match the 4 consistent gets in the statistics. If I search in v$sql_plan I find the exact same plan. What is wrong in my interpretation?
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
optimizer_index_cost_adj integer 100
db_file_multiblock_read_count integer 128
var b1 VARCHAR2(4000)
var b2 NUMBER
var b3 NUMBER
var b4 NUMBER
var b5 NUMBER
var b6 VARCHAR2(2000)