- BLEVEL = number of branch levels in index
- add +1 for leaf block
- FF = filtering factor - selectivity
- LFBL = number of leaf blocks
- CLUF = index clustering factor
- OIC = optimizer_index_caching(default 0)
- OICA = optimizer_index_cost_adj parameter(default=100)
Know more about CBO Index Cost
原创maclean_007 ©著作权
文章标签 cbo optimizer range scan cost Oracle索引index 文章分类 Oracle 数据库