![]() |
|
EstimateExecutions что значит это ?? | ☑ | ||
---|---|---|---|---|
0
ig0z
06.03.15
✎
09:54
|
не помню что значит EstimateExecutions и найти не могу
|
|||
1
zak555
06.03.15
✎
09:56
|
ОценитьКазни
|
|||
2
ДенисЧ
06.03.15
✎
09:56
|
Контекст?
А так - "оценённое (навскидку) выполнение" |
|||
3
ig0z
06.03.15
✎
09:57
|
(1) да уже вылез из под стола с этого перевода
7.62E+005 как это понимать? почти 8? |
|||
4
ig0z
06.03.15
✎
09:57
|
+--------+----------+--------------+------------+-------------+------------+------------------+--------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Rows | Executes | EstimateRows | EstimateIO | EstimateCPU | AvgRowSize | TotalSubtreeCost | EstimateExecutions | StmtText | +--------+----------+--------------+------------+-------------+------------+------------------+--------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | 0 | 0 | 7.62E+005 | 0 | 0.0762 | 200 | 53.2 | 1 | |--Compute Scalar(DEFINE:([Expr1011]=CONVERT(numeric(26,8),[Expr1005],0), [Expr1012]=CONVERT(numeric(26,8),[Expr1006],0), [Expr1013]=CONVERT(numeric(27,8),[Expr1007],0), [Expr1014]=CONVERT(numeric(21,8),[Expr1008],0), [Expr1015]=CONVERT(numeric(21,8),[Expr1009],0), [Expr1016]=CONVERT(numeric(22,8),[Expr1010],0))) | | 593594 | 1 | 7.62E+005 | 0 | 4.38 | 224 | 53.1 | 1 | |--Parallelism(Gather Streams) | | 593594 | 8 | 7.62E+005 | 0 | 0.21 | 224 | 48.7 | 1 | |--Stream Aggregate(GROUP BY:([T1].[_Fld8558RRef], [T1].[_Fld8565RRef], [T1].[_Fld8559RRef], [T1].[_Fld8561RRef], [T1].[_Fld8563RRef], [T1].[_Fld8560RRef], [Expr1004], [T2].[_Code]) DEFINE:([Expr1005]=SUM([itrp_rab].[dbo].[_AccumRg8556].[_Fld8566] as [T1].[_Fld8566]), [Expr1006]=SUM([itrp_rab].[dbo].[_AccumRg8556].[_Fld8567] as [T1].[_Fld8567]), [Expr1007]=SUM([Expr1017]), [Expr1008]=SUM([Expr1018]), [Expr1009]=SUM([Expr1019]), [Expr1010]=SUM([Expr1020]))) | | 762359 | 8 | 7.62E+005 | 0.00282 | 17.1 | 188 | 48.5 | 1 | |--Sort(ORDER BY:([T1].[_Fld8558RRef] ASC, [T1].[_Fld8565RRef] ASC, [T1].[_Fld8559RRef] ASC, [T1].[_Fld8561RRef] ASC, [T1].[_Fld8563RRef] ASC, [T1].[_Fld8560RRef] ASC, [Expr1004] ASC, [T2].[_Code] ASC)) | | 762359 | 8 | 7.62E+005 | 0 | 3.73 | 188 | 31.4 | 1 | |--Parallelism(Repartition Streams, Hash Partitioning, PARTITION COLUMNS:([T1].[_Fld8558RRef], [T1].[_Fld8565RRef], [T1].[_Fld8559RRef], [T1].[_Fld8561RRef], [T1].[_Fld8563RRef], [T1].[_Fld8560RRef], [Expr1004], [T2].[_Code])) | | 762359 | 8 | 7.62E+005 | 0 | 2.31 | 188 | 27.7 | 1 | |--Hash Match(Right Outer Join, HASH:([T2].[_IDRRef])=([T1].[_Fld8560RRef]), RESIDUAL:([itrp_rab].[dbo].[_AccumRg8556].[_Fld8560RRef] as [T1].[_Fld8560RRef]=[itrp_rab].[dbo].[_Reference79].[_IDRRef] as [T2].[_IDRRef])) | | 6970 | 8 | 6.97E+003 | 0 | 0.0372 | 33 | 0.0601 | 1 | |--Parallelism(Repartition Streams, Hash Partitioning, PARTITION COLUMNS:([T2].[_IDRRef])) | | 6970 | 8 | 6.97E+003 | 0.0209 | 0.00196 | 33 | 0.0229 | 1 | | |--Index Scan(OBJECT:([itrp_rab].[dbo].[_Reference79].[_Referenc79_Code_SR] AS [T2])) | | 762359 | 8 | 7.62E+005 | 0 | 3.9 | 178 | 25.3 | 1 | |--Parallelism(Repartition Streams, Hash Partitioning, PARTITION COLUMNS:([T1].[_Fld8560RRef])) | | 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]. |
|||
5
ig0z
06.03.15
✎
09:58
|
блин, это не так
|
|||
6
Гёдза
06.03.15
✎
09:58
|
(3) 76 200
|
|||
7
xaozai
06.03.15
✎
09:58
|
The EstimateExecutions column is the estimated number of times the operator will execute during the query.
|
|||
8
elCust
06.03.15
✎
09:58
|
Это как в анекдоте: - Пап, а что такое аборт?
|
|||
9
ДенисЧ
06.03.15
✎
09:58
|
7.62E+005 = 762000
|
|||
10
mvk
06.03.15
✎
09:59
|
Оценочное время выполнения запроса
|
|||
11
ig0z
06.03.15
✎
10:00
|
всё спасибо нашёл))
|
Форум | Правила | Описание | Объявления | Секции | Поиск | Книга знаний | Вики-миста |