ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Oracle 执行计划中一些参数的含义

Oracle 执行计划中一些参数的含义

原创 Linux操作系统 作者:tolywang 时间:2007-08-18 00:00:00 0 删除 编辑

card是指计划中这一步所处理的行数。 cost指cbo中这一步所耗费的资源,这个值是相对值。 bytes指cbo中这一步所处理所有记录的字节数,是估算出来的一组值。


  • Cost: The cost assigned to each step of the query plan by the CBO. The CBO works by generating many different execution paths/plans for the same query and assigns a cost to each and every one. The query plan with the lowest cost wins. In the full outer join example, we can see the total cost for this query is 10.
  • Card: Card is short for Cardinality. It is the estimated number of rows that will flow out of a given query plan step. In the full outer join example, we can see the optimizer expects there to be 327 rows in EMP and 4 rows in DEPT.
  • Bytes: The size in bytes of the data the CBO expects each step of the plan to return. This is dependent on the number of rows (Card) and the estimated width of the rows.

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/35489/viewspace-84867/,如需转载,请注明出处,否则将追究法律责任。

下一篇: Oracle Latch & Lock
请登录后发表评论 登录
全部评论
Oracle , MySQL, SAP IQ, SAP HANA, PostgreSQL, Tableau 技术讨论,希望在这里一起分享知识,讨论技术,畅谈人生 。

注册时间:2007-12-10

  • 博文量
    5595
  • 访问量
    13129635