Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?xml version="1.0" encoding="utf-16"?>
- <ShowPlanXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="1.539" Build="15.0.4335.1" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
- <BatchSequence>
- <Batch>
- <Statements>
- <StmtSimple StatementCompId="1" StatementEstRows="2.15775E+15" StatementId="1" StatementOptmLevel="FULL" CardinalityEstimationModelVersion="70" StatementSubTreeCost="254622000" StatementText="select * from [dbo].[vw_balanco_detalhado] where numerosine = 38358" StatementType="SELECT" ParameterizedText="(@0 int)select * from [dbo] . [vw_balanco_detalhado] where numerosine = @0" QueryHash="0x72A1596173A1CEF4" QueryPlanHash="0x9004F85993ACB175" RetrievedFromCache="true" SecurityPolicyApplied="false">
- <StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" />
- <QueryPlan CachedPlanSize="392" CompileTime="2415" CompileCPU="816" CompileMemory="15992">
- <MemoryGrantInfo SerialRequiredMemory="1664" SerialDesiredMemory="2830480" GrantedMemory="0" MaxUsedMemory="0" />
- <OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="1118481" EstimatedPagesCached="209715" EstimatedAvailableDegreeOfParallelism="2" MaxCompileMemory="16496176" />
- <RelOp AvgRowSize="1526" EstimateCPU="252845000" EstimateIO="0.944938" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="2.15775E+15" LogicalOp="Left Outer Join" NodeId="0" Parallel="false" PhysicalOp="Merge Join" EstimatedTotalSubtreeCost="254622000">
- <OutputList>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="Id" />
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="NumeroSine" />
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="Year" />
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="NIF" />
- <ColumnReference Column="Expr1005" />
- <ColumnReference Column="Expr1006" />
- <ColumnReference Column="Expr1007" />
- <ColumnReference Column="Expr1008" />
- <ColumnReference Column="Expr1009" />
- <ColumnReference Column="Expr1010" />
- <ColumnReference Column="Expr1011" />
- <ColumnReference Column="Expr1012" />
- <ColumnReference Column="Expr1013" />
- <ColumnReference Column="Expr1014" />
- <ColumnReference Column="Expr1015" />
- <ColumnReference Column="Expr1016" />
- <ColumnReference Column="Expr1019" />
- <ColumnReference Column="Expr1020" />
- <ColumnReference Column="Expr1021" />
- <ColumnReference Column="Expr1022" />
- <ColumnReference Column="Expr1023" />
- <ColumnReference Column="Expr1024" />
- <ColumnReference Column="Expr1025" />
- <ColumnReference Column="Expr1026" />
- <ColumnReference Column="Expr1027" />
- <ColumnReference Column="Expr1028" />
- <ColumnReference Column="Expr1029" />
- <ColumnReference Column="Expr1030" />
- <ColumnReference Column="Expr1031" />
- <ColumnReference Column="Expr1032" />
- <ColumnReference Column="Expr1036" />
- <ColumnReference Column="Expr1040" />
- <ColumnReference Column="Expr1041" />
- <ColumnReference Column="Expr1042" />
- <ColumnReference Column="Expr1043" />
- <ColumnReference Column="Expr1044" />
- <ColumnReference Column="Expr1045" />
- <ColumnReference Column="Expr1046" />
- <ColumnReference Column="Expr1047" />
- <ColumnReference Column="Expr1048" />
- <ColumnReference Column="Expr1049" />
- <ColumnReference Column="Expr1050" />
- <ColumnReference Column="Expr1051" />
- <ColumnReference Column="Expr1052" />
- <ColumnReference Column="Expr1053" />
- <ColumnReference Column="Expr1057" />
- <ColumnReference Column="Expr1058" />
- <ColumnReference Column="Expr1059" />
- <ColumnReference Column="Expr1060" />
- <ColumnReference Column="Expr1061" />
- <ColumnReference Column="Expr1062" />
- <ColumnReference Column="Expr1066" />
- <ColumnReference Column="Expr1067" />
- <ColumnReference Column="Expr1068" />
- <ColumnReference Column="Expr1069" />
- <ColumnReference Column="Expr1070" />
- <ColumnReference Column="Expr1071" />
- <ColumnReference Column="Expr1072" />
- <ColumnReference Column="Expr1073" />
- <ColumnReference Column="Expr1074" />
- <ColumnReference Column="Expr1075" />
- <ColumnReference Column="Expr1076" />
- <ColumnReference Column="Expr1077" />
- <ColumnReference Column="Expr1081" />
- <ColumnReference Column="Expr1085" />
- <ColumnReference Column="Expr1088" />
- <ColumnReference Column="Expr1089" />
- <ColumnReference Column="Expr1090" />
- <ColumnReference Column="Expr1091" />
- <ColumnReference Column="Expr1092" />
- <ColumnReference Column="Expr1093" />
- <ColumnReference Column="Expr1094" />
- <ColumnReference Column="Expr1095" />
- <ColumnReference Column="Expr1096" />
- <ColumnReference Column="Expr1097" />
- <ColumnReference Column="Expr1098" />
- <ColumnReference Column="Expr1099" />
- <ColumnReference Column="Expr1100" />
- <ColumnReference Column="Expr1101" />
- <ColumnReference Column="Expr1102" />
- <ColumnReference Column="Expr1103" />
- <ColumnReference Column="Expr1104" />
- <ColumnReference Column="Expr1105" />
- <ColumnReference Column="Expr1106" />
- <ColumnReference Column="Expr1107" />
- <ColumnReference Column="Expr1108" />
- <ColumnReference Column="Expr1109" />
- <ColumnReference Column="Expr1110" />
- <ColumnReference Column="Expr1111" />
- <ColumnReference Column="Expr1112" />
- <ColumnReference Column="Expr1113" />
- </OutputList>
- <Merge ManyToMany="true">
- <InnerSideJoinColumns>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="BalanceId" />
- </InnerSideJoinColumns>
- <OuterSideJoinColumns>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="Id" />
- </OuterSideJoinColumns>
- <Residual>
- <ScalarOperator ScalarString="[Balance].[dbo].[BalanceModules].[BalanceId] as [f].[BalanceId]=[Balance].[dbo].[Balance].[Id]">
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="BalanceId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="Id" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Residual>
- <RelOp AvgRowSize="1081" EstimateCPU="1759200" EstimateIO="0.457073" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="14977800000000" LogicalOp="Left Outer Join" NodeId="1" Parallel="false" PhysicalOp="Merge Join" EstimatedTotalSubtreeCost="1773980">
- <OutputList>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="Id" />
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="NumeroSine" />
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="Year" />
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="NIF" />
- <ColumnReference Column="Expr1005" />
- <ColumnReference Column="Expr1006" />
- <ColumnReference Column="Expr1007" />
- <ColumnReference Column="Expr1008" />
- <ColumnReference Column="Expr1009" />
- <ColumnReference Column="Expr1010" />
- <ColumnReference Column="Expr1011" />
- <ColumnReference Column="Expr1012" />
- <ColumnReference Column="Expr1013" />
- <ColumnReference Column="Expr1014" />
- <ColumnReference Column="Expr1015" />
- <ColumnReference Column="Expr1016" />
- <ColumnReference Column="Expr1019" />
- <ColumnReference Column="Expr1020" />
- <ColumnReference Column="Expr1021" />
- <ColumnReference Column="Expr1022" />
- <ColumnReference Column="Expr1023" />
- <ColumnReference Column="Expr1024" />
- <ColumnReference Column="Expr1025" />
- <ColumnReference Column="Expr1026" />
- <ColumnReference Column="Expr1027" />
- <ColumnReference Column="Expr1028" />
- <ColumnReference Column="Expr1029" />
- <ColumnReference Column="Expr1030" />
- <ColumnReference Column="Expr1031" />
- <ColumnReference Column="Expr1032" />
- <ColumnReference Column="Expr1036" />
- <ColumnReference Column="Expr1040" />
- <ColumnReference Column="Expr1041" />
- <ColumnReference Column="Expr1042" />
- <ColumnReference Column="Expr1043" />
- <ColumnReference Column="Expr1044" />
- <ColumnReference Column="Expr1045" />
- <ColumnReference Column="Expr1046" />
- <ColumnReference Column="Expr1047" />
- <ColumnReference Column="Expr1048" />
- <ColumnReference Column="Expr1049" />
- <ColumnReference Column="Expr1050" />
- <ColumnReference Column="Expr1051" />
- <ColumnReference Column="Expr1052" />
- <ColumnReference Column="Expr1053" />
- <ColumnReference Column="Expr1057" />
- <ColumnReference Column="Expr1058" />
- <ColumnReference Column="Expr1059" />
- <ColumnReference Column="Expr1060" />
- <ColumnReference Column="Expr1061" />
- <ColumnReference Column="Expr1062" />
- <ColumnReference Column="Expr1066" />
- <ColumnReference Column="Expr1067" />
- <ColumnReference Column="Expr1068" />
- <ColumnReference Column="Expr1069" />
- <ColumnReference Column="Expr1070" />
- <ColumnReference Column="Expr1071" />
- <ColumnReference Column="Expr1072" />
- <ColumnReference Column="Expr1073" />
- <ColumnReference Column="Expr1074" />
- <ColumnReference Column="Expr1075" />
- <ColumnReference Column="Expr1076" />
- <ColumnReference Column="Expr1077" />
- <ColumnReference Column="Expr1081" />
- <ColumnReference Column="Expr1085" />
- </OutputList>
- <Merge ManyToMany="true">
- <InnerSideJoinColumns>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="BalanceId" />
- </InnerSideJoinColumns>
- <OuterSideJoinColumns>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="Id" />
- </OuterSideJoinColumns>
- <Residual>
- <ScalarOperator ScalarString="[Balance].[dbo].[BalanceModules].[BalanceId]=[Balance].[dbo].[Balance].[Id]">
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="BalanceId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="Id" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Residual>
- <RelOp AvgRowSize="1063" EstimateCPU="12458.8" EstimateIO="0.457006" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="105618000000" LogicalOp="Left Outer Join" NodeId="2" Parallel="false" PhysicalOp="Merge Join" EstimatedTotalSubtreeCost="13956">
- <OutputList>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="Id" />
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="NumeroSine" />
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="Year" />
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="NIF" />
- <ColumnReference Column="Expr1005" />
- <ColumnReference Column="Expr1006" />
- <ColumnReference Column="Expr1007" />
- <ColumnReference Column="Expr1008" />
- <ColumnReference Column="Expr1009" />
- <ColumnReference Column="Expr1010" />
- <ColumnReference Column="Expr1011" />
- <ColumnReference Column="Expr1012" />
- <ColumnReference Column="Expr1013" />
- <ColumnReference Column="Expr1014" />
- <ColumnReference Column="Expr1015" />
- <ColumnReference Column="Expr1016" />
- <ColumnReference Column="Expr1019" />
- <ColumnReference Column="Expr1020" />
- <ColumnReference Column="Expr1021" />
- <ColumnReference Column="Expr1022" />
- <ColumnReference Column="Expr1023" />
- <ColumnReference Column="Expr1024" />
- <ColumnReference Column="Expr1025" />
- <ColumnReference Column="Expr1026" />
- <ColumnReference Column="Expr1027" />
- <ColumnReference Column="Expr1028" />
- <ColumnReference Column="Expr1029" />
- <ColumnReference Column="Expr1030" />
- <ColumnReference Column="Expr1031" />
- <ColumnReference Column="Expr1032" />
- <ColumnReference Column="Expr1036" />
- <ColumnReference Column="Expr1040" />
- <ColumnReference Column="Expr1041" />
- <ColumnReference Column="Expr1042" />
- <ColumnReference Column="Expr1043" />
- <ColumnReference Column="Expr1044" />
- <ColumnReference Column="Expr1045" />
- <ColumnReference Column="Expr1046" />
- <ColumnReference Column="Expr1047" />
- <ColumnReference Column="Expr1048" />
- <ColumnReference Column="Expr1049" />
- <ColumnReference Column="Expr1050" />
- <ColumnReference Column="Expr1051" />
- <ColumnReference Column="Expr1052" />
- <ColumnReference Column="Expr1053" />
- <ColumnReference Column="Expr1057" />
- <ColumnReference Column="Expr1058" />
- <ColumnReference Column="Expr1059" />
- <ColumnReference Column="Expr1060" />
- <ColumnReference Column="Expr1061" />
- <ColumnReference Column="Expr1062" />
- <ColumnReference Column="Expr1066" />
- <ColumnReference Column="Expr1067" />
- <ColumnReference Column="Expr1068" />
- <ColumnReference Column="Expr1069" />
- <ColumnReference Column="Expr1070" />
- <ColumnReference Column="Expr1071" />
- <ColumnReference Column="Expr1072" />
- <ColumnReference Column="Expr1073" />
- <ColumnReference Column="Expr1074" />
- <ColumnReference Column="Expr1075" />
- <ColumnReference Column="Expr1076" />
- <ColumnReference Column="Expr1077" />
- <ColumnReference Column="Expr1081" />
- </OutputList>
- <Merge ManyToMany="true">
- <InnerSideJoinColumns>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="BalanceId" />
- </InnerSideJoinColumns>
- <OuterSideJoinColumns>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="Id" />
- </OuterSideJoinColumns>
- <Residual>
- <ScalarOperator ScalarString="[Balance].[dbo].[BalanceModules].[BalanceId]=[Balance].[dbo].[Balance].[Id]">
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="BalanceId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="Id" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Residual>
- <RelOp AvgRowSize="1046" EstimateCPU="24.4613" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="763704000" LogicalOp="Left Outer Join" NodeId="3" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="670.985">
- <OutputList>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="Id" />
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="NumeroSine" />
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="Year" />
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="NIF" />
- <ColumnReference Column="Expr1005" />
- <ColumnReference Column="Expr1006" />
- <ColumnReference Column="Expr1007" />
- <ColumnReference Column="Expr1008" />
- <ColumnReference Column="Expr1009" />
- <ColumnReference Column="Expr1010" />
- <ColumnReference Column="Expr1011" />
- <ColumnReference Column="Expr1012" />
- <ColumnReference Column="Expr1013" />
- <ColumnReference Column="Expr1014" />
- <ColumnReference Column="Expr1015" />
- <ColumnReference Column="Expr1016" />
- <ColumnReference Column="Expr1019" />
- <ColumnReference Column="Expr1020" />
- <ColumnReference Column="Expr1021" />
- <ColumnReference Column="Expr1022" />
- <ColumnReference Column="Expr1023" />
- <ColumnReference Column="Expr1024" />
- <ColumnReference Column="Expr1025" />
- <ColumnReference Column="Expr1026" />
- <ColumnReference Column="Expr1027" />
- <ColumnReference Column="Expr1028" />
- <ColumnReference Column="Expr1029" />
- <ColumnReference Column="Expr1030" />
- <ColumnReference Column="Expr1031" />
- <ColumnReference Column="Expr1032" />
- <ColumnReference Column="Expr1036" />
- <ColumnReference Column="Expr1040" />
- <ColumnReference Column="Expr1041" />
- <ColumnReference Column="Expr1042" />
- <ColumnReference Column="Expr1043" />
- <ColumnReference Column="Expr1044" />
- <ColumnReference Column="Expr1045" />
- <ColumnReference Column="Expr1046" />
- <ColumnReference Column="Expr1047" />
- <ColumnReference Column="Expr1048" />
- <ColumnReference Column="Expr1049" />
- <ColumnReference Column="Expr1050" />
- <ColumnReference Column="Expr1051" />
- <ColumnReference Column="Expr1052" />
- <ColumnReference Column="Expr1053" />
- <ColumnReference Column="Expr1057" />
- <ColumnReference Column="Expr1058" />
- <ColumnReference Column="Expr1059" />
- <ColumnReference Column="Expr1060" />
- <ColumnReference Column="Expr1061" />
- <ColumnReference Column="Expr1062" />
- <ColumnReference Column="Expr1066" />
- <ColumnReference Column="Expr1067" />
- <ColumnReference Column="Expr1068" />
- <ColumnReference Column="Expr1069" />
- <ColumnReference Column="Expr1070" />
- <ColumnReference Column="Expr1071" />
- <ColumnReference Column="Expr1072" />
- <ColumnReference Column="Expr1073" />
- <ColumnReference Column="Expr1074" />
- <ColumnReference Column="Expr1075" />
- <ColumnReference Column="Expr1076" />
- <ColumnReference Column="Expr1077" />
- </OutputList>
- <NestedLoops Optimized="false">
- <OuterReferences>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="Id" />
- </OuterReferences>
- <RelOp AvgRowSize="841" EstimateCPU="0.207021" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="5766200" LogicalOp="Left Outer Join" NodeId="4" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="50.85">
- <OutputList>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="Id" />
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="NumeroSine" />
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="Year" />
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="NIF" />
- <ColumnReference Column="Expr1005" />
- <ColumnReference Column="Expr1006" />
- <ColumnReference Column="Expr1007" />
- <ColumnReference Column="Expr1008" />
- <ColumnReference Column="Expr1009" />
- <ColumnReference Column="Expr1010" />
- <ColumnReference Column="Expr1011" />
- <ColumnReference Column="Expr1012" />
- <ColumnReference Column="Expr1013" />
- <ColumnReference Column="Expr1014" />
- <ColumnReference Column="Expr1015" />
- <ColumnReference Column="Expr1016" />
- <ColumnReference Column="Expr1019" />
- <ColumnReference Column="Expr1020" />
- <ColumnReference Column="Expr1021" />
- <ColumnReference Column="Expr1022" />
- <ColumnReference Column="Expr1023" />
- <ColumnReference Column="Expr1024" />
- <ColumnReference Column="Expr1025" />
- <ColumnReference Column="Expr1026" />
- <ColumnReference Column="Expr1027" />
- <ColumnReference Column="Expr1028" />
- <ColumnReference Column="Expr1029" />
- <ColumnReference Column="Expr1030" />
- <ColumnReference Column="Expr1031" />
- <ColumnReference Column="Expr1032" />
- <ColumnReference Column="Expr1036" />
- <ColumnReference Column="Expr1040" />
- <ColumnReference Column="Expr1041" />
- <ColumnReference Column="Expr1042" />
- <ColumnReference Column="Expr1043" />
- <ColumnReference Column="Expr1044" />
- <ColumnReference Column="Expr1045" />
- <ColumnReference Column="Expr1046" />
- <ColumnReference Column="Expr1047" />
- <ColumnReference Column="Expr1048" />
- <ColumnReference Column="Expr1049" />
- <ColumnReference Column="Expr1050" />
- <ColumnReference Column="Expr1051" />
- <ColumnReference Column="Expr1052" />
- <ColumnReference Column="Expr1053" />
- <ColumnReference Column="Expr1057" />
- <ColumnReference Column="Expr1058" />
- <ColumnReference Column="Expr1059" />
- <ColumnReference Column="Expr1060" />
- <ColumnReference Column="Expr1061" />
- <ColumnReference Column="Expr1062" />
- </OutputList>
- <NestedLoops Optimized="false">
- <OuterReferences>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="Id" />
- </OuterReferences>
- <RelOp AvgRowSize="738" EstimateCPU="0.00874379" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="48800.5" LogicalOp="Left Outer Join" NodeId="5" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="27.6261">
- <OutputList>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="Id" />
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="NumeroSine" />
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="Year" />
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="NIF" />
- <ColumnReference Column="Expr1005" />
- <ColumnReference Column="Expr1006" />
- <ColumnReference Column="Expr1007" />
- <ColumnReference Column="Expr1008" />
- <ColumnReference Column="Expr1009" />
- <ColumnReference Column="Expr1010" />
- <ColumnReference Column="Expr1011" />
- <ColumnReference Column="Expr1012" />
- <ColumnReference Column="Expr1013" />
- <ColumnReference Column="Expr1014" />
- <ColumnReference Column="Expr1015" />
- <ColumnReference Column="Expr1016" />
- <ColumnReference Column="Expr1019" />
- <ColumnReference Column="Expr1020" />
- <ColumnReference Column="Expr1021" />
- <ColumnReference Column="Expr1022" />
- <ColumnReference Column="Expr1023" />
- <ColumnReference Column="Expr1024" />
- <ColumnReference Column="Expr1025" />
- <ColumnReference Column="Expr1026" />
- <ColumnReference Column="Expr1027" />
- <ColumnReference Column="Expr1028" />
- <ColumnReference Column="Expr1029" />
- <ColumnReference Column="Expr1030" />
- <ColumnReference Column="Expr1031" />
- <ColumnReference Column="Expr1032" />
- <ColumnReference Column="Expr1036" />
- <ColumnReference Column="Expr1040" />
- <ColumnReference Column="Expr1041" />
- <ColumnReference Column="Expr1042" />
- <ColumnReference Column="Expr1043" />
- <ColumnReference Column="Expr1044" />
- <ColumnReference Column="Expr1045" />
- <ColumnReference Column="Expr1046" />
- <ColumnReference Column="Expr1047" />
- <ColumnReference Column="Expr1048" />
- <ColumnReference Column="Expr1049" />
- <ColumnReference Column="Expr1050" />
- <ColumnReference Column="Expr1051" />
- <ColumnReference Column="Expr1052" />
- <ColumnReference Column="Expr1053" />
- </OutputList>
- <NestedLoops Optimized="false">
- <OuterReferences>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="Id" />
- </OuterReferences>
- <RelOp AvgRowSize="498" EstimateCPU="0.0062699" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="2061.15" LogicalOp="Left Outer Join" NodeId="6" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="17.8534">
- <OutputList>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="Id" />
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="NumeroSine" />
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="Year" />
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="NIF" />
- <ColumnReference Column="Expr1005" />
- <ColumnReference Column="Expr1006" />
- <ColumnReference Column="Expr1007" />
- <ColumnReference Column="Expr1008" />
- <ColumnReference Column="Expr1009" />
- <ColumnReference Column="Expr1010" />
- <ColumnReference Column="Expr1011" />
- <ColumnReference Column="Expr1012" />
- <ColumnReference Column="Expr1013" />
- <ColumnReference Column="Expr1014" />
- <ColumnReference Column="Expr1015" />
- <ColumnReference Column="Expr1016" />
- <ColumnReference Column="Expr1019" />
- <ColumnReference Column="Expr1020" />
- <ColumnReference Column="Expr1021" />
- <ColumnReference Column="Expr1022" />
- <ColumnReference Column="Expr1023" />
- <ColumnReference Column="Expr1024" />
- <ColumnReference Column="Expr1025" />
- <ColumnReference Column="Expr1026" />
- <ColumnReference Column="Expr1027" />
- <ColumnReference Column="Expr1028" />
- <ColumnReference Column="Expr1029" />
- <ColumnReference Column="Expr1030" />
- <ColumnReference Column="Expr1031" />
- <ColumnReference Column="Expr1032" />
- <ColumnReference Column="Expr1036" />
- </OutputList>
- <NestedLoops Optimized="false">
- <OuterReferences>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="Id" />
- </OuterReferences>
- <RelOp AvgRowSize="481" EstimateCPU="0.00570719" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1477.99" LogicalOp="Left Outer Join" NodeId="7" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="8.91373">
- <OutputList>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="Id" />
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="NumeroSine" />
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="Year" />
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="NIF" />
- <ColumnReference Column="Expr1005" />
- <ColumnReference Column="Expr1006" />
- <ColumnReference Column="Expr1007" />
- <ColumnReference Column="Expr1008" />
- <ColumnReference Column="Expr1009" />
- <ColumnReference Column="Expr1010" />
- <ColumnReference Column="Expr1011" />
- <ColumnReference Column="Expr1012" />
- <ColumnReference Column="Expr1013" />
- <ColumnReference Column="Expr1014" />
- <ColumnReference Column="Expr1015" />
- <ColumnReference Column="Expr1016" />
- <ColumnReference Column="Expr1019" />
- <ColumnReference Column="Expr1020" />
- <ColumnReference Column="Expr1021" />
- <ColumnReference Column="Expr1022" />
- <ColumnReference Column="Expr1023" />
- <ColumnReference Column="Expr1024" />
- <ColumnReference Column="Expr1025" />
- <ColumnReference Column="Expr1026" />
- <ColumnReference Column="Expr1027" />
- <ColumnReference Column="Expr1028" />
- <ColumnReference Column="Expr1029" />
- <ColumnReference Column="Expr1030" />
- <ColumnReference Column="Expr1031" />
- <ColumnReference Column="Expr1032" />
- </OutputList>
- <NestedLoops Optimized="false">
- <OuterReferences>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="Id" />
- </OuterReferences>
- <RelOp AvgRowSize="276" EstimateCPU="2.81449E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1345.34" LogicalOp="Left Outer Join" NodeId="8" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0523765">
- <OutputList>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="Id" />
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="NumeroSine" />
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="Year" />
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="NIF" />
- <ColumnReference Column="Expr1019" />
- <ColumnReference Column="Expr1020" />
- <ColumnReference Column="Expr1021" />
- <ColumnReference Column="Expr1022" />
- <ColumnReference Column="Expr1023" />
- <ColumnReference Column="Expr1024" />
- <ColumnReference Column="Expr1025" />
- <ColumnReference Column="Expr1026" />
- <ColumnReference Column="Expr1027" />
- <ColumnReference Column="Expr1028" />
- <ColumnReference Column="Expr1029" />
- <ColumnReference Column="Expr1030" />
- <ColumnReference Column="Expr1031" />
- <ColumnReference Column="Expr1032" />
- </OutputList>
- <NestedLoops Optimized="false">
- <OuterReferences>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="Id" />
- </OuterReferences>
- <RelOp AvgRowSize="36" EstimateCPU="0.000128291" EstimateIO="0.0112613" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="6.63452" LogicalOp="Sort" NodeId="9" Parallel="false" PhysicalOp="Sort" EstimatedTotalSubtreeCost="0.0146821">
- <OutputList>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="Id" />
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="NumeroSine" />
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="Year" />
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="NIF" />
- </OutputList>
- <MemoryFractions Input="1" Output="1.13122E-05" />
- <Sort Distinct="false">
- <OrderBy>
- <OrderByColumn Ascending="true">
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="Id" />
- </OrderByColumn>
- </OrderBy>
- <RelOp AvgRowSize="37" EstimateCPU="0.00016435" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="6.63452" EstimatedRowsRead="6.68211" LogicalOp="Index Seek" NodeId="10" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.00328935" TableCardinality="3211270">
- <OutputList>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="Id" />
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="NumeroSine" />
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="Year" />
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="NIF" />
- </OutputList>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="Id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="NumeroSine" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="Year" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="NIF" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[Balance]" Schema="[dbo]" Table="[Balance]" Index="[IX_Balance_Full]" IndexKind="NonClustered" Storage="RowStore" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="NumeroSine" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[@0]">
- <Identifier>
- <ColumnReference Column="@0" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- <Predicate>
- <ScalarOperator ScalarString="[Balance].[dbo].[Balance].[Processed]=(1)">
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="Processed" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(1)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Predicate>
- </IndexScan>
- </RelOp>
- </Sort>
- </RelOp>
- <RelOp AvgRowSize="246" EstimateCPU="1.01488E-07" EstimateIO="0" EstimateRebinds="5.63452" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.01488" LogicalOp="Compute Scalar" NodeId="11" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.0376662">
- <OutputList>
- <ColumnReference Column="Expr1019" />
- <ColumnReference Column="Expr1020" />
- <ColumnReference Column="Expr1021" />
- <ColumnReference Column="Expr1022" />
- <ColumnReference Column="Expr1023" />
- <ColumnReference Column="Expr1024" />
- <ColumnReference Column="Expr1025" />
- <ColumnReference Column="Expr1026" />
- <ColumnReference Column="Expr1027" />
- <ColumnReference Column="Expr1028" />
- <ColumnReference Column="Expr1029" />
- <ColumnReference Column="Expr1030" />
- <ColumnReference Column="Expr1031" />
- <ColumnReference Column="Expr1032" />
- </OutputList>
- <ComputeScalar>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1019" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value] as [f].[Value],N'$.inventarios'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.inventarios'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1020" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value] as [f].[Value],N'$.activosBiologicos'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.activosBiologicos'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1021" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value] as [f].[Value],N'$.clientes'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.clientes'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1022" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value] as [f].[Value],N'$.adiantamentosFornecedores'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.adiantamentosFornecedores'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1023" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value] as [f].[Value],N'$.estadoEntesPublicos'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.estadoEntesPublicos'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1024" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value] as [f].[Value],N'$.accionistasSocios'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.accionistasSocios'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1025" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value] as [f].[Value],N'$.outrasContasAReceber'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.outrasContasAReceber'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1026" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value] as [f].[Value],N'$.diferimentos'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.diferimentos'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1027" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value] as [f].[Value],N'$.afDetidosParaNegociacao'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.afDetidosParaNegociacao'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1028" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value] as [f].[Value],N'$.outrosActivosFinanceiros'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.outrosActivosFinanceiros'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1029" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value] as [f].[Value],N'$.ancDetidosParaVenda'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.ancDetidosParaVenda'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1030" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value] as [f].[Value],N'$.outrosActivosCorrentes'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.outrosActivosCorrentes'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1031" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value] as [f].[Value],N'$.caixaEdepositosBancarios'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.caixaEdepositosBancarios'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1032" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value] as [f].[Value],N'$.total'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.total'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="4035" EstimateCPU="4.24218E-06" EstimateIO="0" EstimateRebinds="5.63452" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.01488" LogicalOp="Inner Join" NodeId="12" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0376656">
- <OutputList>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="Value" />
- </OutputList>
- <NestedLoops Optimized="false">
- <OuterReferences>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="ID" />
- </OuterReferences>
- <RelOp AvgRowSize="11" EstimateCPU="0.000158116" EstimateIO="0.003125" EstimateRebinds="5.63452" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.01488" EstimatedRowsRead="1.01488" LogicalOp="Index Seek" NodeId="13" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0186566" TableCardinality="77026200">
- <OutputList>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="ID" />
- </OutputList>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="ID" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Index="[ix_BalanceId_ModuleId]" Alias="[f]" TableReferenceId="1" IndexKind="NonClustered" Storage="RowStore" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="BalanceId" />
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="ModuleId" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[Balance].[dbo].[Balance].[Id]">
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="Id" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator ScalarString="(2)">
- <Const ConstValue="(2)" />
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- <RelOp AvgRowSize="4035" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="5.73322" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="15" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0189808" TableCardinality="77026200">
- <OutputList>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="Value" />
- </OutputList>
- <IndexScan Lookup="true" Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="Value" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Index="[PK_BalanceModules]" Alias="[f]" TableReferenceId="-1" IndexKind="Clustered" Storage="RowStore" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="ID" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[Balance].[dbo].[BalanceModules].[ID] as [f].[ID]">
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="ID" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- </ComputeScalar>
- </RelOp>
- </NestedLoops>
- </RelOp>
- <RelOp AvgRowSize="212" EstimateCPU="1.01488E-07" EstimateIO="0" EstimateRebinds="1340.42" EstimateRewinds="3.92705" EstimatedExecutionMode="Row" EstimateRows="1.01488" LogicalOp="Compute Scalar" NodeId="16" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="8.85565">
- <OutputList>
- <ColumnReference Column="Expr1005" />
- <ColumnReference Column="Expr1006" />
- <ColumnReference Column="Expr1007" />
- <ColumnReference Column="Expr1008" />
- <ColumnReference Column="Expr1009" />
- <ColumnReference Column="Expr1010" />
- <ColumnReference Column="Expr1011" />
- <ColumnReference Column="Expr1012" />
- <ColumnReference Column="Expr1013" />
- <ColumnReference Column="Expr1014" />
- <ColumnReference Column="Expr1015" />
- <ColumnReference Column="Expr1016" />
- </OutputList>
- <ComputeScalar>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1005" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value],N'$.activosFixosTangiveis'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.activosFixosTangiveis'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1006" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value],N'$.propriedadesDeInvestimento'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.propriedadesDeInvestimento'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1007" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value],N'$.goodwill'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.goodwill'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1008" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value],N'$.activosIntangiveis'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.activosIntangiveis'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1009" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value],N'$.activosBiologicos'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.activosBiologicos'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1010" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value],N'$.pfEquivalenciaPatrimonial'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.pfEquivalenciaPatrimonial'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1011" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value],N'$.pfOutrosMetodos'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.pfOutrosMetodos'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1012" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value],N'$.accionistasSocios'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.accionistasSocios'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1013" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value],N'$.outrosActivosFinanceiros'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.outrosActivosFinanceiros'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1014" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value],N'$.activosImpostosDeferidos'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.activosImpostosDeferidos'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1015" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value],N'$.investimentosFinanceiros'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.investimentosFinanceiros'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1016" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value],N'$.total'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.total'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="4035" EstimateCPU="4.24218E-06" EstimateIO="0" EstimateRebinds="1340.42" EstimateRewinds="3.92705" EstimatedExecutionMode="Row" EstimateRows="1.01488" LogicalOp="Inner Join" NodeId="17" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="8.85551">
- <OutputList>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </OutputList>
- <NestedLoops Optimized="false">
- <OuterReferences>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="ID" />
- </OuterReferences>
- <RelOp AvgRowSize="11" EstimateCPU="0.000158116" EstimateIO="0.003125" EstimateRebinds="1340.42" EstimateRewinds="3.92705" EstimatedExecutionMode="Row" EstimateRows="1.01488" EstimatedRowsRead="1.01488" LogicalOp="Index Seek" NodeId="18" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="4.37985" TableCardinality="77026200">
- <OutputList>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="ID" />
- </OutputList>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="ID" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Index="[ix_BalanceId_ModuleId]" TableReferenceId="1" IndexKind="NonClustered" Storage="RowStore" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="BalanceId" />
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="ModuleId" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[Balance].[dbo].[Balance].[Id]">
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="Id" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator ScalarString="(3)">
- <Const ConstValue="(3)" />
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- <RelOp AvgRowSize="4035" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="1364.36" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="20" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="4.46995" TableCardinality="77026200">
- <OutputList>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </OutputList>
- <IndexScan Lookup="true" Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Index="[PK_BalanceModules]" TableReferenceId="-1" IndexKind="Clustered" Storage="RowStore" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="ID" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[Balance].[dbo].[BalanceModules].[ID]">
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="ID" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- </ComputeScalar>
- </RelOp>
- </NestedLoops>
- </RelOp>
- <RelOp AvgRowSize="24" EstimateCPU="1.01488E-07" EstimateIO="0" EstimateRebinds="1345.99" EstimateRewinds="131.001" EstimatedExecutionMode="Row" EstimateRows="1.01488" LogicalOp="Compute Scalar" NodeId="21" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="8.93338">
- <OutputList>
- <ColumnReference Column="Expr1036" />
- </OutputList>
- <ComputeScalar>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1036" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value],N'$.totalActivo'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.totalActivo'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="4035" EstimateCPU="4.24218E-06" EstimateIO="0" EstimateRebinds="1345.99" EstimateRewinds="131.001" EstimatedExecutionMode="Row" EstimateRows="1.01488" LogicalOp="Inner Join" NodeId="22" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="8.93323">
- <OutputList>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </OutputList>
- <NestedLoops Optimized="false">
- <OuterReferences>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="ID" />
- </OuterReferences>
- <RelOp AvgRowSize="11" EstimateCPU="0.000158116" EstimateIO="0.003125" EstimateRebinds="1345.99" EstimateRewinds="131.001" EstimatedExecutionMode="Row" EstimateRows="1.01488" EstimatedRowsRead="1.01488" LogicalOp="Index Seek" NodeId="23" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="4.41806" TableCardinality="77026200">
- <OutputList>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="ID" />
- </OutputList>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="ID" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Index="[ix_BalanceId_ModuleId]" TableReferenceId="2" IndexKind="NonClustered" Storage="RowStore" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="BalanceId" />
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="ModuleId" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[Balance].[dbo].[Balance].[Id]">
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="Id" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator ScalarString="(1)">
- <Const ConstValue="(1)" />
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- <RelOp AvgRowSize="4035" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="1498.98" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="25" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="4.5089" TableCardinality="77026200">
- <OutputList>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </OutputList>
- <IndexScan Lookup="true" Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Index="[PK_BalanceModules]" TableReferenceId="-1" IndexKind="Clustered" Storage="RowStore" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="ID" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[Balance].[dbo].[BalanceModules].[ID]">
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="ID" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- </ComputeScalar>
- </RelOp>
- </NestedLoops>
- </RelOp>
- <RelOp AvgRowSize="246" EstimateCPU="1.01488E-07" EstimateIO="0" EstimateRebinds="1448.54" EstimateRewinds="611.611" EstimatedExecutionMode="Row" EstimateRows="1.01488" LogicalOp="Compute Scalar" NodeId="26" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="9.76395">
- <OutputList>
- <ColumnReference Column="Expr1040" />
- <ColumnReference Column="Expr1041" />
- <ColumnReference Column="Expr1042" />
- <ColumnReference Column="Expr1043" />
- <ColumnReference Column="Expr1044" />
- <ColumnReference Column="Expr1045" />
- <ColumnReference Column="Expr1046" />
- <ColumnReference Column="Expr1047" />
- <ColumnReference Column="Expr1048" />
- <ColumnReference Column="Expr1049" />
- <ColumnReference Column="Expr1050" />
- <ColumnReference Column="Expr1051" />
- <ColumnReference Column="Expr1052" />
- <ColumnReference Column="Expr1053" />
- </OutputList>
- <ComputeScalar>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1040" />
- <ScalarOperator ScalarString="TRY_CAST(json_value([Balance].[dbo].[BalanceModules].[Value],N'$.capitalRealizado') AS decimal(38,2))">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.capitalRealizado'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1041" />
- <ScalarOperator ScalarString="TRY_CAST(json_value([Balance].[dbo].[BalanceModules].[Value],N'$.accoesProprias') AS decimal(38,2))">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.accoesProprias'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1042" />
- <ScalarOperator ScalarString="TRY_CAST(json_value([Balance].[dbo].[BalanceModules].[Value],N'$.outrosInstrumentos') AS decimal(38,2))">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.outrosInstrumentos'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1043" />
- <ScalarOperator ScalarString="TRY_CAST(json_value([Balance].[dbo].[BalanceModules].[Value],N'$.premiosEmissao') AS decimal(38,2))">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.premiosEmissao'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1044" />
- <ScalarOperator ScalarString="TRY_CAST(json_value([Balance].[dbo].[BalanceModules].[Value],N'$.reservasLegais') AS decimal(38,2))">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.reservasLegais'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1045" />
- <ScalarOperator ScalarString="TRY_CAST(json_value([Balance].[dbo].[BalanceModules].[Value],N'$.outrasReservas') AS decimal(38,2))">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.outrasReservas'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1046" />
- <ScalarOperator ScalarString="TRY_CAST(json_value([Balance].[dbo].[BalanceModules].[Value],N'$.resultadosTransitados') AS decimal(38,2))">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.resultadosTransitados'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1047" />
- <ScalarOperator ScalarString="TRY_CAST(json_value([Balance].[dbo].[BalanceModules].[Value],N'$.ajustamentosActivosFinanceiros') AS decimal(38,2))">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.ajustamentosActivosFinanceiros'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1048" />
- <ScalarOperator ScalarString="TRY_CAST(json_value([Balance].[dbo].[BalanceModules].[Value],N'$.excedentesRevalorizacao') AS decimal(38,2))">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.excedentesRevalorizacao'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1049" />
- <ScalarOperator ScalarString="TRY_CAST(json_value([Balance].[dbo].[BalanceModules].[Value],N'$.outrasVariacoes') AS decimal(38,2))">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.outrasVariacoes'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1050" />
- <ScalarOperator ScalarString="TRY_CAST(json_value([Balance].[dbo].[BalanceModules].[Value],N'$.soma01') AS decimal(38,2))">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.soma01'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1051" />
- <ScalarOperator ScalarString="TRY_CAST(json_value([Balance].[dbo].[BalanceModules].[Value],N'$.resultadoLiquidoPeriodo') AS decimal(38,2))">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.resultadoLiquidoPeriodo'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1052" />
- <ScalarOperator ScalarString="TRY_CAST(json_value([Balance].[dbo].[BalanceModules].[Value],N'$.dividendosAntecipados') AS decimal(38,2))">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.dividendosAntecipados'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1053" />
- <ScalarOperator ScalarString="TRY_CAST(json_value([Balance].[dbo].[BalanceModules].[Value],N'$.somaTotal') AS decimal(38,2))">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.somaTotal'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="4035" EstimateCPU="4.24218E-06" EstimateIO="0" EstimateRebinds="1448.54" EstimateRewinds="611.611" EstimatedExecutionMode="Row" EstimateRows="1.01488" LogicalOp="Inner Join" NodeId="27" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="9.76374">
- <OutputList>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </OutputList>
- <NestedLoops Optimized="false">
- <OuterReferences>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="ID" />
- </OuterReferences>
- <RelOp AvgRowSize="11" EstimateCPU="0.000158116" EstimateIO="0.003125" EstimateRebinds="1448.54" EstimateRewinds="611.611" EstimatedExecutionMode="Row" EstimateRows="1.01488" EstimatedRowsRead="1.01488" LogicalOp="Index Seek" NodeId="28" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="4.8273" TableCardinality="77026200">
- <OutputList>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="ID" />
- </OutputList>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="ID" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Index="[ix_BalanceId_ModuleId]" TableReferenceId="3" IndexKind="NonClustered" Storage="RowStore" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="BalanceId" />
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="ModuleId" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[Balance].[dbo].[Balance].[Id]">
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="Id" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator ScalarString="(4)">
- <Const ConstValue="(4)" />
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- <RelOp AvgRowSize="4035" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="2090.82" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="30" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="4.9277" TableCardinality="77026200">
- <OutputList>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </OutputList>
- <IndexScan Lookup="true" Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Index="[PK_BalanceModules]" TableReferenceId="-1" IndexKind="Clustered" Storage="RowStore" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="ID" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[Balance].[dbo].[BalanceModules].[ID]">
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="ID" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- </ComputeScalar>
- </RelOp>
- </NestedLoops>
- </RelOp>
- <RelOp AvgRowSize="109" EstimateCPU="0.000100783" EstimateIO="0.01" EstimateRebinds="1458.34" EstimateRewinds="47341.1" EstimatedExecutionMode="Row" EstimateRows="1.01488" LogicalOp="Lazy Spool" NodeId="31" Parallel="false" PhysicalOp="Table Spool" EstimatedTotalSubtreeCost="23.0169">
- <OutputList>
- <ColumnReference Column="Expr1057" />
- <ColumnReference Column="Expr1058" />
- <ColumnReference Column="Expr1059" />
- <ColumnReference Column="Expr1060" />
- <ColumnReference Column="Expr1061" />
- <ColumnReference Column="Expr1062" />
- </OutputList>
- <Spool>
- <RelOp AvgRowSize="109" EstimateCPU="1.01488E-07" EstimateIO="0" EstimateRebinds="1458.34" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.01488" LogicalOp="Compute Scalar" NodeId="32" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="3.53371">
- <OutputList>
- <ColumnReference Column="Expr1057" />
- <ColumnReference Column="Expr1058" />
- <ColumnReference Column="Expr1059" />
- <ColumnReference Column="Expr1060" />
- <ColumnReference Column="Expr1061" />
- <ColumnReference Column="Expr1062" />
- </OutputList>
- <ComputeScalar>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1057" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value],N'$.provisoes'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.provisoes'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1058" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value],N'$.financiamentosObtidos'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.financiamentosObtidos'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1059" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value],N'$.benificiosPosEmprego'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.benificiosPosEmprego'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1060" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value],N'$.passivosImpostosDiferidos'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.passivosImpostosDiferidos'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1061" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value],N'$.outrasContasAPagar'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.outrasContasAPagar'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1062" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value],N'$.total'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.total'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="4035" EstimateCPU="4.24218E-06" EstimateIO="0" EstimateRebinds="1458.34" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.01488" LogicalOp="Inner Join" NodeId="33" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="3.53356">
- <OutputList>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </OutputList>
- <NestedLoops Optimized="false">
- <OuterReferences>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="ID" />
- </OuterReferences>
- <RelOp AvgRowSize="11" EstimateCPU="0.000158116" EstimateIO="0.003125" EstimateRebinds="1458.34" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.01488" EstimatedRowsRead="1.01488" LogicalOp="Index Seek" NodeId="34" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.367099" TableCardinality="77026200">
- <OutputList>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="ID" />
- </OutputList>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="ID" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Index="[ix_BalanceId_ModuleId]" TableReferenceId="4" IndexKind="NonClustered" Storage="RowStore" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="BalanceId" />
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="ModuleId" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[Balance].[dbo].[Balance].[Id]">
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="Id" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator ScalarString="(7)">
- <Const ConstValue="(7)" />
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- <RelOp AvgRowSize="4035" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="1480.05" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="36" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="3.16027" TableCardinality="77026200">
- <OutputList>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </OutputList>
- <IndexScan Lookup="true" Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Index="[PK_BalanceModules]" TableReferenceId="-1" IndexKind="Clustered" Storage="RowStore" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="ID" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[Balance].[dbo].[BalanceModules].[ID]">
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="ID" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- </ComputeScalar>
- </RelOp>
- </Spool>
- </RelOp>
- </NestedLoops>
- </RelOp>
- <RelOp AvgRowSize="212" EstimateCPU="0.000101383" EstimateIO="0.01" EstimateRebinds="1458.77" EstimateRewinds="5764740" EstimatedExecutionMode="Row" EstimateRows="1.01488" LogicalOp="Lazy Spool" NodeId="37" Parallel="false" PhysicalOp="Table Spool" EstimatedTotalSubtreeCost="595.674">
- <OutputList>
- <ColumnReference Column="Expr1066" />
- <ColumnReference Column="Expr1067" />
- <ColumnReference Column="Expr1068" />
- <ColumnReference Column="Expr1069" />
- <ColumnReference Column="Expr1070" />
- <ColumnReference Column="Expr1071" />
- <ColumnReference Column="Expr1072" />
- <ColumnReference Column="Expr1073" />
- <ColumnReference Column="Expr1074" />
- <ColumnReference Column="Expr1075" />
- <ColumnReference Column="Expr1076" />
- <ColumnReference Column="Expr1077" />
- </OutputList>
- <Spool>
- <RelOp AvgRowSize="212" EstimateCPU="1.01488E-07" EstimateIO="0" EstimateRebinds="1458.77" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.01488" LogicalOp="Compute Scalar" NodeId="38" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="3.40147">
- <OutputList>
- <ColumnReference Column="Expr1066" />
- <ColumnReference Column="Expr1067" />
- <ColumnReference Column="Expr1068" />
- <ColumnReference Column="Expr1069" />
- <ColumnReference Column="Expr1070" />
- <ColumnReference Column="Expr1071" />
- <ColumnReference Column="Expr1072" />
- <ColumnReference Column="Expr1073" />
- <ColumnReference Column="Expr1074" />
- <ColumnReference Column="Expr1075" />
- <ColumnReference Column="Expr1076" />
- <ColumnReference Column="Expr1077" />
- </OutputList>
- <ComputeScalar>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1066" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value],N'$.fornecedores'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.fornecedores'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1067" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value],N'$.adiantamentosClientes'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.adiantamentosClientes'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1068" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value],N'$.estadoEntesPublicos'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.estadoEntesPublicos'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1069" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value],N'$.accionistasSocios'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.accionistasSocios'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1070" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value],N'$.financiamentosObtidos'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.financiamentosObtidos'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1071" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value],N'$.outrasContasPagar'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.outrasContasPagar'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1072" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value],N'$.diferimentos'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.diferimentos'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1073" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value],N'$.passivosFinanceirosDetidos'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.passivosFinanceirosDetidos'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1074" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value],N'$.outrosPassivosFinanceiros'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.outrosPassivosFinanceiros'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1075" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value],N'$.passivosNaoDetidos'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.passivosNaoDetidos'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1076" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value],N'$.outrosPassivosCorrente'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.outrosPassivosCorrente'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1077" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value],N'$.total'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.total'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="4035" EstimateCPU="4.24218E-06" EstimateIO="0" EstimateRebinds="1458.77" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.01488" LogicalOp="Inner Join" NodeId="39" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="3.40132">
- <OutputList>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </OutputList>
- <NestedLoops Optimized="false">
- <OuterReferences>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="ID" />
- </OuterReferences>
- <RelOp AvgRowSize="11" EstimateCPU="0.000158116" EstimateIO="0.003125" EstimateRebinds="1458.77" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.01488" EstimatedRowsRead="1.01488" LogicalOp="Index Seek" NodeId="40" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.233938" TableCardinality="77026200">
- <OutputList>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="ID" />
- </OutputList>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="ID" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Index="[ix_BalanceId_ModuleId]" TableReferenceId="5" IndexKind="NonClustered" Storage="RowStore" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="BalanceId" />
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="ModuleId" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[Balance].[dbo].[Balance].[Id]">
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[Balance]" Column="Id" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator ScalarString="(6)">
- <Const ConstValue="(6)" />
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- <RelOp AvgRowSize="4035" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="1480.48" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="42" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="3.16119" TableCardinality="77026200">
- <OutputList>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </OutputList>
- <IndexScan Lookup="true" Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Index="[PK_BalanceModules]" TableReferenceId="-1" IndexKind="Clustered" Storage="RowStore" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="ID" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[Balance].[dbo].[BalanceModules].[ID]">
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="ID" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- </ComputeScalar>
- </RelOp>
- </Spool>
- </RelOp>
- </NestedLoops>
- </RelOp>
- <RelOp AvgRowSize="32" EstimateCPU="318.135" EstimateIO="0.0112613" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3206920" LogicalOp="Sort" NodeId="43" Parallel="false" PhysicalOp="Sort" EstimatedTotalSubtreeCost="825.689">
- <OutputList>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="BalanceId" />
- <ColumnReference Column="Expr1081" />
- </OutputList>
- <MemoryFractions Input="0.111843" Output="0.111843" />
- <Sort Distinct="false">
- <OrderBy>
- <OrderByColumn Ascending="true">
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="BalanceId" />
- </OrderByColumn>
- </OrderBy>
- <RelOp AvgRowSize="32" EstimateCPU="0.320692" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3206920" LogicalOp="Compute Scalar" NodeId="44" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="507.543">
- <OutputList>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="BalanceId" />
- <ColumnReference Column="Expr1081" />
- </OutputList>
- <ComputeScalar>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1081" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value],N'$.total'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.total'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="4043" EstimateCPU="3.52777" EstimateIO="503.695" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3206920" EstimatedRowsRead="3206920" LogicalOp="Index Seek" NodeId="45" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="507.223" TableCardinality="77026200">
- <OutputList>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="BalanceId" />
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </OutputList>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="BalanceId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Index="[BalanceModules_ModuleId_idx]" TableReferenceId="6" IndexKind="NonClustered" Storage="RowStore" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="ModuleId" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="(5)">
- <Const ConstValue="(5)" />
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </ComputeScalar>
- </RelOp>
- </Sort>
- </RelOp>
- </Merge>
- </RelOp>
- <RelOp AvgRowSize="32" EstimateCPU="318.381" EstimateIO="0.0112613" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3209250" LogicalOp="Sort" NodeId="46" Parallel="false" PhysicalOp="Sort" EstimatedTotalSubtreeCost="826.305">
- <OutputList>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="BalanceId" />
- <ColumnReference Column="Expr1085" />
- </OutputList>
- <MemoryFractions Input="0.111922" Output="0.111922" />
- <Sort Distinct="false">
- <OrderBy>
- <OrderByColumn Ascending="true">
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="BalanceId" />
- </OrderByColumn>
- </OrderBy>
- <RelOp AvgRowSize="32" EstimateCPU="0.320925" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3209250" LogicalOp="Compute Scalar" NodeId="47" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="507.912">
- <OutputList>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="BalanceId" />
- <ColumnReference Column="Expr1085" />
- </OutputList>
- <ComputeScalar>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1085" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value],N'$.total'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.total'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="4043" EstimateCPU="3.53033" EstimateIO="504.061" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3209250" EstimatedRowsRead="3209250" LogicalOp="Index Seek" NodeId="48" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="507.592" TableCardinality="77026200">
- <OutputList>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="BalanceId" />
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </OutputList>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="BalanceId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="Value" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Index="[BalanceModules_ModuleId_idx]" TableReferenceId="7" IndexKind="NonClustered" Storage="RowStore" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Column="ModuleId" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="(8)">
- <Const ConstValue="(8)" />
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </ComputeScalar>
- </RelOp>
- </Sort>
- </RelOp>
- </Merge>
- </RelOp>
- <RelOp AvgRowSize="460" EstimateCPU="66.6431" EstimateIO="2260.08" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3211120" LogicalOp="Sort" NodeId="49" Parallel="false" PhysicalOp="Sort" EstimatedTotalSubtreeCost="2834.93">
- <OutputList>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="BalanceId" />
- <ColumnReference Column="Expr1088" />
- <ColumnReference Column="Expr1089" />
- <ColumnReference Column="Expr1090" />
- <ColumnReference Column="Expr1091" />
- <ColumnReference Column="Expr1092" />
- <ColumnReference Column="Expr1093" />
- <ColumnReference Column="Expr1094" />
- <ColumnReference Column="Expr1095" />
- <ColumnReference Column="Expr1096" />
- <ColumnReference Column="Expr1097" />
- <ColumnReference Column="Expr1098" />
- <ColumnReference Column="Expr1099" />
- <ColumnReference Column="Expr1100" />
- <ColumnReference Column="Expr1101" />
- <ColumnReference Column="Expr1102" />
- <ColumnReference Column="Expr1103" />
- <ColumnReference Column="Expr1104" />
- <ColumnReference Column="Expr1105" />
- <ColumnReference Column="Expr1106" />
- <ColumnReference Column="Expr1107" />
- <ColumnReference Column="Expr1108" />
- <ColumnReference Column="Expr1109" />
- <ColumnReference Column="Expr1110" />
- <ColumnReference Column="Expr1111" />
- <ColumnReference Column="Expr1112" />
- <ColumnReference Column="Expr1113" />
- </OutputList>
- <MemoryFractions Input="0.776223" Output="0.776223" />
- <Sort Distinct="false">
- <OrderBy>
- <OrderByColumn Ascending="true">
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="BalanceId" />
- </OrderByColumn>
- </OrderBy>
- <RelOp AvgRowSize="460" EstimateCPU="0.321112" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3211120" LogicalOp="Compute Scalar" NodeId="50" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="508.208">
- <OutputList>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="BalanceId" />
- <ColumnReference Column="Expr1088" />
- <ColumnReference Column="Expr1089" />
- <ColumnReference Column="Expr1090" />
- <ColumnReference Column="Expr1091" />
- <ColumnReference Column="Expr1092" />
- <ColumnReference Column="Expr1093" />
- <ColumnReference Column="Expr1094" />
- <ColumnReference Column="Expr1095" />
- <ColumnReference Column="Expr1096" />
- <ColumnReference Column="Expr1097" />
- <ColumnReference Column="Expr1098" />
- <ColumnReference Column="Expr1099" />
- <ColumnReference Column="Expr1100" />
- <ColumnReference Column="Expr1101" />
- <ColumnReference Column="Expr1102" />
- <ColumnReference Column="Expr1103" />
- <ColumnReference Column="Expr1104" />
- <ColumnReference Column="Expr1105" />
- <ColumnReference Column="Expr1106" />
- <ColumnReference Column="Expr1107" />
- <ColumnReference Column="Expr1108" />
- <ColumnReference Column="Expr1109" />
- <ColumnReference Column="Expr1110" />
- <ColumnReference Column="Expr1111" />
- <ColumnReference Column="Expr1112" />
- <ColumnReference Column="Expr1113" />
- </OutputList>
- <ComputeScalar>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1088" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value] as [f].[Value],N'$.vendasServicosPrestados'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.vendasServicosPrestados'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1089" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value] as [f].[Value],N'$.subsidiosExploracao'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.subsidiosExploracao'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1090" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value] as [f].[Value],N'$.ganhosPerdasImputados'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.ganhosPerdasImputados'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1091" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value] as [f].[Value],N'$.variacaoInventarios'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.variacaoInventarios'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1092" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value] as [f].[Value],N'$.trabalhosPropriaEntidade'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.trabalhosPropriaEntidade'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1093" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value] as [f].[Value],N'$.custoMercadoriasVendidas'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.custoMercadoriasVendidas'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1094" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value] as [f].[Value],N'$.fornecimentosServicosExternos'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.fornecimentosServicosExternos'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1095" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value] as [f].[Value],N'$.gastosComPessoal'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.gastosComPessoal'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1096" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value] as [f].[Value],N'$.imparidadeInventarios'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.imparidadeInventarios'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1097" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value] as [f].[Value],N'$.imparidadeDividasReceber'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.imparidadeDividasReceber'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1098" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value] as [f].[Value],N'$.provisoes'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.provisoes'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1099" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value] as [f].[Value],N'$.imparidadeInvestimentosNaoDepreciaveis'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.imparidadeInvestimentosNaoDepreciaveis'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1100" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value] as [f].[Value],N'$.outrasImparidades'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.outrasImparidades'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1101" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value] as [f].[Value],N'$.aumentosJustoValor'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.aumentosJustoValor'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1102" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value] as [f].[Value],N'$.outrosRendimentos'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.outrosRendimentos'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1103" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value] as [f].[Value],N'$.outrosGastos'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.outrosGastos'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1104" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value] as [f].[Value],N'$.resultado01'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.resultado01'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1105" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value] as [f].[Value],N'$.gastosReversoes'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.gastosReversoes'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1106" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value] as [f].[Value],N'$.imparidadeInvestimentosDepreciaveis'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.imparidadeInvestimentosDepreciaveis'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1107" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value] as [f].[Value],N'$.resultado02'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.resultado02'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1108" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value] as [f].[Value],N'$.jurosRendimentosSimilares'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.jurosRendimentosSimilares'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1109" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value] as [f].[Value],N'$.jurosGastosSimilares'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.jurosGastosSimilares'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1110" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value] as [f].[Value],N'$.resultado03'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.resultado03'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1111" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value] as [f].[Value],N'$.impostoRendimentoPeriodo'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.impostoRendimentoPeriodo'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1112" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value] as [f].[Value],N'$.resultado04'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.resultado04'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1113" />
- <ScalarOperator ScalarString="CONVERT(decimal(38,2),json_value([Balance].[dbo].[BalanceModules].[Value] as [f].[Value],N'$.resActividadesDescontinuadas'),0)">
- <Convert DataType="decimal" Precision="38" Scale="2" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="json_value">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="Value" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'$.resActividadesDescontinuadas'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="4043" EstimateCPU="3.53239" EstimateIO="504.354" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3211120" EstimatedRowsRead="3211120" LogicalOp="Index Seek" NodeId="51" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="507.887" TableCardinality="77026200">
- <OutputList>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="BalanceId" />
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="Value" />
- </OutputList>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="BalanceId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="Value" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Index="[BalanceModules_ModuleId_idx]" Alias="[f]" TableReferenceId="2" IndexKind="NonClustered" Storage="RowStore" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[Balance]" Schema="[dbo]" Table="[BalanceModules]" Alias="[f]" Column="ModuleId" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="(9)">
- <Const ConstValue="(9)" />
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </ComputeScalar>
- </RelOp>
- </Sort>
- </RelOp>
- </Merge>
- </RelOp>
- <ParameterList>
- <ColumnReference Column="@0" ParameterDataType="int" ParameterCompiledValue="(38358)" />
- </ParameterList>
- </QueryPlan>
- </StmtSimple>
- </Statements>
- </Batch>
- </BatchSequence>
- </ShowPlanXML>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement