Rows Executes StmtText StmtId NodeId Parent PhysicalOp LogicalOp Argument DefinedValues EstimateRows EstimateIO EstimateCPU AvgRowSize TotalSubtreeCost OutputList Warnings Type Parallel EstimateExecutions -------------------- -------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------- ----------- ----------- ------------------------------ ------------------------------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------- ------------- ------------- ----------- ---------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------- ---------------------------------------------------------------- -------- ------------------ 1000 1 SELECT TOP 1000 * FROM T_ENTITES_ent ent INNER JOIN T_DONNEES_SOURCE_dsr dsr ON dsr.dsr_XML.value('(/DONNEES/DIMENSIONS/CODE_ENSEIGNE)[1]','VARCHAR(50)') = ent.ent_XML.value ('(/ENTITE/PARENT)[1]','VARCHAR(50)') 1 1 0 NULL NULL NULL NULL 1 NULL NULL NULL 3698,584 NULL NULL SELECT 0 NULL 1000 1 |--Top(TOP EXPRESSION:((1000))) 1 2 1 Top Top TOP EXPRESSION:((1000)) NULL 1 0 1E-07 8321 3698,584 [ent].[ent_Id], [ent].[ent_IdParent], [ent].[ent_Type], [ent].[ent_Code], [ent].[ent_XML], [ent].[ent_DateInsertion], [ent].[ent_DateMiseAJour], [ent].[ent_StatutEnregistrement], [dsr].[dsr_Id], [dsr].[dsr_CleMD5], [dsr].[dsr_Nom], [dsr].[dsr_XML], [dsr].[ NULL PLAN_ROW 0 1 1000 1 |--Nested Loops(Inner Join, OUTER REFERENCES:([dsr].[dsr_Id], [Expr1035]) OPTIMIZED) 1 3 2 Nested Loops Inner Join OUTER REFERENCES:([dsr].[dsr_Id], [Expr1035]) OPTIMIZED NULL 1 0 4,18E-06 8321 3698,584 [ent].[ent_Id], [ent].[ent_IdParent], [ent].[ent_Type], [ent].[ent_Code], [ent].[ent_XML], [ent].[ent_DateInsertion], [ent].[ent_DateMiseAJour], [ent].[ent_StatutEnregistrement], [dsr].[dsr_Id], [dsr].[dsr_CleMD5], [dsr].[dsr_Nom], [dsr].[dsr_XML], [dsr].[ NULL PLAN_ROW 0 1 126091 1 |--Nested Loops(Inner Join, OUTER REFERENCES:([ent].[ent_Id])) 1 5 3 Nested Loops Inner Join OUTER REFERENCES:([ent].[ent_Id]) NULL 1 0 4,18E-06 8349 3698,581 [ent].[ent_Id], [ent].[ent_IdParent], [ent].[ent_Type], [ent].[ent_Code], [ent].[ent_XML], [ent].[ent_DateInsertion], [ent].[ent_DateMiseAJour], [ent].[ent_StatutEnregistrement], [dsr].[dsr_Id], [dsr].[dsr_CleMD5], [dsr].[dsr_Nom], [dsr].[dsr_XML], [dsr].[ NULL PLAN_ROW 0 1 126091 1 | |--Hash Match(Inner Join, HASH:([Expr1019])=([Expr1011]), RESIDUAL:([Expr1011]=[Expr1019])) 1 6 5 Hash Match Inner Join HASH:([Expr1019])=([Expr1011]), RESIDUAL:([Expr1011]=[Expr1019]) NULL 1 0 1514,481 8321 3698,577 [ent].[ent_Id], [ent].[ent_IdParent], [ent].[ent_Type], [ent].[ent_Code], [ent].[ent_XML], [ent].[ent_DateInsertion], [ent].[ent_DateMiseAJour], [ent].[ent_StatutEnregistrement], [dsr].[dsr_Id], [dsr].[dsr_CleMD5], [dsr].[dsr_Nom], [dsr].[dsr_XML], [dsr].[ NULL PLAN_ROW 0 1 6293 1 | | |--Nested Loops(Inner Join, OUTER REFERENCES:([ent].[ent_Id], [Expr1048]) WITH UNORDERED PREFETCH) 1 7 6 Nested Loops Inner Join OUTER REFERENCES:([ent].[ent_Id], [Expr1048]) WITH UNORDERED PREFETCH NULL 6293,591 0 0,02630721 4122 3,474282 [ent].[ent_Id], [ent].[ent_IdParent], [ent].[ent_Type], [ent].[ent_Code], [ent].[ent_XML], [ent].[ent_DateInsertion], [ent].[ent_DateMiseAJour], [ent].[ent_StatutEnregistrement], [Expr1019] NULL PLAN_ROW 0 1 6293 1 | | | |--Clustered Index Scan(OBJECT:([DB_REP_v3].[dbo].[T_ENTITES_ent].[PK_T_ENTITES_ent] AS [ent]), WHERE:([DB_REP_v3].[dbo].[T_ENTITES_ent].[ent_Type] as [ent].[ent_Type]='MAGASIN')) 1 9 7 Clustered Index Scan Clustered Index Scan OBJECT:([DB_REP_v3].[dbo].[T_ENTITES_ent].[PK_T_ENTITES_ent] AS [ent]), WHERE:([DB_REP_v3].[dbo].[T_ENTITES_ent].[ent_Type] as [ent].[ent_Type]='MAGASIN') [ent].[ent_Id], [ent].[ent_IdParent], [ent].[ent_Type], [ent].[ent_Code], [ent].[ent_XML], [ent].[ent_DateInsertion], [ent].[ent_DateMiseAJour], [ent].[ent_StatutEnregistrement] 6293,591 0,426088 0,00712 4094 0,433208 [ent].[ent_Id], [ent].[ent_IdParent], [ent].[ent_Type], [ent].[ent_Code], [ent].[ent_XML], [ent].[ent_DateInsertion], [ent].[ent_DateMiseAJour], [ent].[ent_StatutEnregistrement] NULL PLAN_ROW 0 1 6293 6293 | | | |--Stream Aggregate(DEFINE:([Expr1019]=MIN([Expr1036]))) 1 10 7 Stream Aggregate Aggregate NULL [Expr1019]=MIN([Expr1036]) 1 0 1,1E-06 36 3,011728 [Expr1019] NULL PLAN_ROW 0 6293,591 6293 6293 | | | |--Top(TOP EXPRESSION:((1))) 1 11 10 Top Top TOP EXPRESSION:((1)) NULL 1 0 1E-07 36 3,004805 [Expr1036] NULL PLAN_ROW 0 6293,591 0 0 | | | |--Compute Scalar(DEFINE:([Expr1018]=0x58)) 1 12 11 Compute Scalar Compute Scalar DEFINE:([Expr1018]=0x58) [Expr1018]=0x58 1 0 1E-07 500 3,004176 [PARENT:1].[id], [PARENT:1].[pk1], [Expr1018], [Expr1036] NULL PLAN_ROW 0 6293,591 0 0 | | | |--Compute Scalar(DEFINE:([Expr1036]=CASE WHEN datalength([DB_REP_v3].[sys].[xml_index_nodes_1701581100_256000].[value] as [PARENT:1].[value])>=(128) THEN CONVERT_IMPLICIT(varchar(50),[DB_REP_v3].[sys].[xml_index_n 1 13 12 Compute Scalar Compute Scalar DEFINE:([Expr1036]=CASE WHEN datalength([DB_REP_v3].[sys].[xml_index_nodes_1701581100_256000].[value] as [PARENT:1].[value])>=(128) THEN CONVERT_IMPLICIT(varchar(50),[DB_REP_v3].[sys].[xml_index_nodes_1701581100_256000].[lvalue] as [PARENT:1].[lvalue],0) E [Expr1036]=CASE WHEN datalength([DB_REP_v3].[sys].[xml_index_nodes_1701581100_256000].[value] as [PARENT:1].[value])>=(128) THEN CONVERT_IMPLICIT(varchar(50),[DB_REP_v3].[sys].[xml_index_nodes_1701581100_256000].[lvalue] as [PARENT:1].[lvalue],0) ELSE CONV 1 0 1E-07 48 3,003546 [PARENT:1].[id], [PARENT:1].[pk1], [Expr1036] NULL PLAN_ROW 0 6293,591 6293 6293 | | | |--Clustered Index Seek(OBJECT:([DB_REP_v3].[sys].[xml_index_nodes_1701581100_256000].[IDX_XML_PRIMAIRE] AS [PARENT:1]), SEEK:([PARENT:1].[pk1]=[DB_REP_v3].[dbo].[T_ENTITES_ent].[ent_Id] as [ent].[ent_Id]), W 1 14 13 Clustered Index Seek Clustered Index Seek OBJECT:([DB_REP_v3].[sys].[xml_index_nodes_1701581100_256000].[IDX_XML_PRIMAIRE] AS [PARENT:1]), SEEK:([PARENT:1].[pk1]=[DB_REP_v3].[dbo].[T_ENTITES_ent].[ent_Id] as [ent].[ent_Id]), WHERE:([DB_REP_v3].[sys].[xml_index_nodes_1701581100_256000].[hid] as [P [PARENT:1].[id], [PARENT:1].[value], [PARENT:1].[lvalue], [PARENT:1].[hid], [PARENT:1].[pk1] 1 0,003125 0,0001679807 4079 2,972761 [PARENT:1].[id], [PARENT:1].[value], [PARENT:1].[lvalue], [PARENT:1].[hid], [PARENT:1].[pk1] NULL PLAN_ROW 0 6293,591 1001 1 | | |--Nested Loops(Inner Join, OUTER REFERENCES:([dsr].[dsr_Id], [Expr1049]) WITH UNORDERED PREFETCH) 1 25 6 Nested Loops Inner Join OUTER REFERENCES:([dsr].[dsr_Id], [Expr1049]) WITH UNORDERED PREFETCH NULL 947551 0 3,960763 4263 2180,622 [dsr].[dsr_Id], [dsr].[dsr_CleMD5], [dsr].[dsr_Nom], [dsr].[dsr_XML], [dsr].[dsr_FlagATraiter], [dsr].[dsr_DateInsertion], [dsr].[dsr_DateMiseAJour], [dsr].[dsr_StatutEnregistrement], [Expr1011] NULL PLAN_ROW 0 1 1001 1 | | |--Clustered Index Scan(OBJECT:([DB_REP_v3].[dbo].[T_DONNEES_SOURCE_dsr].[PK_T_DONNEES_SOURCE_dsr] AS [dsr])) 1 27 25 Clustered Index Scan Clustered Index Scan OBJECT:([DB_REP_v3].[dbo].[T_DONNEES_SOURCE_dsr].[PK_T_DONNEES_SOURCE_dsr] AS [dsr]) [dsr].[dsr_Id], [dsr].[dsr_CleMD5], [dsr].[dsr_Nom], [dsr].[dsr_XML], [dsr].[dsr_FlagATraiter], [dsr].[dsr_DateInsertion], [dsr].[dsr_DateMiseAJour], [dsr].[dsr_StatutEnregistrement] 947551 66,37646 1,042463 4235 67,41892 [dsr].[dsr_Id], [dsr].[dsr_CleMD5], [dsr].[dsr_Nom], [dsr].[dsr_XML], [dsr].[dsr_FlagATraiter], [dsr].[dsr_DateInsertion], [dsr].[dsr_DateMiseAJour], [dsr].[dsr_StatutEnregistrement] NULL PLAN_ROW 0 1 1001 1001 | | |--Stream Aggregate(DEFINE:([Expr1011]=MIN([Expr1038]))) 1 28 25 Stream Aggregate Aggregate NULL [Expr1011]=MIN([Expr1038]) 1 0 1,1E-06 36 2109,242 [Expr1011] NULL PLAN_ROW 0 947551 1001 1001 | | |--Top(TOP EXPRESSION:((1))) 1 29 28 Top Top TOP EXPRESSION:((1)) NULL 1 0 1E-07 36 2108,2 [Expr1038] NULL PLAN_ROW 0 947551 0 0 | | |--Compute Scalar(DEFINE:([Expr1010]=0x58)) 1 30 29 Compute Scalar Compute Scalar DEFINE:([Expr1010]=0x58) [Expr1010]=0x58 1 0 1,180847E-07 500 2108,105 [CODE_ENSEIGNE:1].[id], [CODE_ENSEIGNE:1].[pk1], [Expr1010], [Expr1038] NULL PLAN_ROW 0 947551 0 0 | | |--Compute Scalar(DEFINE:([Expr1038]=CASE WHEN datalength([DB_REP_v3].[sys].[xml_index_nodes_898102240_256000].[value] as [CODE_ENSEIGNE:1].[value])>=(128) THEN CONVERT_IMPLICIT(varchar(50),[DB_REP_v3].[sys].[xml_i 1 31 30 Compute Scalar Compute Scalar DEFINE:([Expr1038]=CASE WHEN datalength([DB_REP_v3].[sys].[xml_index_nodes_898102240_256000].[value] as [CODE_ENSEIGNE:1].[value])>=(128) THEN CONVERT_IMPLICIT(varchar(50),[DB_REP_v3].[sys].[xml_index_nodes_898102240_256000].[lvalue] as [CODE_ENSEIGNE:1].[ [Expr1038]=CASE WHEN datalength([DB_REP_v3].[sys].[xml_index_nodes_898102240_256000].[value] as [CODE_ENSEIGNE:1].[value])>=(128) THEN CONVERT_IMPLICIT(varchar(50),[DB_REP_v3].[sys].[xml_index_nodes_898102240_256000].[lvalue] as [CODE_ENSEIGNE:1].[lvalue], 1 0 1,180847E-07 48 2108,01 [CODE_ENSEIGNE:1].[id], [CODE_ENSEIGNE:1].[pk1], [Expr1038] NULL PLAN_ROW 0 947551 1001 1001 | | |--Clustered Index Seek(OBJECT:([DB_REP_v3].[sys].[xml_index_nodes_898102240_256000].[IDX_XML_PRIMAIRE] AS [CODE_ENSEIGNE:1]), SEEK:([CODE_ENSEIGNE:1].[pk1]=[DB_REP_v3].[dbo].[T_DONNEES_SOURCE_dsr].[dsr_Id] as 1 32 31 Clustered Index Seek Clustered Index Seek OBJECT:([DB_REP_v3].[sys].[xml_index_nodes_898102240_256000].[IDX_XML_PRIMAIRE] AS [CODE_ENSEIGNE:1]), SEEK:([CODE_ENSEIGNE:1].[pk1]=[DB_REP_v3].[dbo].[T_DONNEES_SOURCE_dsr].[dsr_Id] as [dsr].[dsr_Id]), WHERE:([DB_REP_v3].[sys].[xml_index_nodes_898102240_ [CODE_ENSEIGNE:1].[id], [CODE_ENSEIGNE:1].[value], [CODE_ENSEIGNE:1].[lvalue], [CODE_ENSEIGNE:1].[hid], [CODE_ENSEIGNE:1].[pk1] 1 0,003125 0,0001699578 4077 2103,378 [CODE_ENSEIGNE:1].[id], [CODE_ENSEIGNE:1].[value], [CODE_ENSEIGNE:1].[lvalue], [CODE_ENSEIGNE:1].[hid], [CODE_ENSEIGNE:1].[pk1] NULL PLAN_ROW 0 947551 126091 126091 | |--Stream Aggregate(DEFINE:([Expr1035]=MIN([Expr1037]))) 1 44 5 Stream Aggregate Aggregate NULL [Expr1035]=MIN([Expr1037]) 1 0 1,1E-06 36 0,003299172 [Expr1035] NULL PLAN_ROW 0 1 126091 126091 | |--Top(TOP EXPRESSION:((1))) 1 45 44 Top Top TOP EXPRESSION:((1)) NULL 1 0 1E-07 36 0,003298072 [Expr1037] NULL PLAN_ROW 0 1 0 0 | |--Compute Scalar(DEFINE:([Expr1034]=0x58)) 1 46 45 Compute Scalar Compute Scalar DEFINE:([Expr1034]=0x58) [Expr1034]=0x58 1 0 1E-07 948 0,003297972 [CODE:1].[id], [CODE:1].[pk1], [Expr1034], [Expr1037] NULL PLAN_ROW 0 1 0 0 | |--Compute Scalar(DEFINE:([Expr1037]=CASE WHEN datalength([DB_REP_v3].[sys].[xml_index_nodes_1701581100_256000].[value] as [CODE:1].[value])>=(128) THEN CONVERT_IMPLICIT(varchar(50),[DB_REP_v3].[sys].[xml_index_nodes_1701581 1 47 46 Compute Scalar Compute Scalar DEFINE:([Expr1037]=CASE WHEN datalength([DB_REP_v3].[sys].[xml_index_nodes_1701581100_256000].[value] as [CODE:1].[value])>=(128) THEN CONVERT_IMPLICIT(varchar(50),[DB_REP_v3].[sys].[xml_index_nodes_1701581100_256000].[lvalue] as [CODE:1].[lvalue],0) ELSE [Expr1037]=CASE WHEN datalength([DB_REP_v3].[sys].[xml_index_nodes_1701581100_256000].[value] as [CODE:1].[value])>=(128) THEN CONVERT_IMPLICIT(varchar(50),[DB_REP_v3].[sys].[xml_index_nodes_1701581100_256000].[lvalue] as [CODE:1].[lvalue],0) ELSE CONVERT_ 1 0 1E-07 496 0,003297872 [CODE:1].[id], [CODE:1].[pk1], [Expr1037] NULL PLAN_ROW 0 1 126091 126091 | |--Clustered Index Seek(OBJECT:([DB_REP_v3].[sys].[xml_index_nodes_1701581100_256000].[IDX_XML_PRIMAIRE] AS [CODE:1]), SEEK:([CODE:1].[pk1]=[DB_REP_v3].[dbo].[T_ENTITES_ent].[ent_Id] as [ent].[ent_Id]), WHERE:([DB_REP_ 1 48 47 Clustered Index Seek Clustered Index Seek OBJECT:([DB_REP_v3].[sys].[xml_index_nodes_1701581100_256000].[IDX_XML_PRIMAIRE] AS [CODE:1]), SEEK:([CODE:1].[pk1]=[DB_REP_v3].[dbo].[T_ENTITES_ent].[ent_Id] as [ent].[ent_Id]), WHERE:([DB_REP_v3].[sys].[xml_index_nodes_1701581100_256000].[hid] as [CODE: [CODE:1].[id], [CODE:1].[value], [CODE:1].[lvalue], [CODE:1].[hid], [CODE:1].[pk1] 1 0,003125 0,0001679807 4527 0,003292981 [CODE:1].[id], [CODE:1].[value], [CODE:1].[lvalue], [CODE:1].[hid], [CODE:1].[pk1] NULL PLAN_ROW 0 1 1000 125923 |--Filter(WHERE:([Expr1035]=[Expr1027])) 1 59 3 Filter Filter WHERE:([Expr1035]=[Expr1027]) NULL 1 0 4,8E-07 9 0,003301397 NULL NULL PLAN_ROW 0 1 125923 125923 |--Stream Aggregate(DEFINE:([Expr1027]=MIN([Expr1039]))) 1 60 59 Stream Aggregate Aggregate NULL [Expr1027]=MIN([Expr1039]) 1 0 1,1E-06 36 0,003300917 [Expr1027] NULL PLAN_ROW 0 1 125923 125923 |--Top(TOP EXPRESSION:((1))) 1 61 60 Top Top TOP EXPRESSION:((1)) NULL 1 0 1E-07 36 0,003299817 [Expr1039] NULL PLAN_ROW 0 1 0 0 |--Compute Scalar(DEFINE:([Expr1026]=0x58)) 1 62 61 Compute Scalar Compute Scalar DEFINE:([Expr1026]=0x58) [Expr1026]=0x58 1 0 1,06254E-07 948 0,003299717 [CODE_MAGASIN:1].[id], [CODE_MAGASIN:1].[pk1], [Expr1026], [Expr1039] NULL PLAN_ROW 0 1 0 0 |--Compute Scalar(DEFINE:([Expr1039]=CASE WHEN datalength([DB_REP_v3].[sys].[xml_index_nodes_898102240_256000].[value] as [CODE_MAGASIN:1].[value])>=(128) THEN CONVERT_IMPLICIT(varchar(50),[DB_REP_v3].[sys].[xml_index_nodes_ 1 63 62 Compute Scalar Compute Scalar DEFINE:([Expr1039]=CASE WHEN datalength([DB_REP_v3].[sys].[xml_index_nodes_898102240_256000].[value] as [CODE_MAGASIN:1].[value])>=(128) THEN CONVERT_IMPLICIT(varchar(50),[DB_REP_v3].[sys].[xml_index_nodes_898102240_256000].[lvalue] as [CODE_MAGASIN:1].[lv [Expr1039]=CASE WHEN datalength([DB_REP_v3].[sys].[xml_index_nodes_898102240_256000].[value] as [CODE_MAGASIN:1].[value])>=(128) THEN CONVERT_IMPLICIT(varchar(50),[DB_REP_v3].[sys].[xml_index_nodes_898102240_256000].[lvalue] as [CODE_MAGASIN:1].[lvalue],0) 1 0 1,06254E-07 496 0,003299617 [CODE_MAGASIN:1].[id], [CODE_MAGASIN:1].[pk1], [Expr1039] NULL PLAN_ROW 0 1 125923 125923 |--Clustered Index Seek(OBJECT:([DB_REP_v3].[sys].[xml_index_nodes_898102240_256000].[IDX_XML_PRIMAIRE] AS [CODE_MAGASIN:1]), SEEK:([CODE_MAGASIN:1].[pk1]=[DB_REP_v3].[dbo].[T_DONNEES_SOURCE_dsr].[dsr_Id] as [dsr].[dsr_ 1 64 63 Clustered Index Seek Clustered Index Seek OBJECT:([DB_REP_v3].[sys].[xml_index_nodes_898102240_256000].[IDX_XML_PRIMAIRE] AS [CODE_MAGASIN:1]), SEEK:([CODE_MAGASIN:1].[pk1]=[DB_REP_v3].[dbo].[T_DONNEES_SOURCE_dsr].[dsr_Id] as [dsr].[dsr_Id]), WHERE:([DB_REP_v3].[sys].[xml_index_nodes_898102240_25 [CODE_MAGASIN:1].[id], [CODE_MAGASIN:1].[value], [CODE_MAGASIN:1].[lvalue], [CODE_MAGASIN:1].[hid], [CODE_MAGASIN:1].[pk1] 1 0,003125 0,0001699578 4525 0,003294195 [CODE_MAGASIN:1].[id], [CODE_MAGASIN:1].[value], [CODE_MAGASIN:1].[lvalue], [CODE_MAGASIN:1].[hid], [CODE_MAGASIN:1].[pk1] NULL PLAN_ROW 0 1