EstimateExecutions что значит это ?? #736084

не помню что значит EstimateExecutions и найти не могу

ОценитьКазни

Контекст? А так - "оценённое (навскидку) выполнение"

да уже вылез из под стола с этого перевода 7.62E+005 как это понимать? почти 8?

+--------+----------+--------------+------------+-------------+------------+------------------+--------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Rows   | Executes | EstimateRows | EstimateIO | EstimateCPU | AvgRowSize | TotalSubtreeCost | EstimateExecutions | StmtText                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | +--------+----------+--------------+------------+-------------+------------+------------------+--------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | 0      | 0        | 7.62E+005    | 0          | 0.0191      | 202        | 21.2             | 1                  |                                      |--Compute Scalar(DEFINE:([Expr1004]=dateadd(day,CONVERT_IMPLICIT(int,CONVERT(numeric(4,0),datepart(day,[itrp_rab].[dbo].[_AccumRg8556].[_Period] as [T1].[_Period]),0)-(1.),0),dateadd(month,CONVERT_IMPLICIT(int,CONVERT(numeric(4,0),datepart(month,[itrp_rab].[dbo].[_AccumRg8556].[_Period] as [T1].[_Period]),0)-(1.),0),dateadd(year,CONVERT_IMPLICIT(int,(CONVERT(numeric(4,0),datepart(year,[itrp_rab].[dbo].[_AccumRg8556].[_Period] as [T1].[_Period]),0)-(2000.))-(2000.),0),'4000-01-01 00:00:00.000'))), [Expr1017]=[itrp_rab].[dbo].[_AccumRg8556].[_Fld8566] as [T1].[_Fld8566]-[itrp_rab].[dbo].[_AccumRg8556].[_Fld8567] as [T1].[_Fld8567], [Expr1018]=CONVERT(numeric(15,8),[itrp_rab].[dbo].[_AccumRg8556].[_Fld10249] as [T1].[_Fld10249],0)/(60.0), [Expr1019]=CONVERT(numeric(15,8),[itrp_rab].[dbo].[_AccumRg8556].[_Fld10250] as [T1].[_Fld10250],0)/(60.0), [Expr1020]=CONVERT(numeric(15,8),[itrp_rab].[dbo].[_AccumRg8556].[_Fld10249] as [T1].[_Fld10249],0)/(60.0)-CONVERT(numeric(15,8),[itrp_rab].[dbo].

блин, это не так

76 200

The EstimateExecutions column is the estimated number of times the operator will execute during the query.

Это как в анекдоте: - Пап, а что такое аборт?

7.62E+005 = 762000

Оценочное время выполнения запроса

всё спасибо нашёл))