card是指计划中这一步所处理的行数;cost指cbo中这一步所耗费的资源,这个值是相对值;bytes指cbo中这一步所处理所有记录的字节数
首页 → 数据库技术
背景:
阅读新闻
Oracle 执行计划中一些参数的含义
[日期:2011-08-14]
来源:Linux社区
作者:nsj820
[字体:]
card是指计划中这一步所处理的行数;cost指cbo中这一步所耗费的资源,这个值是相对值;bytes指cbo中这一步所处理所有记录的字节数,是估算出来的一组值。
·Cost:The cost assigned to each step of the query plan by the CBO. The CBO worksby generating many different execution paths/plans for the same query andassigns a cost to each and every one. The query plan with the lowest cost wins.
·Card:Card is short for Cardinality. It is the estimated number of rows that will flow outof a given query plan step.
·Bytes:The size in bytes of the data the CBO expects each step of the plan t