{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["Feuil1","Feuil2","Feuil3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Feuil1","index":0,"n_rows":49,"n_cols":18,"rows_kept":49,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["StmtText","StmtId","NodeId","Parent","PhysicalOp","LogicalOp","Argument","DefinedValues","EstimateRows","EstimateIO","EstimateCPU","AvgRowSize","TotalSubtreeCost","OutputList","Warnings","Type","Parallel","EstimateExecutions"]
["Select * FROM  BDD.dbo.v_AlarmEventHistoryInternal2     WHERE (Area like '#M11202%') --Ajout DB AreaSas     AND EventStamp > '20160324 10:50:00.000'     AND EventStamp < '20160325 00:05:00.000'     AND Priority = 100",1,1,0,"NULL","NULL",1,"NULL",348.4533,"NULL","NULL","NULL",6.146381,"NULL","NULL","SELECT",0,"NULL"]
["  |--Concatenation",1,2,1,"Concatenation","Concatenation","NULL","[Union1078] = ([Union1042], [BDD].[dbo].[Events].[EventStamp]), [Union1079] = ([Union1043], [Expr1072]), [Union1080] = ([Union1044], [BDD].[dbo].[Events].[TagName]), [Union1081] = ([Union1045], [Expr1073]), [Union1082] = ([Union1046], [BDD].[dbo].[Events].[GroupName]), [Union1083] = ([Union1047], [Expr1074]), [Union1084] = ([Union1048], [BDD].[dbo].[Events].[ValueString]), [Union1085] = ([Union1049], [BDD].[dbo].[Events].[LimitString]), [Union1086] = ([Union1050], [BDD].[dbo].[Events].[EventPriority]), [Union1087] = ([Union1051], [Expr1075]), [Union1088] = ([Union1052], [Expr1076]), [Union1089] = ([Union1053], [BDD].[dbo].[Events].[OperatorName]), [Union1090] = ([Union1054], [BDD].[dbo].[OperatorDetails].[UserDomainName]), [Union1091] = ([Union1055], [BDD].[dbo].[OperatorDetails].[UserFullName]), [Union1092] = ([Union1056], [Expr1077]), [Union1093] = ([Union1057], [BDD].[dbo].[Events].[User1]), [Union1094] = ([Union1058], [BDD].[dbo].[Events].[User2]), [Union1095] = ([Union1059], [BDD].[dbo].[Events].[User3]), [Union1096] = ([Union1060], [BDD].[dbo].[Events].[EventTime]), [Union1097] = ([Union1061], [BDD].[dbo].[Events].[EventTimeFracSec]), [Union1098] = ([Union1062], [BDD].[dbo].[Events].[OperatorNode])",348.4533,0,3.484533e-05,5550,6.146381,"[Union1078], [Union1079], [Union1080], [Union1081], [Union1082], [Union1083], [Union1084], [Union1085], [Union1086], [Union1087], [Union1088], [Union1089], [Union1090], [Union1091], [Union1092], [Union1093], [Union1094], [Union1095], [Union1096], [Union1097], [Union1098]","NULL","PLAN_ROW",0,1]
["       |--Stream Aggregate(GROUP BY:([Union1042], [Union1043], [Union1044], [Union1045], [Union1046], [Union1047], [Union1048], [Union1049], [Union1050], [Union1051], [Union1052], [Union1053], [Union1054], [Union1055], [Union1056], [Union1057], [Union1058], [Union1059], [Union1060], [Union1061], [Union1062]))",1,3,2,"Stream Aggregate","Aggregate","GROUP BY:([Union1042], [Union1043], [Union1044], [Union1045], [Union1046], [Union1047], [Union1048], [Union1049], [Union1050], [Union1051], [Union1052], [Union1053], [Union1054], [Union1055], [Union1056], [Union1057], [Union1058], [Union1059], [Union1060], [Union1061], [Union1062])","NULL",347.4533,0,0.0003474533,5547,6.136487,"[Union1042], [Union1043], [Union1044], [Union1045], [Union1046], [Union1047], [Union1048], [Union1049], [Union1050], [Union1051], [Union1052], [Union1053], [Union1054], [Union1055], [Union1056], [Union1057], [Union1058], [Union1059], [Union1060], [Union1061], [Union1062]","NULL","PLAN_ROW",0,1]
["       |    |--Sort(ORDER BY:([Union1042] ASC, [Union1043] ASC, [Union1044] ASC, [Union1045] ASC, [Union1046] ASC, [Union1047] ASC, [Union1048] ASC, [Union1049] ASC, [Union1051] ASC, [Union1052] ASC, [Union1053] ASC, [Union1054] ASC, [Union1055] ASC, [Union1056] ASC, [Union1057] ASC, [Union1058] ASC, [Union1059] ASC, [Union1060] ASC, [Union1061] ASC, [Union1062] ASC))",1,4,3,"Sort","Sort","ORDER BY:([Union1042] ASC, [Union1043] ASC, [Union1044] ASC, [Union1045] ASC, [Union1046] ASC, [Union1047] ASC, [Union1048] ASC, [Union1049] ASC, [Union1051] ASC, [Union1052] ASC, [Union1053] ASC, [Union1054] ASC, [Union1055] ASC, [Union1056] ASC, [Union1057] ASC, [Union1058] ASC, [Union1059] ASC, [Union1060] ASC, [Union1061] ASC, [Union1062] ASC)","NULL",347.4533,0.01126126,0.004680622,5547,6.136139,"[Union1042], [Union1043], [Union1044], [Union1045], [Union1046], [Union1047], [Union1048], [Union1049], [Union1050], [Union1051], [Union1052], [Union1053], [Union1054], [Union1055], [Union1056], [Union1057], [Union1058], [Union1059], [Union1060], [Union1061], [Union1062]","NULL","PLAN_ROW",0,1]
["       |         |--Concatenation",1,5,4,"Concatenation","Concatenation","NULL","[Union1042] = ([AlmDetailTbl].[EventStamp], [AlmDetailTbl].[EventStamp]), [Union1043] = ([Expr1014], [Expr1035]), [Union1044] = ([Expr1015], [Expr1036]), [Union1045] = ([BDD].[dbo].[Comment].[Comment], [BDD].[dbo].[Comment].[Comment]), [Union1046] = ([Expr1016], [Expr1037]), [Union1047] = ([Expr1017], [Expr1038]), [Union1048] = ([AlmDetailTbl].[ValueString], [AlmDetailTbl].[ValueString]), [Union1049] = ([AlmDetailTbl].[LimitString], [AlmDetailTbl].[LimitString]), [Union1050] = ([AlmDetailTbl].[Priority], [AlmDetailTbl].[Priority]), [Union1051] = ([Expr1018], [Expr1039]), [Union1052] = ([Expr1019], [Expr1040]), [Union1053] = ([AlmDetailTbl].[OperatorName], [AlmDetailTbl].[OperatorName]), [Union1054] = ([BDD].[dbo].[OperatorDetails].[UserDomainName], [BDD].[dbo].[OperatorDetails].[UserDomainName]), [Union1055] = ([BDD].[dbo].[OperatorDetails].[UserFullName], [BDD].[dbo].[OperatorDetails].[UserFullName]), [Union1056] = ([Expr1020], [Expr1041]), [Union1057] = ([AlmDetailTbl].[User1], [AlmDetailTbl].[User1]), [Union1058] = ([AlmDetailTbl].[User2], [AlmDetailTbl].[User2]), [Union1059] = ([AlmDetailTbl].[User3], [AlmDetailTbl].[User3]), [Union1060] = ([AlmDetailTbl].[TransitionTime], [AlmDetailTbl].[TransitionTime]), [Union1061] = ([AlmDetailTbl].[TransitionTimeFracSec], [AlmDetailTbl].[TransitionTimeFracSec]), [Union1062] = ([AlmDetailTbl].[OperatorNode], [AlmDetailTbl].[OperatorNode])",347.4533,0,3.474533e-05,5547,6.120197,"[Union1042], [Union1043], [Union1044], [Union1045], [Union1046], [Union1047], [Union1048], [Union1049], [Union1050], [Union1051], [Union1052], [Union1053], [Union1054], [Union1055], [Union1056], [Union1057], [Union1058], [Union1059], [Union1060], [Union1061], [Union1062]","NULL","PLAN_ROW",0,1]
["       |              |--Compute Scalar(DEFINE:([Expr1020]=replicate('0',(17)-datalength(CONVERT(varchar(17),datediff(millisecond,[BDD].[dbo].[AlarmMaster].[OriginationTime],[BDD].[dbo].[AlarmDetail].[TransitionTime] as [AlmDetailTbl].[TransitionTime]),0)))+CONVERT(varchar(17),datediff(millisecond,[BDD].[dbo].[AlarmMaster].[OriginationTime],[BDD].[dbo].[AlarmDetail].[TransitionTime] as [AlmDetailTbl].[TransitionTime]),0)))",1,6,5,"Compute Scalar","Compute Scalar","DEFINE:([Expr1020]=replicate('0',(17)-datalength(CONVERT(varchar(17),datediff(millisecond,[BDD].[dbo].[AlarmMaster].[OriginationTime],[BDD].[dbo].[AlarmDetail].[TransitionTime] as [AlmDetailTbl].[TransitionTime]),0)))+CONVERT(varchar(17),datediff(millisecond,[BDD].[dbo].[AlarmMaster].[OriginationTime],[BDD].[dbo].[AlarmDetail].[TransitionTime] as [AlmDetailTbl].[TransitionTime]),0))","[Expr1020]=replicate('0',(17)-datalength(CONVERT(varchar(17),datediff(millisecond,[BDD].[dbo].[AlarmMaster].[OriginationTime],[BDD].[dbo].[AlarmDetail].[TransitionTime] as [AlmDetailTbl].[TransitionTime]),0)))+CONVERT(varchar(17),datediff(millisecond,[BDD].[dbo].[AlarmMaster].[OriginationTime],[BDD].[dbo].[AlarmDetail].[TransitionTime] as [AlmDetailTbl].[TransitionTime]),0)",146.5499,0,1.465499e-05,4534,2.902472,"[AlmDetailTbl].[OperatorName], [AlmDetailTbl].[OperatorNode], [AlmDetailTbl].[Priority], [AlmDetailTbl].[LimitString], [AlmDetailTbl].[ValueString], [AlmDetailTbl].[TransitionTime], [AlmDetailTbl].[TransitionTimeFracSec], [AlmDetailTbl].[User1], [AlmDetailTbl].[User2], [AlmDetailTbl].[User3], [AlmDetailTbl].[EventStamp], [BDD].[dbo].[Comment].[Comment], [BDD].[dbo].[OperatorDetails].[UserDomainName], [BDD].[dbo].[OperatorDetails].[UserFullName], [Expr1014], [Expr1015], [Expr1016], [Expr1017], [Expr1018], [Expr1019], [Expr1020]","NULL","PLAN_ROW",0,1]
["       |              |    |--Merge Join(Right Outer Join, MERGE:([BDD].[dbo].[OperatorDetails].[OperatorID])=([AlmDetailTbl].[OperatorID]), RESIDUAL:([BDD].[dbo].[AlarmDetail].[OperatorID] as [AlmDetailTbl].[OperatorID]=[BDD].[dbo].[OperatorDetails].[OperatorID]))",1,7,6,"Merge Join","Right Outer Join","MERGE:([BDD].[dbo].[OperatorDetails].[OperatorID])=([AlmDetailTbl].[OperatorID]), RESIDUAL:([BDD].[dbo].[AlarmDetail].[OperatorID] as [AlmDetailTbl].[OperatorID]=[BDD].[dbo].[OperatorDetails].[OperatorID])","NULL",146.5499,0,0.00613661,540,2.902457,"[BDD].[dbo].[AlarmMaster].[OriginationTime], [AlmDetailTbl].[OperatorName], [AlmDetailTbl].[OperatorNode], [AlmDetailTbl].[Priority], [AlmDetailTbl].[LimitString], [AlmDetailTbl].[ValueString], [AlmDetailTbl].[TransitionTime], [AlmDetailTbl].[TransitionTimeFracSec], [AlmDetailTbl].[User1], [AlmDetailTbl].[User2], [AlmDetailTbl].[User3], [AlmDetailTbl].[EventStamp], [BDD].[dbo].[Comment].[Comment], [BDD].[dbo].[OperatorDetails].[UserDomainName], [BDD].[dbo].[OperatorDetails].[UserFullName], [Expr1014], [Expr1015], [Expr1016], [Expr1017], [Expr1018], [Expr1019]","NULL","PLAN_ROW",0,1]
["       |              |         |--Clustered Index Scan(OBJECT:([BDD].[dbo].[OperatorDetails].[p_OperatorID]), ORDERED BACKWARD)",1,8,7,"Clustered Index Scan","Clustered Index Scan","OBJECT:([BDD].[dbo].[OperatorDetails].[p_OperatorID]), ORDERED BACKWARD","[BDD].[dbo].[OperatorDetails].[OperatorID], [BDD].[dbo].[OperatorDetails].[UserDomainName], [BDD].[dbo].[OperatorDetails].[UserFullName]",102,0.003125,0.0002692,51,0.0033942,"[BDD].[dbo].[OperatorDetails].[OperatorID], [BDD].[dbo].[OperatorDetails].[UserDomainName], [BDD].[dbo].[OperatorDetails].[UserFullName]","NULL","PLAN_ROW",0,1]
["       |              |         |--Nested Loops(Left Outer Join, OUTER REFERENCES:([AlmDetailTbl].[CommentId], [Expr1101]) WITH ORDERED PREFETCH)",1,9,7,"Nested Loops","Left Outer Join","OUTER REFERENCES:([AlmDetailTbl].[CommentId], [Expr1101]) WITH ORDERED PREFETCH","NULL",146.5499,0,0.0006125786,506,2.892923,"[BDD].[dbo].[AlarmMaster].[OriginationTime], [AlmDetailTbl].[OperatorName], [AlmDetailTbl].[OperatorNode], [AlmDetailTbl].[Priority], [AlmDetailTbl].[LimitString], [AlmDetailTbl].[ValueString], [AlmDetailTbl].[TransitionTime], [AlmDetailTbl].[TransitionTimeFracSec], [AlmDetailTbl].[User1], [AlmDetailTbl].[User2], [AlmDetailTbl].[User3], [AlmDetailTbl].[OperatorID], [AlmDetailTbl].[EventStamp], [BDD].[dbo].[Comment].[Comment], [Expr1014], [Expr1015], [Expr1016], [Expr1017], [Expr1018], [Expr1019]","NULL","PLAN_ROW",0,1]
["       |              |              |--Sort(ORDER BY:([AlmDetailTbl].[OperatorID] ASC))",1,11,9,"Sort","Sort","ORDER BY:([AlmDetailTbl].[OperatorID] ASC)","NULL",146.5499,0.01126126,0.001745395,433,2.516083,"[BDD].[dbo].[AlarmMaster].[OriginationTime], [AlmDetailTbl].[OperatorName], [AlmDetailTbl].[OperatorNode], [AlmDetailTbl].[Priority], [AlmDetailTbl].[LimitString], [AlmDetailTbl].[ValueString], [AlmDetailTbl].[TransitionTime], [AlmDetailTbl].[TransitionTimeFracSec], [AlmDetailTbl].[CommentId], [AlmDetailTbl].[User1], [AlmDetailTbl].[User2], [AlmDetailTbl].[User3], [AlmDetailTbl].[OperatorID], [AlmDetailTbl].[EventStamp], [Expr1014], [Expr1015], [Expr1016], [Expr1017], [Expr1018], [Expr1019]","NULL","PLAN_ROW",0,1]
["       |              |              |    |--Merge Join(Inner Join, MERGE:([BDD].[dbo].[ProviderSession].[ProviderId])=([BDD].[dbo].[AlarmMaster].[ProviderId]), RESIDUAL:([BDD].[dbo].[AlarmMaster].[ProviderId]=[BDD].[dbo].[ProviderSession].[ProviderId]))",1,12,11,"Merge Join","Inner Join","MERGE:([BDD].[dbo].[ProviderSession].[ProviderId])=([BDD].[dbo].[AlarmMaster].[ProviderId]), RESIDUAL:([BDD].[dbo].[AlarmMaster].[ProviderId]=[BDD].[dbo].[ProviderSession].[ProviderId])","NULL",146.5499,0,0.00595601,433,2.503077,"[BDD].[dbo].[AlarmMaster].[OriginationTime], [AlmDetailTbl].[OperatorName], [AlmDetailTbl].[OperatorNode], [AlmDetailTbl].[Priority], [AlmDetailTbl].[LimitString], [AlmDetailTbl].[ValueString], [AlmDetailTbl].[TransitionTime], [AlmDetailTbl].[TransitionTimeFracSec], [AlmDetailTbl].[CommentId], [AlmDetailTbl].[User1], [AlmDetailTbl].[User2], [AlmDetailTbl].[User3], [AlmDetailTbl].[OperatorID], [AlmDetailTbl].[EventStamp], [Expr1014], [Expr1015], [Expr1016], [Expr1017], [Expr1018], [Expr1019]","NULL","PLAN_ROW",0,1]
["       |              |              |         |--Compute Scalar(DEFINE:([Expr1019]=(rtrim([BDD].[dbo].[ProviderSession].[NodeName])+N'\\')+rtrim([BDD].[dbo].[ProviderSession].[ProviderType])))",1,13,12,"Compute Scalar","Compute Scalar","DEFINE:([Expr1019]=(rtrim([BDD].[dbo].[ProviderSession].[NodeName])+N'\\')+rtrim([BDD].[dbo].[ProviderSession].[ProviderType]))","[Expr1019]=(rtrim([BDD].[dbo].[ProviderSession].[NodeName])+N'\\')+rtrim([BDD].[dbo].[ProviderSession].[ProviderType])",16,0,1.6e-06,80,0.0033012,"[BDD].[dbo].[ProviderSession].[ProviderId], [Expr1019]","NULL","PLAN_ROW",0,1]
["       |              |              |         |    |--Clustered Index Scan(OBJECT:([BDD].[dbo].[ProviderSession].[P_ProviderSession]), ORDERED BACKWARD)",1,14,13,"Clustered Index Scan","Clustered Index Scan","OBJECT:([BDD].[dbo].[ProviderSession].[P_ProviderSession]), ORDERED BACKWARD","[BDD].[dbo].[ProviderSession].[ProviderId], [BDD].[dbo].[ProviderSession].[NodeName], [BDD].[dbo].[ProviderSession].[ProviderType]",16,0.003125,0.0001746,60,0.0032996,"[BDD].[dbo].[ProviderSession].[ProviderId], [BDD].[dbo].[ProviderSession].[NodeName], [BDD].[dbo].[ProviderSession].[ProviderType]","NULL","PLAN_ROW",0,1]
["       |              |              |         |--Sort(ORDER BY:([BDD].[dbo].[AlarmMaster].[ProviderId] ASC))",1,18,12,"Sort","Sort","ORDER BY:([BDD].[dbo].[AlarmMaster].[ProviderId] ASC)","NULL",146.5499,0.01126126,0.001745332,370,2.493817,"[BDD].[dbo].[AlarmMaster].[ProviderId], [BDD].[dbo].[AlarmMaster].[OriginationTime], [AlmDetailTbl].[OperatorName], [AlmDetailTbl].[OperatorNode], [AlmDetailTbl].[Priority], [AlmDetailTbl].[LimitString], [AlmDetailTbl].[ValueString], [AlmDetailTbl].[TransitionTime], [AlmDetailTbl].[TransitionTimeFracSec], [AlmDetailTbl].[CommentId], [AlmDetailTbl].[User1], [AlmDetailTbl].[User2], [AlmDetailTbl].[User3], [AlmDetailTbl].[OperatorID], [AlmDetailTbl].[EventStamp], [Expr1014], [Expr1015], [Expr1016], [Expr1017], [Expr1018]","NULL","PLAN_ROW",0,1]
["       |              |              |              |--Compute Scalar(DEFINE:([Expr1015]=CONVERT(nvarchar(132),[BDD].[dbo].[AlarmMaster].[TagName],0), [Expr1016]=CONVERT(nvarchar(32),[BDD].[dbo].[AlarmMaster].[GroupName],0), [Expr1018]=CONVERT(nvarchar(5),[BDD].[dbo].[AlarmMaster].[AlarmClass],0)))",1,19,18,"Compute Scalar","Compute Scalar","DEFINE:([Expr1015]=CONVERT(nvarchar(132),[BDD].[dbo].[AlarmMaster].[TagName],0), [Expr1016]=CONVERT(nvarchar(32),[BDD].[dbo].[AlarmMaster].[GroupName],0), [Expr1018]=CONVERT(nvarchar(5),[BDD].[dbo].[AlarmMaster].[AlarmClass],0))","[Expr1015]=CONVERT(nvarchar(132),[BDD].[dbo].[AlarmMaster].[TagName],0), [Expr1016]=CONVERT(nvarchar(32),[BDD].[dbo].[AlarmMaster].[GroupName],0), [Expr1018]=CONVERT(nvarchar(5),[BDD].[dbo].[AlarmMaster].[AlarmClass],0)",146.5499,0,1.465499e-05,370,2.48081,"[BDD].[dbo].[AlarmMaster].[ProviderId], [BDD].[dbo].[AlarmMaster].[OriginationTime], [AlmDetailTbl].[OperatorName], [AlmDetailTbl].[OperatorNode], [AlmDetailTbl].[Priority], [AlmDetailTbl].[LimitString], [AlmDetailTbl].[ValueString], [AlmDetailTbl].[TransitionTime], [AlmDetailTbl].[TransitionTimeFracSec], [AlmDetailTbl].[CommentId], [AlmDetailTbl].[User1], [AlmDetailTbl].[User2], [AlmDetailTbl].[User3], [AlmDetailTbl].[OperatorID], [AlmDetailTbl].[EventStamp], [Expr1014], [Expr1015], [Expr1016], [Expr1017], [Expr1018]","NULL","PLAN_ROW",0,1]
["       |              |              |                   |--Nested Loops(Inner Join, OUTER REFERENCES:([AlmDetailTbl].[AlarmId], [Expr1100]) OPTIMIZED WITH UNORDERED PREFETCH)",1,20,19,"Nested Loops","Inner Join","OUTER REFERENCES:([AlmDetailTbl].[AlarmId], [Expr1100]) OPTIMIZED WITH UNORDERED PREFETCH","NULL",146.5499,0,0.0006125799,368,2.480795,"[BDD].[dbo].[AlarmMaster].[ProviderId], [BDD].[dbo].[AlarmMaster].[GroupName], [BDD].[dbo].[AlarmMaster].[TagName], [BDD].[dbo].[AlarmMaster].[AlarmClass], [BDD].[dbo].[AlarmMaster].[OriginationTime], [AlmDetailTbl].[OperatorName], [AlmDetailTbl].[OperatorNode], [AlmDetailTbl].[Priority], [AlmDetailTbl].[LimitString], [AlmDetailTbl].[ValueString], [AlmDetailTbl].[TransitionTime], [AlmDetailTbl].[TransitionTimeFracSec], [AlmDetailTbl].[CommentId], [AlmDetailTbl].[User1], [AlmDetailTbl].[User2], [AlmDetailTbl].[User3], [AlmDetailTbl].[OperatorID], [AlmDetailTbl].[EventStamp], [Expr1014], [Expr1017]","NULL","PLAN_ROW",0,1]
["       |              |              |                        |--Compute Scalar(DEFINE:([AlmDetailTbl].[EventStamp]=[BDD].[dbo].[AlarmDetail].[EventStamp] as [AlmDetailTbl].[EventStamp], [Expr1014]=CONVERT(nvarchar(9),[BDD].[dbo].[AlarmDetail].[AlarmState] as [AlmDetailTbl].[AlarmState],0), [Expr1017]=CONVERT(nvarchar(6),[BDD].[dbo].[AlarmDetail].[AlarmType] as [AlmDetailTbl].[AlarmType],0)))",1,23,20,"Compute Scalar","Compute Scalar","DEFINE:([AlmDetailTbl].[EventStamp]=[BDD].[dbo].[AlarmDetail].[EventStamp] as [AlmDetailTbl].[EventStamp], [Expr1014]=CONVERT(nvarchar(9),[BDD].[dbo].[AlarmDetail].[AlarmState] as [AlmDetailTbl].[AlarmState],0), [Expr1017]=CONVERT(nvarchar(6),[BDD].[dbo].[AlarmDetail].[AlarmType] as [AlmDetailTbl].[AlarmType],0))","[AlmDetailTbl].[EventStamp]=[BDD].[dbo].[AlarmDetail].[EventStamp] as [AlmDetailTbl].[EventStamp], [Expr1014]=CONVERT(nvarchar(9),[BDD].[dbo].[AlarmDetail].[AlarmState] as [AlmDetailTbl].[AlarmState],0), [Expr1017]=CONVERT(nvarchar(6),[BDD].[dbo].[AlarmDetail].[AlarmType] as [AlmDetailTbl].[AlarmType],0)",146.5502,0,1.465502e-05,268,2.003122,"[AlmDetailTbl].[AlarmId], [AlmDetailTbl].[OperatorName], [AlmDetailTbl].[OperatorNode], [AlmDetailTbl].[Priority], [AlmDetailTbl].[LimitString], [AlmDetailTbl].[ValueString], [AlmDetailTbl].[TransitionTime], [AlmDetailTbl].[TransitionTimeFracSec], [AlmDetailTbl].[CommentId], [AlmDetailTbl].[User1], [AlmDetailTbl].[User2], [AlmDetailTbl].[User3], [AlmDetailTbl].[OperatorID], [AlmDetailTbl].[EventStamp], [Expr1014], [Expr1017]","NULL","PLAN_ROW",0,1]
["       |              |              |                        |    |--Nested Loops(Inner Join, OUTER REFERENCES:([AlmDetailTbl].[AlarmDetailId], [Expr1099]) OPTIMIZED WITH UNORDERED PREFETCH)",1,24,23,"Nested Loops","Inner Join","OUTER REFERENCES:([AlmDetailTbl].[AlarmDetailId], [Expr1099]) OPTIMIZED WITH UNORDERED PREFETCH","NULL",613.2842,0,0.002563528,273,2.002567,"[AlmDetailTbl].[AlarmId], [AlmDetailTbl].[OperatorName], [AlmDetailTbl].[OperatorNode], [AlmDetailTbl].[AlarmState], [AlmDetailTbl].[AlarmType], [AlmDetailTbl].[Priority], [AlmDetailTbl].[LimitString], [AlmDetailTbl].[ValueString], [AlmDetailTbl].[TransitionTime], [AlmDetailTbl].[TransitionTimeFracSec], [AlmDetailTbl].[CommentId], [AlmDetailTbl].[User1], [AlmDetailTbl].[User2], [AlmDetailTbl].[User3], [AlmDetailTbl].[OperatorID], [AlmDetailTbl].[EventStamp]","NULL","PLAN_ROW",0,1]
["       |              |              |                        |         |--Index Seek(OBJECT:([BDD].[dbo].[AlarmDetail].[i_EventStamp] AS [AlmDetailTbl]), SEEK:([AlmDetailTbl].[EventStamp] > '2016-03-24 10:50:00.000' AND [AlmDetailTbl].[EventStamp] < '2016-03-25 00:05:00.000') ORDERED FORWARD)",1,27,24,"Index Seek","Index Seek","OBJECT:([BDD].[dbo].[AlarmDetail].[i_EventStamp] AS [AlmDetailTbl]), SEEK:([AlmDetailTbl].[EventStamp] > '2016-03-24 10:50:00.000' AND [AlmDetailTbl].[EventStamp] < '2016-03-25 00:05:00.000') ORDERED FORWARD","[AlmDetailTbl].[AlarmDetailId], [AlmDetailTbl].[EventStamp]",613.2842,0.003865741,0.0008316126,19,0.004697353,"[AlmDetailTbl].[AlarmDetailId], [AlmDetailTbl].[EventStamp]","NULL","PLAN_ROW",0,1]
["       |              |              |                        |         |--Clustered Index Seek(OBJECT:([BDD].[dbo].[AlarmDetail].[P_AlarmDetail] AS [AlmDetailTbl]), SEEK:([AlmDetailTbl].[AlarmDetailId]=[BDD].[dbo].[AlarmDetail].[AlarmDetailId] as [AlmDetailTbl].[AlarmDetailId]),  WHERE:([BDD].[dbo].[AlarmDetail].[Priority] as [AlmDetailTbl].[Priority]=(100) AND [BDD].[dbo].[AlarmDetail].[AlarmTransition] as [AlmDetailTbl].[AlarmTransition]=N'RTN') LOOKUP ORDERED FORWARD)",1,29,24,"Clustered Index Seek","Clustered Index Seek","OBJECT:([BDD].[dbo].[AlarmDetail].[P_AlarmDetail] AS [AlmDetailTbl]), SEEK:([AlmDetailTbl].[AlarmDetailId]=[BDD].[dbo].[AlarmDetail].[AlarmDetailId] as [AlmDetailTbl].[AlarmDetailId]),  WHERE:([BDD].[dbo].[AlarmDetail].[Priority] as [AlmDetailTbl].[Priority]=(100) AND [BDD].[dbo].[AlarmDetail].[AlarmTransition] as [AlmDetailTbl].[AlarmTransition]=N'RTN') LOOKUP ORDERED FORWARD","[AlmDetailTbl].[AlarmId], [AlmDetailTbl].[OperatorName], [AlmDetailTbl].[OperatorNode], [AlmDetailTbl].[AlarmState], [AlmDetailTbl].[AlarmType], [AlmDetailTbl].[Priority], [AlmDetailTbl].[LimitString], [AlmDetailTbl].[ValueString], [AlmDetailTbl].[TransitionTime], [AlmDetailTbl].[TransitionTimeFracSec], [AlmDetailTbl].[CommentId], [AlmDetailTbl].[User1], [AlmDetailTbl].[User2], [AlmDetailTbl].[User3], [AlmDetailTbl].[OperatorID]",146.5502,0.003125,0.0001581,637,1.995306,"[AlmDetailTbl].[AlarmId], [AlmDetailTbl].[OperatorName], [AlmDetailTbl].[OperatorNode], [AlmDetailTbl].[AlarmState], [AlmDetailTbl].[AlarmType], [AlmDetailTbl].[Priority], [AlmDetailTbl].[LimitString], [AlmDetailTbl].[ValueString], [AlmDetailTbl].[TransitionTime], [AlmDetailTbl].[TransitionTimeFracSec], [AlmDetailTbl].[CommentId], [AlmDetailTbl].[User1], [AlmDetailTbl].[User2], [AlmDetailTbl].[User3], [AlmDetailTbl].[OperatorID]","NULL","PLAN_ROW",0,613.2842]
["       |              |              |                        |--Clustered Index Seek(OBJECT:([BDD].[dbo].[AlarmMaster].[P_AlarmMaster]), SEEK:([BDD].[dbo].[AlarmMaster].[AlarmId]=[BDD].[dbo].[AlarmDetail].[AlarmId] as [AlmDetailTbl].[AlarmId]),  WHERE:(CONVERT(nvarchar(32),[BDD].[dbo].[AlarmMaster].[GroupName],0) like N'#M11202%') ORDERED FORWARD)",1,68,20,"Clustered Index Seek","Clustered Index Seek","OBJECT:([BDD].[dbo].[AlarmMaster].[P_AlarmMaster]), SEEK:([BDD].[dbo].[AlarmMaster].[AlarmId]=[BDD].[dbo].[AlarmDetail].[AlarmId] as [AlmDetailTbl].[AlarmId]),  WHERE:(CONVERT(nvarchar(32),[BDD].[dbo].[AlarmMaster].[GroupName],0) like N'#M11202%') ORDERED FORWARD","[BDD].[dbo].[AlarmMaster].[ProviderId], [BDD].[dbo].[AlarmMaster].[GroupName], [BDD].[dbo].[AlarmMaster].[TagName], [BDD].[dbo].[AlarmMaster].[AlarmClass], [BDD].[dbo].[AlarmMaster].[OriginationTime]",1,0.003125,0.0001581,112,0.4769176,"[BDD].[dbo].[AlarmMaster].[ProviderId], [BDD].[dbo].[AlarmMaster].[GroupName], [BDD].[dbo].[AlarmMaster].[TagName], [BDD].[dbo].[AlarmMaster].[AlarmClass], [BDD].[dbo].[AlarmMaster].[OriginationTime]","NULL","PLAN_ROW",0,146.5502]
["       |              |              |--Clustered Index Seek(OBJECT:([BDD].[dbo].[Comment].[P_Comment]), SEEK:([BDD].[dbo].[Comment].[CommentId]=[BDD].[dbo].[AlarmDetail].[CommentId] as [AlmDetailTbl].[CommentId]) ORDERED FORWARD)",1,77,9,"Clustered Index Seek","Clustered Index Seek","OBJECT:([BDD].[dbo].[Comment].[P_Comment]), SEEK:([BDD].[dbo].[Comment].[CommentId]=[BDD].[dbo].[AlarmDetail].[CommentId] as [AlmDetailTbl].[CommentId]) ORDERED FORWARD","[BDD].[dbo].[Comment].[Comment]",1,0.003125,0.0001581,86,0.3762274,"[BDD].[dbo].[Comment].[Comment]","NULL","PLAN_ROW",0,146.5499]
["       |              |--Compute Scalar(DEFINE:([Expr1041]='                 '))",1,82,5,"Compute Scalar","Compute Scalar","DEFINE:([Expr1041]='                 ')","[Expr1041]='                 '",200.9034,0,2.009034e-05,542,3.21769,"[AlmDetailTbl].[OperatorName], [AlmDetailTbl].[OperatorNode], [AlmDetailTbl].[Priority], [AlmDetailTbl].[LimitString], [AlmDetailTbl].[ValueString], [AlmDetailTbl].[TransitionTime], [AlmDetailTbl].[TransitionTimeFracSec], [AlmDetailTbl].[User1], [AlmDetailTbl].[User2], [AlmDetailTbl].[User3], [AlmDetailTbl].[EventStamp], [BDD].[dbo].[Comment].[Comment], [BDD].[dbo].[OperatorDetails].[UserDomainName], [BDD].[dbo].[OperatorDetails].[UserFullName], [Expr1035], [Expr1036], [Expr1037], [Expr1038], [Expr1039], [Expr1040], [Expr1041]","NULL","PLAN_ROW",0,1]
["       |                   |--Merge Join(Right Outer Join, MERGE:([BDD].[dbo].[OperatorDetails].[OperatorID])=([AlmDetailTbl].[OperatorID]), RESIDUAL:([BDD].[dbo].[AlarmDetail].[OperatorID] as [AlmDetailTbl].[OperatorID]=[BDD].[dbo].[OperatorDetails].[OperatorID]))",1,83,82,"Merge Join","Right Outer Join","MERGE:([BDD].[dbo].[OperatorDetails].[OperatorID])=([AlmDetailTbl].[OperatorID]), RESIDUAL:([BDD].[dbo].[AlarmDetail].[OperatorID] as [AlmDetailTbl].[OperatorID]=[BDD].[dbo].[OperatorDetails].[OperatorID])","NULL",200.9034,0,0.006256187,532,3.21767,"[AlmDetailTbl].[OperatorName], [AlmDetailTbl].[OperatorNode], [AlmDetailTbl].[Priority], [AlmDetailTbl].[LimitString], [AlmDetailTbl].[ValueString], [AlmDetailTbl].[TransitionTime], [AlmDetailTbl].[TransitionTimeFracSec], [AlmDetailTbl].[User1], [AlmDetailTbl].[User2], [AlmDetailTbl].[User3], [AlmDetailTbl].[EventStamp], [BDD].[dbo].[Comment].[Comment], [BDD].[dbo].[OperatorDetails].[UserDomainName], [BDD].[dbo].[OperatorDetails].[UserFullName], [Expr1035], [Expr1036], [Expr1037], [Expr1038], [Expr1039], [Expr1040]","NULL","PLAN_ROW",0,1]
["       |                        |--Clustered Index Scan(OBJECT:([BDD].[dbo].[OperatorDetails].[p_OperatorID]), ORDERED BACKWARD)",1,84,83,"Clustered Index Scan","Clustered Index Scan","OBJECT:([BDD].[dbo].[OperatorDetails].[p_OperatorID]), ORDERED BACKWARD","[BDD].[dbo].[OperatorDetails].[OperatorID], [BDD].[dbo].[OperatorDetails].[UserDomainName], [BDD].[dbo].[OperatorDetails].[UserFullName]",102,0.003125,0.0002692,51,0.0033942,"[BDD].[dbo].[OperatorDetails].[OperatorID], [BDD].[dbo].[OperatorDetails].[UserDomainName], [BDD].[dbo].[OperatorDetails].[UserFullName]","NULL","PLAN_ROW",0,1]
["       |                        |--Nested Loops(Left Outer Join, OUTER REFERENCES:([AlmDetailTbl].[CommentId], [Expr1104]) WITH ORDERED PREFETCH)",1,85,83,"Nested Loops","Left Outer Join","OUTER REFERENCES:([AlmDetailTbl].[CommentId], [Expr1104]) WITH ORDERED PREFETCH","NULL",200.9034,0,0.0008397763,498,3.208017,"[AlmDetailTbl].[OperatorName], [AlmDetailTbl].[OperatorNode], [AlmDetailTbl].[Priority], [AlmDetailTbl].[LimitString], [AlmDetailTbl].[ValueString], [AlmDetailTbl].[TransitionTime], [AlmDetailTbl].[TransitionTimeFracSec], [AlmDetailTbl].[User1], [AlmDetailTbl].[User2], [AlmDetailTbl].[User3], [AlmDetailTbl].[OperatorID], [AlmDetailTbl].[EventStamp], [BDD].[dbo].[Comment].[Comment], [Expr1035], [Expr1036], [Expr1037], [Expr1038], [Expr1039], [Expr1040]","NULL","PLAN_ROW",0,1]
["       |                             |--Sort(ORDER BY:([AlmDetailTbl].[OperatorID] ASC))",1,87,85,"Sort","Sort","ORDER BY:([AlmDetailTbl].[OperatorID] ASC)","NULL",200.9034,0.01126126,0.002498119,425,2.695374,"[AlmDetailTbl].[OperatorName], [AlmDetailTbl].[OperatorNode], [AlmDetailTbl].[Priority], [AlmDetailTbl].[LimitString], [AlmDetailTbl].[ValueString], [AlmDetailTbl].[TransitionTime], [AlmDetailTbl].[TransitionTimeFracSec], [AlmDetailTbl].[CommentId], [AlmDetailTbl].[User1], [AlmDetailTbl].[User2], [AlmDetailTbl].[User3], [AlmDetailTbl].[OperatorID], [AlmDetailTbl].[EventStamp], [Expr1035], [Expr1036], [Expr1037], [Expr1038], [Expr1039], [Expr1040]","NULL","PLAN_ROW",0,1]
["       |                             |    |--Hash Match(Inner Join, HASH:([BDD].[dbo].[ProviderSession].[ProviderId])=([BDD].[dbo].[AlarmMaster].[ProviderId]))",1,88,87,"Hash Match","Inner Join","HASH:([BDD].[dbo].[ProviderSession].[ProviderId])=([BDD].[dbo].[AlarmMaster].[ProviderId])","NULL",200.9034,0,0.01949039,425,2.681615,"[AlmDetailTbl].[OperatorName], [AlmDetailTbl].[OperatorNode], [AlmDetailTbl].[Priority], [AlmDetailTbl].[LimitString], [AlmDetailTbl].[ValueString], [AlmDetailTbl].[TransitionTime], [AlmDetailTbl].[TransitionTimeFracSec], [AlmDetailTbl].[CommentId], [AlmDetailTbl].[User1], [AlmDetailTbl].[User2], [AlmDetailTbl].[User3], [AlmDetailTbl].[OperatorID], [AlmDetailTbl].[EventStamp], [Expr1035], [Expr1036], [Expr1037], [Expr1038], [Expr1039], [Expr1040]","NULL","PLAN_ROW",0,1]
["       |                             |         |--Compute Scalar(DEFINE:([Expr1040]=(rtrim([BDD].[dbo].[ProviderSession].[NodeName])+N'\\')+rtrim([BDD].[dbo].[ProviderSession].[ProviderType])))",1,89,88,"Compute Scalar","Compute Scalar","DEFINE:([Expr1040]=(rtrim([BDD].[dbo].[ProviderSession].[NodeName])+N'\\')+rtrim([BDD].[dbo].[ProviderSession].[ProviderType]))","[Expr1040]=(rtrim([BDD].[dbo].[ProviderSession].[NodeName])+N'\\')+rtrim([BDD].[dbo].[ProviderSession].[ProviderType])",16,0,1.6e-06,80,0.0033012,"[BDD].[dbo].[ProviderSession].[ProviderId], [Expr1040]","NULL","PLAN_ROW",0,1]
["       |                             |         |    |--Clustered Index Scan(OBJECT:([BDD].[dbo].[ProviderSession].[P_ProviderSession]))",1,90,89,"Clustered Index Scan","Clustered Index Scan","OBJECT:([BDD].[dbo].[ProviderSession].[P_ProviderSession])","[BDD].[dbo].[ProviderSession].[ProviderId], [BDD].[dbo].[ProviderSession].[NodeName], [BDD].[dbo].[ProviderSession].[ProviderType]",16,0.003125,0.0001746,60,0.0032996,"[BDD].[dbo].[ProviderSession].[ProviderId], [BDD].[dbo].[ProviderSession].[NodeName], [BDD].[dbo].[ProviderSession].[ProviderType]","NULL","PLAN_ROW",0,1]
["       |                             |         |--Compute Scalar(DEFINE:([Expr1036]=CONVERT(nvarchar(132),[BDD].[dbo].[AlarmMaster].[TagName],0), [Expr1037]=CONVERT(nvarchar(32),[BDD].[dbo].[AlarmMaster].[GroupName],0), [Expr1039]=CONVERT(nvarchar(5),[BDD].[dbo].[AlarmMaster].[AlarmClass],0)))",1,94,88,"Compute Scalar","Compute Scalar","DEFINE:([Expr1036]=CONVERT(nvarchar(132),[BDD].[dbo].[AlarmMaster].[TagName],0), [Expr1037]=CONVERT(nvarchar(32),[BDD].[dbo].[AlarmMaster].[GroupName],0), [Expr1039]=CONVERT(nvarchar(5),[BDD].[dbo].[AlarmMaster].[AlarmClass],0))","[Expr1036]=CONVERT(nvarchar(132),[BDD].[dbo].[AlarmMaster].[TagName],0), [Expr1037]=CONVERT(nvarchar(32),[BDD].[dbo].[AlarmMaster].[GroupName],0), [Expr1039]=CONVERT(nvarchar(5),[BDD].[dbo].[AlarmMaster].[AlarmClass],0)",200.9034,0,2.009034e-05,362,2.658821,"[BDD].[dbo].[AlarmMaster].[ProviderId], [AlmDetailTbl].[OperatorName], [AlmDetailTbl].[OperatorNode], [AlmDetailTbl].[Priority], [AlmDetailTbl].[LimitString], [AlmDetailTbl].[ValueString], [AlmDetailTbl].[TransitionTime], [AlmDetailTbl].[TransitionTimeFracSec], [AlmDetailTbl].[CommentId], [AlmDetailTbl].[User1], [AlmDetailTbl].[User2], [AlmDetailTbl].[User3], [AlmDetailTbl].[OperatorID], [AlmDetailTbl].[EventStamp], [Expr1035], [Expr1036], [Expr1037], [Expr1038], [Expr1039]","NULL","PLAN_ROW",0,1]
["       |                             |              |--Nested Loops(Inner Join, OUTER REFERENCES:([AlmDetailTbl].[AlarmId], [Expr1103]) OPTIMIZED WITH UNORDERED PREFETCH)",1,95,94,"Nested Loops","Inner Join","OUTER REFERENCES:([AlmDetailTbl].[AlarmId], [Expr1103]) OPTIMIZED WITH UNORDERED PREFETCH","NULL",200.9034,0,0.0008397781,360,2.658801,"[BDD].[dbo].[AlarmMaster].[ProviderId], [BDD].[dbo].[AlarmMaster].[GroupName], [BDD].[dbo].[AlarmMaster].[TagName], [BDD].[dbo].[AlarmMaster].[AlarmClass], [AlmDetailTbl].[OperatorName], [AlmDetailTbl].[OperatorNode], [AlmDetailTbl].[Priority], [AlmDetailTbl].[LimitString], [AlmDetailTbl].[ValueString], [AlmDetailTbl].[TransitionTime], [AlmDetailTbl].[TransitionTimeFracSec], [AlmDetailTbl].[CommentId], [AlmDetailTbl].[User1], [AlmDetailTbl].[User2], [AlmDetailTbl].[User3], [AlmDetailTbl].[OperatorID], [AlmDetailTbl].[EventStamp], [Expr1035], [Expr1038]","NULL","PLAN_ROW",0,1]
["       |                             |                   |--Compute Scalar(DEFINE:([AlmDetailTbl].[EventStamp]=[BDD].[dbo].[AlarmDetail].[EventStamp] as [AlmDetailTbl].[EventStamp], [Expr1035]=CONVERT(nvarchar(9),[BDD].[dbo].[AlarmDetail].[AlarmState] as [AlmDetailTbl].[AlarmState],0), [Expr1038]=CONVERT(nvarchar(6),[BDD].[dbo].[AlarmDetail].[AlarmType] as [AlmDetailTbl].[AlarmType],0)))",1,98,95,"Compute Scalar","Compute Scalar","DEFINE:([AlmDetailTbl].[EventStamp]=[BDD].[dbo].[AlarmDetail].[EventStamp] as [AlmDetailTbl].[EventStamp], [Expr1035]=CONVERT(nvarchar(9),[BDD].[dbo].[AlarmDetail].[AlarmState] as [AlmDetailTbl].[AlarmState],0), [Expr1038]=CONVERT(nvarchar(6),[BDD].[dbo].[AlarmDetail].[AlarmType] as [AlmDetailTbl].[AlarmType],0))","[AlmDetailTbl].[EventStamp]=[BDD].[dbo].[AlarmDetail].[EventStamp] as [AlmDetailTbl].[EventStamp], [Expr1035]=CONVERT(nvarchar(9),[BDD].[dbo].[AlarmDetail].[AlarmState] as [AlmDetailTbl].[AlarmState],0), [Expr1038]=CONVERT(nvarchar(6),[BDD].[dbo].[AlarmDetail].[AlarmType] as [AlmDetailTbl].[AlarmType],0)",200.9039,0,2.009039e-05,268,2.003372,"[AlmDetailTbl].[AlarmId], [AlmDetailTbl].[OperatorName], [AlmDetailTbl].[OperatorNode], [AlmDetailTbl].[Priority], [AlmDetailTbl].[LimitString], [AlmDetailTbl].[ValueString], [AlmDetailTbl].[TransitionTime], [AlmDetailTbl].[TransitionTimeFracSec], [AlmDetailTbl].[CommentId], [AlmDetailTbl].[User1], [AlmDetailTbl].[User2], [AlmDetailTbl].[User3], [AlmDetailTbl].[OperatorID], [AlmDetailTbl].[EventStamp], [Expr1035], [Expr1038]","NULL","PLAN_ROW",0,1]
["       |                             |                   |    |--Nested Loops(Inner Join, OUTER REFERENCES:([AlmDetailTbl].[AlarmDetailId], [Expr1102]) OPTIMIZED WITH UNORDERED PREFETCH)",1,99,98,"Nested Loops","Inner Join","OUTER REFERENCES:([AlmDetailTbl].[AlarmDetailId], [Expr1102]) OPTIMIZED WITH UNORDERED PREFETCH","NULL",613.2842,0,0.002563528,273,2.002567,"[AlmDetailTbl].[AlarmId], [AlmDetailTbl].[OperatorName], [AlmDetailTbl].[OperatorNode], [AlmDetailTbl].[AlarmState], [AlmDetailTbl].[AlarmType], [AlmDetailTbl].[Priority], [AlmDetailTbl].[LimitString], [AlmDetailTbl].[ValueString], [AlmDetailTbl].[TransitionTime], [AlmDetailTbl].[TransitionTimeFracSec], [AlmDetailTbl].[CommentId], [AlmDetailTbl].[User1], [AlmDetailTbl].[User2], [AlmDetailTbl].[User3], [AlmDetailTbl].[OperatorID], [AlmDetailTbl].[EventStamp]","NULL","PLAN_ROW",0,1]
["       |                             |                   |         |--Index Seek(OBJECT:([BDD].[dbo].[AlarmDetail].[i_EventStamp] AS [AlmDetailTbl]), SEEK:([AlmDetailTbl].[EventStamp] > '2016-03-24 10:50:00.000' AND [AlmDetailTbl].[EventStamp] < '2016-03-25 00:05:00.000') ORDERED FORWARD)",1,102,99,"Index Seek","Index Seek","OBJECT:([BDD].[dbo].[AlarmDetail].[i_EventStamp] AS [AlmDetailTbl]), SEEK:([AlmDetailTbl].[EventStamp] > '2016-03-24 10:50:00.000' AND [AlmDetailTbl].[EventStamp] < '2016-03-25 00:05:00.000') ORDERED FORWARD","[AlmDetailTbl].[AlarmDetailId], [AlmDetailTbl].[EventStamp]",613.2842,0.003865741,0.0008316126,19,0.004697353,"[AlmDetailTbl].[AlarmDetailId], [AlmDetailTbl].[EventStamp]","NULL","PLAN_ROW",0,1]
["       |                             |                   |         |--Clustered Index Seek(OBJECT:([BDD].[dbo].[AlarmDetail].[P_AlarmDetail] AS [AlmDetailTbl]), SEEK:([AlmDetailTbl].[AlarmDetailId]=[BDD].[dbo].[AlarmDetail].[AlarmDetailId] as [AlmDetailTbl].[AlarmDetailId]),  WHERE:([BDD].[dbo].[AlarmDetail].[Priority] as [AlmDetailTbl].[Priority]=(100) AND ([BDD].[dbo].[AlarmDetail].[AlarmTransition] as [AlmDetailTbl].[AlarmTransition]<N'RTN' OR [BDD].[dbo].[AlarmDetail].[AlarmTransition] as [AlmDetailTbl].[AlarmTransition]>N'RTN')) LOOKUP ORDERED FORWARD)",1,104,99,"Clustered Index Seek","Clustered Index Seek","OBJECT:([BDD].[dbo].[AlarmDetail].[P_AlarmDetail] AS [AlmDetailTbl]), SEEK:([AlmDetailTbl].[AlarmDetailId]=[BDD].[dbo].[AlarmDetail].[AlarmDetailId] as [AlmDetailTbl].[AlarmDetailId]),  WHERE:([BDD].[dbo].[AlarmDetail].[Priority] as [AlmDetailTbl].[Priority]=(100) AND ([BDD].[dbo].[AlarmDetail].[AlarmTransition] as [AlmDetailTbl].[AlarmTransition]<N'RTN' OR [BDD].[dbo].[AlarmDetail].[AlarmTransition] as [AlmDetailTbl].[AlarmTransition]>N'RTN')) LOOKUP ORDERED FORWARD","[AlmDetailTbl].[AlarmId], [AlmDetailTbl].[OperatorName], [AlmDetailTbl].[OperatorNode], [AlmDetailTbl].[AlarmState], [AlmDetailTbl].[AlarmType], [AlmDetailTbl].[Priority], [AlmDetailTbl].[LimitString], [AlmDetailTbl].[ValueString], [AlmDetailTbl].[TransitionTime], [AlmDetailTbl].[TransitionTimeFracSec], [AlmDetailTbl].[CommentId], [AlmDetailTbl].[User1], [AlmDetailTbl].[User2], [AlmDetailTbl].[User3], [AlmDetailTbl].[OperatorID]",200.9039,0.003125,0.0001581,637,1.995306,"[AlmDetailTbl].[AlarmId], [AlmDetailTbl].[OperatorName], [AlmDetailTbl].[OperatorNode], [AlmDetailTbl].[AlarmState], [AlmDetailTbl].[AlarmType], [AlmDetailTbl].[Priority], [AlmDetailTbl].[LimitString], [AlmDetailTbl].[ValueString], [AlmDetailTbl].[TransitionTime], [AlmDetailTbl].[TransitionTimeFracSec], [AlmDetailTbl].[CommentId], [AlmDetailTbl].[User1], [AlmDetailTbl].[User2], [AlmDetailTbl].[User3], [AlmDetailTbl].[OperatorID]","NULL","PLAN_ROW",0,613.2842]
["       |                             |                   |--Clustered Index Seek(OBJECT:([BDD].[dbo].[AlarmMaster].[P_AlarmMaster]), SEEK:([BDD].[dbo].[AlarmMaster].[AlarmId]=[BDD].[dbo].[AlarmDetail].[AlarmId] as [AlmDetailTbl].[AlarmId]),  WHERE:(CONVERT(nvarchar(32),[BDD].[dbo].[AlarmMaster].[GroupName],0) like N'#M11202%') ORDERED FORWARD)",1,143,95,"Clustered Index Seek","Clustered Index Seek","OBJECT:([BDD].[dbo].[AlarmMaster].[P_AlarmMaster]), SEEK:([BDD].[dbo].[AlarmMaster].[AlarmId]=[BDD].[dbo].[AlarmDetail].[AlarmId] as [AlmDetailTbl].[AlarmId]),  WHERE:(CONVERT(nvarchar(32),[BDD].[dbo].[AlarmMaster].[GroupName],0) like N'#M11202%') ORDERED FORWARD","[BDD].[dbo].[AlarmMaster].[ProviderId], [BDD].[dbo].[AlarmMaster].[GroupName], [BDD].[dbo].[AlarmMaster].[TagName], [BDD].[dbo].[AlarmMaster].[AlarmClass]",1,0.003125,0.0001581,104,0.6543915,"[BDD].[dbo].[AlarmMaster].[ProviderId], [BDD].[dbo].[AlarmMaster].[GroupName], [BDD].[dbo].[AlarmMaster].[TagName], [BDD].[dbo].[AlarmMaster].[AlarmClass]","NULL","PLAN_ROW",0,200.9039]
["       |                             |--Clustered Index Seek(OBJECT:([BDD].[dbo].[Comment].[P_Comment]), SEEK:([BDD].[dbo].[Comment].[CommentId]=[BDD].[dbo].[AlarmDetail].[CommentId] as [AlmDetailTbl].[CommentId]) ORDERED FORWARD)",1,152,85,"Clustered Index Seek","Clustered Index Seek","OBJECT:([BDD].[dbo].[Comment].[P_Comment]), SEEK:([BDD].[dbo].[Comment].[CommentId]=[BDD].[dbo].[AlarmDetail].[CommentId] as [AlmDetailTbl].[CommentId]) ORDERED FORWARD","[BDD].[dbo].[Comment].[Comment]",1,0.003125,0.0001581,86,0.5118026,"[BDD].[dbo].[Comment].[Comment]","NULL","PLAN_ROW",0,200.9034]
["       |--Compute Scalar(DEFINE:([Expr1077]='                 '))",1,158,2,"Compute Scalar","Compute Scalar","DEFINE:([Expr1077]='                 ')","[Expr1077]='                 '",1,0,1e-07,1149,0.00985994,"[BDD].[dbo].[Events].[GroupName], [BDD].[dbo].[Events].[TagName], [BDD].[dbo].[Events].[EventPriority], [BDD].[dbo].[Events].[ValueString], [BDD].[dbo].[Events].[LimitString], [BDD].[dbo].[Events].[EventTime], [BDD].[dbo].[Events].[EventTimeFracSec], [BDD].[dbo].[Events].[OperatorNode], [BDD].[dbo].[Events].[OperatorName], [BDD].[dbo].[Events].[User1], [BDD].[dbo].[Events].[User2], [BDD].[dbo].[Events].[User3], [BDD].[dbo].[Events].[EventStamp], [BDD].[dbo].[OperatorDetails].[UserDomainName], [BDD].[dbo].[OperatorDetails].[UserFullName], [Expr1072], [Expr1073], [Expr1074], [Expr1075], [Expr1076], [Expr1077]","NULL","PLAN_ROW",0,1]
["            |--Nested Loops(Left Outer Join, OUTER REFERENCES:([BDD].[dbo].[Events].[OperatorID]))",1,159,158,"Nested Loops","Left Outer Join","OUTER REFERENCES:([BDD].[dbo].[Events].[OperatorID])","NULL",1,0,4.18e-06,1139,0.00985984,"[BDD].[dbo].[Events].[GroupName], [BDD].[dbo].[Events].[TagName], [BDD].[dbo].[Events].[EventPriority], [BDD].[dbo].[Events].[ValueString], [BDD].[dbo].[Events].[LimitString], [BDD].[dbo].[Events].[EventTime], [BDD].[dbo].[Events].[EventTimeFracSec], [BDD].[dbo].[Events].[OperatorNode], [BDD].[dbo].[Events].[OperatorName], [BDD].[dbo].[Events].[User1], [BDD].[dbo].[Events].[User2], [BDD].[dbo].[Events].[User3], [BDD].[dbo].[Events].[EventStamp], [BDD].[dbo].[OperatorDetails].[UserDomainName], [BDD].[dbo].[OperatorDetails].[UserFullName], [Expr1072], [Expr1073], [Expr1074], [Expr1075], [Expr1076]","NULL","PLAN_ROW",0,1]
["                 |--Compute Scalar(DEFINE:([Expr1076]=(rtrim([BDD].[dbo].[ProviderSession].[NodeName])+N'\\')+rtrim([BDD].[dbo].[ProviderSession].[ProviderType])))",1,160,159,"Compute Scalar","Compute Scalar","DEFINE:([Expr1076]=(rtrim([BDD].[dbo].[ProviderSession].[NodeName])+N'\\')+rtrim([BDD].[dbo].[ProviderSession].[ProviderType]))","[Expr1076]=(rtrim([BDD].[dbo].[ProviderSession].[NodeName])+N'\\')+rtrim([BDD].[dbo].[ProviderSession].[ProviderType])",1,0,1e-07,1105,0.00657256,"[BDD].[dbo].[Events].[GroupName], [BDD].[dbo].[Events].[TagName], [BDD].[dbo].[Events].[EventPriority], [BDD].[dbo].[Events].[ValueString], [BDD].[dbo].[Events].[LimitString], [BDD].[dbo].[Events].[EventTime], [BDD].[dbo].[Events].[EventTimeFracSec], [BDD].[dbo].[Events].[OperatorNode], [BDD].[dbo].[Events].[OperatorName], [BDD].[dbo].[Events].[User1], [BDD].[dbo].[Events].[User2], [BDD].[dbo].[Events].[User3], [BDD].[dbo].[Events].[OperatorID], [BDD].[dbo].[Events].[EventStamp], [Expr1072], [Expr1073], [Expr1074], [Expr1075], [Expr1076]","NULL","PLAN_ROW",0,1]
["                 |    |--Nested Loops(Inner Join, OUTER REFERENCES:([BDD].[dbo].[Events].[ProviderId]))",1,161,160,"Nested Loops","Inner Join","OUTER REFERENCES:([BDD].[dbo].[Events].[ProviderId])","NULL",1,0,4.18e-06,1085,0.00657246,"[BDD].[dbo].[Events].[GroupName], [BDD].[dbo].[Events].[TagName], [BDD].[dbo].[Events].[EventPriority], [BDD].[dbo].[Events].[ValueString], [BDD].[dbo].[Events].[LimitString], [BDD].[dbo].[Events].[EventTime], [BDD].[dbo].[Events].[EventTimeFracSec], [BDD].[dbo].[Events].[OperatorNode], [BDD].[dbo].[Events].[OperatorName], [BDD].[dbo].[Events].[User1], [BDD].[dbo].[Events].[User2], [BDD].[dbo].[Events].[User3], [BDD].[dbo].[Events].[OperatorID], [BDD].[dbo].[Events].[EventStamp], [BDD].[dbo].[ProviderSession].[NodeName], [BDD].[dbo].[ProviderSession].[ProviderType], [Expr1072], [Expr1073], [Expr1074], [Expr1075]","NULL","PLAN_ROW",0,1]
["                 |         |--Filter(WHERE:([BDD].[dbo].[Events].[GroupName] like N'#M11202%' AND [BDD].[dbo].[Events].[EventStamp]>'2016-03-24 10:50:00.000' AND [BDD].[dbo].[Events].[EventStamp]<'2016-03-25 00:05:00.000' AND [BDD].[dbo].[Events].[EventPriority]=(100)))",1,162,161,"Filter","Filter","WHERE:([BDD].[dbo].[Events].[GroupName] like N'#M11202%' AND [BDD].[dbo].[Events].[EventStamp]>'2016-03-24 10:50:00.000' AND [BDD].[dbo].[Events].[EventStamp]<'2016-03-25 00:05:00.000' AND [BDD].[dbo].[Events].[EventPriority]=(100))","NULL",1,0,1.88e-06,1042,0.00328518,"[BDD].[dbo].[Events].[ProviderId], [BDD].[dbo].[Events].[GroupName], [BDD].[dbo].[Events].[TagName], [BDD].[dbo].[Events].[EventPriority], [BDD].[dbo].[Events].[ValueString], [BDD].[dbo].[Events].[LimitString], [BDD].[dbo].[Events].[EventTime], [BDD].[dbo].[Events].[EventTimeFracSec], [BDD].[dbo].[Events].[OperatorNode], [BDD].[dbo].[Events].[OperatorName], [BDD].[dbo].[Events].[User1], [BDD].[dbo].[Events].[User2], [BDD].[dbo].[Events].[User3], [BDD].[dbo].[Events].[OperatorID], [BDD].[dbo].[Events].[EventStamp], [Expr1072], [Expr1073], [Expr1074], [Expr1075]","NULL","PLAN_ROW",0,1]
["                 |         |    |--Compute Scalar(DEFINE:([BDD].[dbo].[Events].[EventStamp]=[BDD].[dbo].[Events].[EventStamp], [Expr1072]=CONVERT(nvarchar(9),[BDD].[dbo].[Events].[EventState],0), [Expr1073]=CONVERT(nvarchar(255),[BDD].[dbo].[Events].[Comment],0), [Expr1074]=CONVERT(nvarchar(4),[BDD].[dbo].[Events].[EventType],0), [Expr1075]=CONVERT(nvarchar(8),[BDD].[dbo].[Events].[EventClass],0)))",1,163,162,"Compute Scalar","Compute Scalar","DEFINE:([BDD].[dbo].[Events].[EventStamp]=[BDD].[dbo].[Events].[EventStamp], [Expr1072]=CONVERT(nvarchar(9),[BDD].[dbo].[Events].[EventState],0), [Expr1073]=CONVERT(nvarchar(255),[BDD].[dbo].[Events].[Comment],0), [Expr1074]=CONVERT(nvarchar(4),[BDD].[dbo].[Events].[EventType],0), [Expr1075]=CONVERT(nvarchar(8),[BDD].[dbo].[Events].[EventClass],0))","[BDD].[dbo].[Events].[EventStamp]=[BDD].[dbo].[Events].[EventStamp], [Expr1072]=CONVERT(nvarchar(9),[BDD].[dbo].[Events].[EventState],0), [Expr1073]=CONVERT(nvarchar(255),[BDD].[dbo].[Events].[Comment],0), [Expr1074]=CONVERT(nvarchar(4),[BDD].[dbo].[Events].[EventType],0), [Expr1075]=CONVERT(nvarchar(8),[BDD].[dbo].[Events].[EventClass],0)",1,0,1e-07,1042,0.0032833,"[BDD].[dbo].[Events].[ProviderId], [BDD].[dbo].[Events].[GroupName], [BDD].[dbo].[Events].[TagName], [BDD].[dbo].[Events].[EventPriority], [BDD].[dbo].[Events].[ValueString], [BDD].[dbo].[Events].[LimitString], [BDD].[dbo].[Events].[EventTime], [BDD].[dbo].[Events].[EventTimeFracSec], [BDD].[dbo].[Events].[OperatorNode], [BDD].[dbo].[Events].[OperatorName], [BDD].[dbo].[Events].[User1], [BDD].[dbo].[Events].[User2], [BDD].[dbo].[Events].[User3], [BDD].[dbo].[Events].[OperatorID], [BDD].[dbo].[Events].[EventStamp], [Expr1072], [Expr1073], [Expr1074], [Expr1075]","NULL","PLAN_ROW",0,1]
["                 |         |         |--Compute Scalar(DEFINE:([BDD].[dbo].[Events].[EventStamp]=dateadd(minute,CONVERT_IMPLICIT(int,CONVERT_IMPLICIT(numeric(5,0),[BDD].[dbo].[Events].[EventTimeZoneOffset],0)-CONVERT_IMPLICIT(numeric(5,0),[BDD].[dbo].[Events].[EventDaylightAdjustment],0)*(7.5),0),[BDD].[dbo].[Events].[EventTime])))",1,164,163,"Compute Scalar","Compute Scalar","DEFINE:([BDD].[dbo].[Events].[EventStamp]=dateadd(minute,CONVERT_IMPLICIT(int,CONVERT_IMPLICIT(numeric(5,0),[BDD].[dbo].[Events].[EventTimeZoneOffset],0)-CONVERT_IMPLICIT(numeric(5,0),[BDD].[dbo].[Events].[EventDaylightAdjustment],0)*(7.5),0),[BDD].[dbo].[Events].[EventTime]))","[BDD].[dbo].[Events].[EventStamp]=dateadd(minute,CONVERT_IMPLICIT(int,CONVERT_IMPLICIT(numeric(5,0),[BDD].[dbo].[Events].[EventTimeZoneOffset],0)-CONVERT_IMPLICIT(numeric(5,0),[BDD].[dbo].[Events].[EventDaylightAdjustment],0)*(7.5),0),[BDD].[dbo].[Events].[EventTime])",1,0,1e-07,1052,0.0032832,"[BDD].[dbo].[Events].[ProviderId], [BDD].[dbo].[Events].[GroupName], [BDD].[dbo].[Events].[TagName], [BDD].[dbo].[Events].[EventClass], [BDD].[dbo].[Events].[EventType], [BDD].[dbo].[Events].[EventState], [BDD].[dbo].[Events].[EventPriority], [BDD].[dbo].[Events].[ValueString], [BDD].[dbo].[Events].[LimitString], [BDD].[dbo].[Events].[EventTime], [BDD].[dbo].[Events].[EventTimeFracSec], [BDD].[dbo].[Events].[OperatorNode], [BDD].[dbo].[Events].[OperatorName], [BDD].[dbo].[Events].[Comment], [BDD].[dbo].[Events].[User1], [BDD].[dbo].[Events].[User2], [BDD].[dbo].[Events].[User3], [BDD].[dbo].[Events].[OperatorID], [BDD].[dbo].[Events].[EventStamp]","NULL","PLAN_ROW",0,1]
["                 |         |              |--Clustered Index Scan(OBJECT:([BDD].[dbo].[Events].[P_Events]))",1,165,164,"Clustered Index Scan","Clustered Index Scan","OBJECT:([BDD].[dbo].[Events].[P_Events])","[BDD].[dbo].[Events].[ProviderId], [BDD].[dbo].[Events].[GroupName], [BDD].[dbo].[Events].[TagName], [BDD].[dbo].[Events].[EventClass], [BDD].[dbo].[Events].[EventType], [BDD].[dbo].[Events].[EventState], [BDD].[dbo].[Events].[EventPriority], [BDD].[dbo].[Events].[ValueString], [BDD].[dbo].[Events].[LimitString], [BDD].[dbo].[Events].[EventTime], [BDD].[dbo].[Events].[EventTimeFracSec], [BDD].[dbo].[Events].[EventTimeZoneOffset], [BDD].[dbo].[Events].[EventDaylightAdjustment], [BDD].[dbo].[Events].[OperatorNode], [BDD].[dbo].[Events].[OperatorName], [BDD].[dbo].[Events].[Comment], [BDD].[dbo].[Events].[User1], [BDD].[dbo].[Events].[User2], [BDD].[dbo].[Events].[User3], [BDD].[dbo].[Events].[OperatorID]",1,0.003125,0.0001581,1048,0.0032831,"[BDD].[dbo].[Events].[ProviderId], [BDD].[dbo].[Events].[GroupName], [BDD].[dbo].[Events].[TagName], [BDD].[dbo].[Events].[EventClass], [BDD].[dbo].[Events].[EventType], [BDD].[dbo].[Events].[EventState], [BDD].[dbo].[Events].[EventPriority], [BDD].[dbo].[Events].[ValueString], [BDD].[dbo].[Events].[LimitString], [BDD].[dbo].[Events].[EventTime], [BDD].[dbo].[Events].[EventTimeFracSec], [BDD].[dbo].[Events].[EventTimeZoneOffset], [BDD].[dbo].[Events].[EventDaylightAdjustment], [BDD].[dbo].[Events].[OperatorNode], [BDD].[dbo].[Events].[OperatorName], [BDD].[dbo].[Events].[Comment], [BDD].[dbo].[Events].[User1], [BDD].[dbo].[Events].[User2], [BDD].[dbo].[Events].[User3], [BDD].[dbo].[Events].[OperatorID]","NULL","PLAN_ROW",0,1]
["                 |         |--Clustered Index Seek(OBJECT:([BDD].[dbo].[ProviderSession].[P_ProviderSession]), SEEK:([BDD].[dbo].[ProviderSession].[ProviderId]=[BDD].[dbo].[Events].[ProviderId]) ORDERED FORWARD)",1,181,161,"Clustered Index Seek","Clustered Index Seek","OBJECT:([BDD].[dbo].[ProviderSession].[P_ProviderSession]), SEEK:([BDD].[dbo].[ProviderSession].[ProviderId]=[BDD].[dbo].[Events].[ProviderId]) ORDERED FORWARD","[BDD].[dbo].[ProviderSession].[NodeName], [BDD].[dbo].[ProviderSession].[ProviderType]",1,0.003125,0.0001581,56,0.0032831,"[BDD].[dbo].[ProviderSession].[NodeName], [BDD].[dbo].[ProviderSession].[ProviderType]","NULL","PLAN_ROW",0,1]
["                 |--Clustered Index Seek(OBJECT:([BDD].[dbo].[OperatorDetails].[p_OperatorID]), SEEK:([BDD].[dbo].[OperatorDetails].[OperatorID]=[BDD].[dbo].[Events].[OperatorID]) ORDERED FORWARD)",1,185,159,"Clustered Index Seek","Clustered Index Seek","OBJECT:([BDD].[dbo].[OperatorDetails].[p_OperatorID]), SEEK:([BDD].[dbo].[OperatorDetails].[OperatorID]=[BDD].[dbo].[Events].[OperatorID]) ORDERED FORWARD","[BDD].[dbo].[OperatorDetails].[UserDomainName], [BDD].[dbo].[OperatorDetails].[UserFullName]",1,0.003125,0.0001581,47,0.0032831,"[BDD].[dbo].[OperatorDetails].[UserDomainName], [BDD].[dbo].[OperatorDetails].[UserFullName]","NULL","PLAN_ROW",0,1]

{"sheet":"Feuil2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}

{"sheet":"Feuil3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}