45IT.COM- 电脑学习从此开始!
DIY硬件教程攒机经验装机配置
设计Photoshop网页设计特效
系统注册表DOS系统命令其它
存储主板显卡外设键鼠内存
维修显卡CPU内存打印机
WinXPVistaWin7unix/linux
CPU光驱电源/散热显示器其它
修技主板硬盘键鼠显示器光驱
办公ExcelWordPowerPointWPS
编程数据库CSS脚本PHP
网络局域网QQ服务器
软件网络系统图像安全
页面导航: 首页 > 设计学院 > 网络编程 > 数据库 >

掌握card的标准含义

电脑软硬件应用网 45IT.COM 时间:2007-11-29 12:26 作者:72933

一直以来,很多人都对card的具体含义一头雾水,参考下文你就会很快得到card的标准含义。

⑴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 j
oin 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.

至此,我们就可以得出最标准的结论:

card是指计划中这一步所处理的行数。

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

顶一下
(0)
0%
踩一下
(0)
0%
------分隔线----------------------------
无法在这个位置找到: baidushare.htm
发表评论
请自觉遵守互联网相关的政策法规,严禁发布色情、暴力、反动的言论。
评价:
表情:
验证码:点击我更换图片
推荐知识