估计查询海岸的单位是多少？ [英] What is the unit of estimated query coast?

问题描述

估计查询海岸的单位是多少？如何减少？

What is the unit of estimated query coast? how to reduce?

推荐答案

截至目前，它是整体成本的无单位度量。在SQL Server 7天中，它最初是指在特定计算机上执行的秒数。这一切都在这里得到了很好的解释：

http://dba.stackexchange.com/questions/9982/how-do-i-read-query-cost-and-is-it-always-a-percentage [ ^ ]



只是这里提到的比例......比例~4：96注意这些费用缺乏单位：它们不是几秒钟，MB或其他任何东西。

http：// blogs.msdn.com/b/sqlqueryprocessing/archive/2006/10/11/what-is-this-cost.aspx [ ^ ]





谢谢。

As of now it is unitless measure of overall cost. In the SQL Server 7 days, it originally referred to the number of seconds taken to execute on a particular machine. This all is well explained in answer here:
http://dba.stackexchange.com/questions/9982/how-do-i-read-query-cost-and-is-it-always-a-percentage[^]

It is just a ratio as mentioned here "......ratio ~4:96. Notice the lack of units for these costs: they're not in seconds, MB or anything."
http://blogs.msdn.com/b/sqlqueryprocessing/archive/2006/10/11/what-is-this-cost.aspx[^]


Thanks.

这篇关于估计查询海岸的单位是多少？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！