https://pastein.ru/t/WF0
Загрузка данных
<?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.4430.1" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
<BatchSequence>
<Batch>
<Statements>
<StmtSimple StatementCompId="24" StatementEstRows="92.5011" StatementId="1" StatementOptmLevel="FULL" StatementOptmEarlyAbortReason="TimeOut" CardinalityEstimationModelVersion="70" StatementSubTreeCost="2522.19" StatementText="SELECT SBranch.SBranchId
 ,qqq.MFormKod AS KodForm
 ,qqq.SCodeLineName AS KodLine
 ,MGrafWork.MGrafWorkNum AS KodGraf
 ,tFormPeriodNew.periodStart AS Period
 ,MONTH(tFormPeriodNew.periodEnd) AS TypePeriod
 ,sum(RMain.RMainValue) AS Number
 FROM (
 SELECT derivedtbl_1.MLineId
 ,derivedtbl_1.MFormId
 ,derivedtbl_1.MFormKod
 ,derivedtbl_1.MTableId
 ,MGrafInfo.MGrafInfoNum
 ,SCodeLine_1.SCodeLineName
 ,ROW_NUMBER() OVER (
 PARTITION BY derivedtbl_1.MFormId
 ,derivedtbl_1.MTableId
 ,derivedtbl_1.MLineId ORDER BY MGrafInfo.MGrafInfoNum
 ) AS Num
 FROM (
 SELECT TOP (100) PERCENT MLine.MLineId
 ,MSection.MFormId
 ,MForm.MFormKod
 ,MTable.MTableId
 FROM MLineInfo
 INNER JOIN MLine ON MLineInfo.MLineId = MLine.MLineId
 INNER JOIN SCodeLine ON MLineInfo.SCodeLineId = SCodeLine.SCodeLineId
 INNER JOIN MTable ON MLine.MTableId = MTable.MTableId
 INNER JOIN MSection ON MTable.MSectionId = MSection.MSectionId
 INNER JOIN MForm ON MSection.MFormId = MForm.MFormId
 GROUP BY MLine.MLineId
 ,MSection.MFormId
 ,MForm.MFormKod
 ,MTable.MTableId
 HAVING (COUNT(SCodeLine.SCodeLineName) = 1)
 ) AS derivedtbl_1
 INNER JOIN MGrafInfo ON derivedtbl_1.MTableId = MGrafInfo.MTableId
 INNER JOIN MLineInfo AS MLineInfo_1 ON MGrafInfo.MGrafInfoId = MLineInfo_1.MGrafInfoId
 AND derivedtbl_1.MLineId = MLineInfo_1.MLineId
 INNER JOIN SCodeLine AS SCodeLine_1 ON MLineInfo_1.SCodeLineId = SCodeLine_1.SCodeLineId
 ) AS qqq
 INNER JOIN MGrafWork ON qqq.MTableId = MGrafWork.MTableId
 INNER JOIN MBoxTable ON qqq.MLineId = MBoxTable.MLineId
 AND MGrafWork.MGrafWorkId = MBoxTable.MGrafWorkId
 INNER JOIN RMain ON MBoxTable.MBoxTableId = RMain.MboxTableId
 INNER JOIN TFormBranch ON TFormBranch.TFormBranchId = RMain.TFormBranchId
 INNER JOIN SBranch ON TFormBranch.SBranchId = SBranch.SBranchId
 INNER JOIN @tFormPeriodNew AS tFormPeriodNew ON qqq.MFormKod = tFormPeriodNew.MFormKod
 AND RMain.RMainPeriod BETWEEN tFormPeriodNew.periodStart
 AND tFormPeriodNew.periodEnd
 AND RMain.RMainTypePeriod = 1
 INNER JOIN @Temp AS tmp ON SBranch.SBranchId = tmp.SBranchId
 AND tmp.MFormKod = tFormPeriodNew.MFormKod
 GROUP BY SBranch.SBranchId
 ,qqq.MFormKod
 ,qqq.SCodeLineName
 ,MGrafWork.MGrafWorkNum
 ,tFormPeriodNew.periodStart
 ,tFormPeriodNew.periodEnd" StatementType="SELECT" QueryHash="0x6605BE55DEA71745" QueryPlanHash="0xF31BFC91BFC34158" RetrievedFromCache="true" StatementSqlHandle="0x0900EC2465C7B1EB5D1E9FB977DFD8503F880000000000000000000000000000000000000000000000000000" DatabaseContextSettingsId="1" ParentObjectId="1485300401" BatchSqlHandle="0x03000800B1E28758512CEF00F8B2000001000000000000000000000000000000000000000000000000000000" StatementParameterizationType="0" SecurityPolicyApplied="false" BatchModeOnRowStoreUsed="true">
<StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="false" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" />
<QueryPlan CachedPlanSize="1120" CompileTime="4666" CompileCPU="4666" CompileMemory="122544">
<ThreadStat Branches="1" />
<MissingIndexes>
<MissingIndexGroup Impact="77.3334">
<MissingIndex Database="[planBD1]" Schema="[dbo]" Table="[RMain]">
<ColumnGroup Usage="EQUALITY">
<Column Name="[RMainTypePeriod]" ColumnId="10" />
</ColumnGroup>
<ColumnGroup Usage="INCLUDE">
<Column Name="[TFormBranchId]" ColumnId="3" />
<Column Name="[MboxTableId]" ColumnId="4" />
<Column Name="[RMainValue]" ColumnId="5" />
</ColumnGroup>
</MissingIndex>
</MissingIndexGroup>
<MissingIndexGroup Impact="99.8547">
<MissingIndex Database="[planBD1]" Schema="[dbo]" Table="[RMain]">
<ColumnGroup Usage="EQUALITY">
<Column Name="[TFormBranchId]" ColumnId="3" />
<Column Name="[RMainTypePeriod]" ColumnId="10" />
</ColumnGroup>
<ColumnGroup Usage="INCLUDE">
<Column Name="[MboxTableId]" ColumnId="4" />
<Column Name="[RMainValue]" ColumnId="5" />
</ColumnGroup>
</MissingIndex>
</MissingIndexGroup>
</MissingIndexes>
<MemoryGrantInfo SerialRequiredMemory="17560" SerialDesiredMemory="304992" GrantedMemory="0" MaxUsedMemory="0" />
<OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="102400" EstimatedPagesCached="204800" EstimatedAvailableDegreeOfParallelism="8" MaxCompileMemory="20487600" />
<RelOp AvgRowSize="45" EstimateCPU="9.25011E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="92.5011" LogicalOp="Compute Scalar" NodeId="0" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="2522.19">
<OutputList>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MForm]" Column="MFormKod" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[SCodeLine]" Alias="[SCodeLine_1]" Column="SCodeLineName" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MGrafWork]" Column="MGrafWorkNum" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[SBranch]" Column="SBranchId" />
<ColumnReference Table="@tFormPeriodNew" Alias="[tFormPeriodNew]" Column="periodStart" />
<ColumnReference Column="Expr1034" />
<ColumnReference Column="Expr1035" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1035" />
<ScalarOperator ScalarString="datepart(month,@tFormPeriodNew.[periodEnd] as [tFormPeriodNew].[periodEnd])">
<Intrinsic FunctionName="datepart">
<ScalarOperator>
<Const ConstValue="(2)" />
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Table="@tFormPeriodNew" Alias="[tFormPeriodNew]" Column="periodEnd" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="44" EstimateCPU="0.000101751" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="92.5011" LogicalOp="Aggregate" NodeId="1" Parallel="false" PhysicalOp="Stream Aggregate" EstimatedTotalSubtreeCost="2522.19">
<OutputList>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MForm]" Column="MFormKod" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[SCodeLine]" Alias="[SCodeLine_1]" Column="SCodeLineName" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MGrafWork]" Column="MGrafWorkNum" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[SBranch]" Column="SBranchId" />
<ColumnReference Table="@tFormPeriodNew" Alias="[tFormPeriodNew]" Column="periodStart" />
<ColumnReference Table="@tFormPeriodNew" Alias="[tFormPeriodNew]" Column="periodEnd" />
<ColumnReference Column="Expr1034" />
</OutputList>
<StreamAggregate>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1034" />
<ScalarOperator ScalarString="SUM([planBD1].[dbo].[RMain].[RMainValue])">
<Aggregate AggType="SUM" Distinct="false">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[RMain]" Column="RMainValue" />
</Identifier>
</ScalarOperator>
</Aggregate>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<GroupBy>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[SBranch]" Column="SBranchId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MForm]" Column="MFormKod" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[SCodeLine]" Alias="[SCodeLine_1]" Column="SCodeLineName" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MGrafWork]" Column="MGrafWorkNum" />
<ColumnReference Table="@tFormPeriodNew" Alias="[tFormPeriodNew]" Column="periodStart" />
<ColumnReference Table="@tFormPeriodNew" Alias="[tFormPeriodNew]" Column="periodEnd" />
</GroupBy>
<RelOp AvgRowSize="48" EstimateCPU="0.0289372" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="92.5011" LogicalOp="Gather Streams" NodeId="2" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="2522.19">
<OutputList>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MForm]" Column="MFormKod" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[SCodeLine]" Alias="[SCodeLine_1]" Column="SCodeLineName" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MGrafWork]" Column="MGrafWorkNum" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[RMain]" Column="RMainValue" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[TFormBranch]" Column="SBranchId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[SBranch]" Column="SBranchId" />
<ColumnReference Table="@tFormPeriodNew" Alias="[tFormPeriodNew]" Column="periodStart" />
<ColumnReference Table="@tFormPeriodNew" Alias="[tFormPeriodNew]" Column="periodEnd" />
</OutputList>
<Parallelism>
<OrderBy>
<OrderByColumn Ascending="true">
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[TFormBranch]" Column="SBranchId" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MForm]" Column="MFormKod" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[SCodeLine]" Alias="[SCodeLine_1]" Column="SCodeLineName" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MGrafWork]" Column="MGrafWorkNum" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Table="@tFormPeriodNew" Alias="[tFormPeriodNew]" Column="periodStart" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Table="@tFormPeriodNew" Alias="[tFormPeriodNew]" Column="periodEnd" />
</OrderByColumn>
</OrderBy>
<RelOp AvgRowSize="48" EstimateCPU="2.42871E-05" EstimateIO="0.000469219" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch" EstimateRows="92.5011" LogicalOp="Sort" NodeId="4" Parallel="true" PhysicalOp="Sort" EstimatedTotalSubtreeCost="2522.16">
<OutputList>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MForm]" Column="MFormKod" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[SCodeLine]" Alias="[SCodeLine_1]" Column="SCodeLineName" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MGrafWork]" Column="MGrafWorkNum" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[RMain]" Column="RMainValue" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[TFormBranch]" Column="SBranchId" />
<ColumnReference Table="@tFormPeriodNew" Alias="[tFormPeriodNew]" Column="periodStart" />
<ColumnReference Table="@tFormPeriodNew" Alias="[tFormPeriodNew]" Column="periodEnd" />
</OutputList>
<MemoryFractions Input="0.231596" Output="0.231596" />
<Sort Distinct="false">
<OrderBy>
<OrderByColumn Ascending="true">
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[TFormBranch]" Column="SBranchId" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MForm]" Column="MFormKod" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[SCodeLine]" Alias="[SCodeLine_1]" Column="SCodeLineName" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MGrafWork]" Column="MGrafWorkNum" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Table="@tFormPeriodNew" Alias="[tFormPeriodNew]" Column="periodStart" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Table="@tFormPeriodNew" Alias="[tFormPeriodNew]" Column="periodEnd" />
</OrderByColumn>
</OrderBy>
<RelOp AvgRowSize="48" EstimateCPU="0.00371571" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch" EstimateRows="92.5011" LogicalOp="Inner Join" NodeId="5" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="2522.16">
<OutputList>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MForm]" Column="MFormKod" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[SCodeLine]" Alias="[SCodeLine_1]" Column="SCodeLineName" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MGrafWork]" Column="MGrafWorkNum" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[RMain]" Column="RMainValue" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[TFormBranch]" Column="SBranchId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[SBranch]" Column="SBranchId" />
<ColumnReference Table="@tFormPeriodNew" Alias="[tFormPeriodNew]" Column="periodStart" />
<ColumnReference Table="@tFormPeriodNew" Alias="[tFormPeriodNew]" Column="periodEnd" />
</OutputList>
<MemoryFractions Input="0.0782933" Output="0.0782933" />
<Hash BitmapCreator="true">
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Opt_Bitmap1360" />
</DefinedValue>
</DefinedValues>
<HashKeysBuild>
<ColumnReference Table="@Temp" Alias="[tmp]" Column="SBranchId" />
<ColumnReference Table="@Temp" Alias="[tmp]" Column="MFormKod" />
</HashKeysBuild>
<HashKeysProbe>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[TFormBranch]" Column="SBranchId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MForm]" Column="MFormKod" />
</HashKeysProbe>
<ProbeResidual>
<ScalarOperator ScalarString="[planBD1].[dbo].[TFormBranch].[SBranchId]=@Temp.[SBranchId] as [tmp].[SBranchId] AND [planBD1].[dbo].[MForm].[MFormKod]=@Temp.[MFormKod] as [tmp].[MFormKod] AND [planBD1].[dbo].[RMain].[RMainPeriod]>=@tFormPeriodNew.[periodStart] as [tFormPeriodNew].[periodStart] AND [planBD1].[dbo].[RMain].[RMainPeriod]<=@tFormPeriodNew.[periodEnd] as [tFormPeriodNew].[periodEnd]">
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[TFormBranch]" Column="SBranchId" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Table="@Temp" Alias="[tmp]" Column="SBranchId" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MForm]" Column="MFormKod" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Table="@Temp" Alias="[tmp]" Column="MFormKod" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="GE">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[RMain]" Column="RMainPeriod" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Table="@tFormPeriodNew" Alias="[tFormPeriodNew]" Column="periodStart" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="LE">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[RMain]" Column="RMainPeriod" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Table="@tFormPeriodNew" Alias="[tFormPeriodNew]" Column="periodEnd" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</ProbeResidual>
<RelOp AvgRowSize="35" EstimateCPU="0.00177564" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch" EstimateRows="2.8" LogicalOp="Inner Join" NodeId="6" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="0.0120056">
<OutputList>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[SBranch]" Column="SBranchId" />
<ColumnReference Table="@tFormPeriodNew" Alias="[tFormPeriodNew]" Column="periodStart" />
<ColumnReference Table="@tFormPeriodNew" Alias="[tFormPeriodNew]" Column="periodEnd" />
<ColumnReference Table="@Temp" Alias="[tmp]" Column="SBranchId" />
<ColumnReference Table="@Temp" Alias="[tmp]" Column="MFormKod" />
</OutputList>
<MemoryFractions Input="0.000111331" Output="0.000111331" />
<Hash BitmapCreator="true">
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Opt_Bitmap1287" />
</DefinedValue>
</DefinedValues>
<HashKeysBuild>
<ColumnReference Table="@tFormPeriodNew" Alias="[tFormPeriodNew]" Column="MFormKod" />
</HashKeysBuild>
<HashKeysProbe>
<ColumnReference Table="@Temp" Alias="[tmp]" Column="MFormKod" />
</HashKeysProbe>
<ProbeResidual>
<ScalarOperator ScalarString="@Temp.[MFormKod] as [tmp].[MFormKod]=@tFormPeriodNew.[MFormKod] as [tFormPeriodNew].[MFormKod]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Table="@Temp" Alias="[tmp]" Column="MFormKod" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Table="@tFormPeriodNew" Alias="[tFormPeriodNew]" Column="MFormKod" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</ProbeResidual>
<RelOp AvgRowSize="21" EstimateCPU="1.99E-05" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch" EstimateRows="2" EstimatedRowsRead="2" LogicalOp="Table Scan" NodeId="7" Parallel="true" PhysicalOp="Table Scan" EstimatedTotalSubtreeCost="0.0031449" TableCardinality="2">
<OutputList>
<ColumnReference Table="@tFormPeriodNew" Alias="[tFormPeriodNew]" Column="MFormKod" />
<ColumnReference Table="@tFormPeriodNew" Alias="[tFormPeriodNew]" Column="periodStart" />
<ColumnReference Table="@tFormPeriodNew" Alias="[tFormPeriodNew]" Column="periodEnd" />
</OutputList>
<IndexScan Ordered="false" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Table="@tFormPeriodNew" Alias="[tFormPeriodNew]" Column="MFormKod" />
</DefinedValue>
<DefinedValue>
<ColumnReference Table="@tFormPeriodNew" Alias="[tFormPeriodNew]" Column="periodStart" />
</DefinedValue>
<DefinedValue>
<ColumnReference Table="@tFormPeriodNew" Alias="[tFormPeriodNew]" Column="periodEnd" />
</DefinedValue>
</DefinedValues>
<Object Table="[@tFormPeriodNew]" Alias="[tFormPeriodNew]" Storage="RowStore" />
</IndexScan>
</RelOp>
<RelOp AvgRowSize="23" EstimateCPU="3.5E-08" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.4" LogicalOp="Inner Join" NodeId="8" Parallel="true" PhysicalOp="Adaptive Join" IsAdaptive="true" AdaptiveThresholdRows="1.23695" EstimatedTotalSubtreeCost="0.00810795" EstimatedJoinType="Nested Loops">
<OutputList>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[SBranch]" Column="SBranchId" />
<ColumnReference Table="@Temp" Alias="[tmp]" Column="SBranchId" />
<ColumnReference Table="@Temp" Alias="[tmp]" Column="MFormKod" />
</OutputList>
<AdaptiveJoin BitmapCreator="true" Optimized="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[SBranch]" Column="SBranchId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[SBranch]" Column="SBranchId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[SBranch]" Column="SBranchId" />
</DefinedValue>
<DefinedValue>
<ColumnReference Table="@Temp" Alias="[tmp]" Column="SBranchId" />
<ColumnReference Table="@Temp" Alias="[tmp]" Column="SBranchId" />
<ColumnReference Table="@Temp" Alias="[tmp]" Column="SBranchId" />
</DefinedValue>
<DefinedValue>
<ColumnReference Table="@Temp" Alias="[tmp]" Column="MFormKod" />
<ColumnReference Table="@Temp" Alias="[tmp]" Column="MFormKod" />
<ColumnReference Table="@Temp" Alias="[tmp]" Column="MFormKod" />
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Opt_Bitmap3329" />
</DefinedValue>
</DefinedValues>
<HashKeysBuild>
<ColumnReference Table="@Temp" Alias="[tmp]" Column="SBranchId" />
</HashKeysBuild>
<HashKeysProbe>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[SBranch]" Column="SBranchId" />
</HashKeysProbe>
<ProbeResidual>
<ScalarOperator ScalarString="[planBD1].[dbo].[SBranch].[SBranchId]=@Temp.[SBranchId] as [tmp].[SBranchId]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[SBranch]" Column="SBranchId" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Table="@Temp" Alias="[tmp]" Column="SBranchId" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</ProbeResidual>
<OuterReferences>
<ColumnReference Table="@Temp" Alias="[tmp]" Column="SBranchId" />
</OuterReferences>
<RelOp AvgRowSize="19" EstimateCPU="2.15482E-05" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch" EstimateRows="1.4" LogicalOp="Filter" NodeId="10" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="0.00314655">
<OutputList>
<ColumnReference Table="@Temp" Alias="[tmp]" Column="SBranchId" />
<ColumnReference Table="@Temp" Alias="[tmp]" Column="MFormKod" />
</OutputList>
<Filter StartupExpression="false">
<RelOp AvgRowSize="19" EstimateCPU="2.15482E-05" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch" EstimateRows="1.4" EstimatedRowsRead="14" LogicalOp="Table Scan" NodeId="11" Parallel="true" PhysicalOp="Table Scan" EstimatedTotalSubtreeCost="0.00314655" TableCardinality="14">
<OutputList>
<ColumnReference Table="@Temp" Alias="[tmp]" Column="SBranchId" />
<ColumnReference Table="@Temp" Alias="[tmp]" Column="MFormKod" />
</OutputList>
<IndexScan Ordered="false" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Table="@Temp" Alias="[tmp]" Column="SBranchId" />
</DefinedValue>
<DefinedValue>
<ColumnReference Table="@Temp" Alias="[tmp]" Column="MFormKod" />
</DefinedValue>
</DefinedValues>
<Object Table="[@Temp]" Alias="[tmp]" Storage="RowStore" />
</IndexScan>
</RelOp>
<Predicate>
<ScalarOperator ScalarString="PROBE([Opt_Bitmap1287],@Temp.[MFormKod] as [tmp].[MFormKod])">
<Intrinsic FunctionName="PROBE">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Opt_Bitmap1287" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Table="@Temp" Alias="[tmp]" Column="MFormKod" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Predicate>
</Filter>
</RelOp>
<RelOp AvgRowSize="11" EstimateCPU="5.38314E-05" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch" EstimateRows="24.9" EstimatedRowsRead="249" LogicalOp="Index Scan" NodeId="13" Parallel="true" PhysicalOp="Index Scan" EstimatedTotalSubtreeCost="0.00317883" TableCardinality="249">
<OutputList>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[SBranch]" Column="SBranchId" />
</OutputList>
<IndexScan Ordered="false" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[SBranch]" Column="SBranchId" />
</DefinedValue>
</DefinedValues>
<Object Database="[planBD1]" Schema="[dbo]" Table="[SBranch]" Index="[SBranchStr]" IndexKind="NonClustered" Storage="RowStore" />
<Predicate>
<ScalarOperator ScalarString="PROBE([Opt_Bitmap3329],[planBD1].[dbo].[SBranch].[SBranchId])">
<Intrinsic FunctionName="PROBE">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Opt_Bitmap3329" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[SBranch]" Column="SBranchId" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
<RelOp AvgRowSize="11" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0.4" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" EstimatedRowsRead="1" LogicalOp="Clustered Index Seek" NodeId="17" Parallel="true" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00393463" TableCardinality="249">
<OutputList>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[SBranch]" Column="SBranchId" />
</OutputList>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[SBranch]" Column="SBranchId" />
</DefinedValue>
</DefinedValues>
<Object Database="[planBD1]" Schema="[dbo]" Table="[SBranch]" Index="[PK_SBranch]" IndexKind="Clustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[SBranch]" Column="SBranchId" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="@Temp.[SBranchId] as [tmp].[SBranchId]">
<Identifier>
<ColumnReference Table="@Temp" Alias="[tmp]" Column="SBranchId" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</AdaptiveJoin>
</RelOp>
</Hash>
</RelOp>
<RelOp AvgRowSize="41" EstimateCPU="0.00956184" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch" EstimateRows="33800.4" LogicalOp="Filter" NodeId="18" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="2522.14">
<OutputList>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MForm]" Column="MFormKod" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[SCodeLine]" Alias="[SCodeLine_1]" Column="SCodeLineName" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MGrafWork]" Column="MGrafWorkNum" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[RMain]" Column="RMainValue" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[RMain]" Column="RMainPeriod" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[TFormBranch]" Column="SBranchId" />
</OutputList>
<Filter StartupExpression="false">
<RelOp AvgRowSize="41" EstimateCPU="0.00956184" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch" EstimateRows="33800.4" LogicalOp="Inner Join" NodeId="19" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="2522.14">
<OutputList>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MForm]" Column="MFormKod" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[SCodeLine]" Alias="[SCodeLine_1]" Column="SCodeLineName" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MGrafWork]" Column="MGrafWorkNum" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[RMain]" Column="RMainValue" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[RMain]" Column="RMainPeriod" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[TFormBranch]" Column="SBranchId" />
</OutputList>
<MemoryFractions Input="0.0776531" Output="0.0776531" />
<Hash BitmapCreator="true">
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Opt_Bitmap1285" />
</DefinedValue>
</DefinedValues>
<HashKeysBuild>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MBoxTable]" Column="MBoxTableId" />
</HashKeysBuild>
<HashKeysProbe>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[RMain]" Column="MboxTableId" />
</HashKeysProbe>
<RelOp AvgRowSize="30" EstimateCPU="7.29623E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="29.1849" LogicalOp="Inner Join" NodeId="20" Parallel="true" PhysicalOp="Adaptive Join" IsAdaptive="true" AdaptiveThresholdRows="1107.36" EstimatedTotalSubtreeCost="6.49068" EstimatedJoinType="Nested Loops">
<OutputList>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MForm]" Column="MFormKod" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[SCodeLine]" Alias="[SCodeLine_1]" Column="SCodeLineName" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MGrafWork]" Column="MGrafWorkNum" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MBoxTable]" Column="MBoxTableId" />
</OutputList>
<AdaptiveJoin BitmapCreator="true" Optimized="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MForm]" Column="MFormKod" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MForm]" Column="MFormKod" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MForm]" Column="MFormKod" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[SCodeLine]" Alias="[SCodeLine_1]" Column="SCodeLineName" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[SCodeLine]" Alias="[SCodeLine_1]" Column="SCodeLineName" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[SCodeLine]" Alias="[SCodeLine_1]" Column="SCodeLineName" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MGrafWork]" Column="MGrafWorkNum" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MGrafWork]" Column="MGrafWorkNum" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MGrafWork]" Column="MGrafWorkNum" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MBoxTable]" Column="MBoxTableId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MBoxTable]" Column="MBoxTableId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MBoxTable]" Column="MBoxTableId" />
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Opt_Bitmap3330" />
</DefinedValue>
</DefinedValues>
<HashKeysBuild>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLineInfo]" Alias="[MLineInfo_1]" Column="MLineId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MGrafWork]" Column="MGrafWorkId" />
</HashKeysBuild>
<HashKeysProbe>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MBoxTable]" Column="MLineId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MBoxTable]" Column="MGrafWorkId" />
</HashKeysProbe>
<ProbeResidual>
<ScalarOperator ScalarString="[planBD1].[dbo].[MLineInfo].[MLineId] as [MLineInfo_1].[MLineId]=[planBD1].[dbo].[MBoxTable].[MLineId] AND [planBD1].[dbo].[MGrafWork].[MGrafWorkId]=[planBD1].[dbo].[MBoxTable].[MGrafWorkId]">
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLineInfo]" Alias="[MLineInfo_1]" Column="MLineId" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MBoxTable]" Column="MLineId" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MGrafWork]" Column="MGrafWorkId" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MBoxTable]" Column="MGrafWorkId" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</ProbeResidual>
<OuterReferences>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLineInfo]" Alias="[MLineInfo_1]" Column="MLineId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MGrafWork]" Column="MGrafWorkId" />
</OuterReferences>
<RelOp AvgRowSize="34" EstimateCPU="1.52491E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="128848" LogicalOp="Inner Join" NodeId="22" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="3.07129">
<OutputList>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MForm]" Column="MFormKod" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLineInfo]" Alias="[MLineInfo_1]" Column="MLineId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[SCodeLine]" Alias="[SCodeLine_1]" Column="SCodeLineName" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MGrafWork]" Column="MGrafWorkId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MGrafWork]" Column="MGrafWorkNum" />
</OutputList>
<NestedLoops Optimized="false" WithUnorderedPrefetch="true">
<OuterReferences>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MGrafWork]" Column="MGrafWorkId" />
<ColumnReference Column="Expr3333" />
</OuterReferences>
<RelOp AvgRowSize="31" EstimateCPU="1.47151E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="29.1849" LogicalOp="Inner Join" NodeId="24" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="2.98996">
<OutputList>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MForm]" Column="MFormKod" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLineInfo]" Alias="[MLineInfo_1]" Column="MLineId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[SCodeLine]" Alias="[SCodeLine_1]" Column="SCodeLineName" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MGrafWork]" Column="MGrafWorkId" />
</OutputList>
<NestedLoops Optimized="false" WithUnorderedPrefetch="true">
<OuterReferences>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MGrafInfo]" Column="MTableId" />
<ColumnReference Column="Expr3332" />
</OuterReferences>
<RelOp AvgRowSize="31" EstimateCPU="4.07727E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch" EstimateRows="17685.9" LogicalOp="Filter" NodeId="26" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="2.98615">
<OutputList>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MForm]" Column="MFormKod" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MGrafInfo]" Column="MTableId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLineInfo]" Alias="[MLineInfo_1]" Column="MLineId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[SCodeLine]" Alias="[SCodeLine_1]" Column="SCodeLineName" />
</OutputList>
<Filter StartupExpression="false">
<RelOp AvgRowSize="35" EstimateCPU="0" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch" EstimateRows="67.9545" LogicalOp="Compute Scalar" NodeId="27" Parallel="true" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="2.98615">
<OutputList>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MForm]" Column="MFormKod" />
<ColumnReference Column="Expr1012" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MGrafInfo]" Column="MTableId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLineInfo]" Alias="[MLineInfo_1]" Column="MLineId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[SCodeLine]" Alias="[SCodeLine_1]" Column="SCodeLineName" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1012" />
<ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[Expr3331],0)">
<Convert DataType="int" Style="0" Implicit="true">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr3331" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="35" EstimateCPU="0.00181871" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch" EstimateRows="67.9545" LogicalOp="Aggregate" NodeId="28" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="2.98615">
<OutputList>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MForm]" Column="MFormKod" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MGrafInfo]" Column="MTableId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLineInfo]" Alias="[MLineInfo_1]" Column="MLineId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[SCodeLine]" Alias="[SCodeLine_1]" Column="SCodeLineName" />
<ColumnReference Column="Expr3331" />
</OutputList>
<MemoryFractions Input="0.318573" Output="0.318573" />
<Hash>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr3331" />
<ScalarOperator ScalarString="COUNT(*)">
<Aggregate AggType="COUNT*" Distinct="false" />
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MForm]" Column="MFormKod" />
<ScalarOperator ScalarString="ANY([planBD1].[dbo].[MForm].[MFormKod])">
<Aggregate AggType="ANY" Distinct="false">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MForm]" Column="MFormKod" />
</Identifier>
</ScalarOperator>
</Aggregate>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MGrafInfo]" Column="MTableId" />
<ScalarOperator ScalarString="ANY([planBD1].[dbo].[MGrafInfo].[MTableId])">
<Aggregate AggType="ANY" Distinct="false">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MGrafInfo]" Column="MTableId" />
</Identifier>
</ScalarOperator>
</Aggregate>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLineInfo]" Alias="[MLineInfo_1]" Column="MLineId" />
<ScalarOperator ScalarString="ANY([planBD1].[dbo].[MLineInfo].[MLineId] as [MLineInfo_1].[MLineId])">
<Aggregate AggType="ANY" Distinct="false">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLineInfo]" Alias="[MLineInfo_1]" Column="MLineId" />
</Identifier>
</ScalarOperator>
</Aggregate>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[SCodeLine]" Alias="[SCodeLine_1]" Column="SCodeLineName" />
<ScalarOperator ScalarString="ANY([planBD1].[dbo].[SCodeLine].[SCodeLineName] as [SCodeLine_1].[SCodeLineName])">
<Aggregate AggType="ANY" Distinct="false">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[SCodeLine]" Alias="[SCodeLine_1]" Column="SCodeLineName" />
</Identifier>
</ScalarOperator>
</Aggregate>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<HashKeysBuild>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLineInfo]" Alias="[MLineInfo_1]" Column="MLineInfoId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MSection]" Column="MFormId" />
</HashKeysBuild>
<BuildResidual>
<ScalarOperator ScalarString="[planBD1].[dbo].[MLineInfo].[MLineInfoId] as [MLineInfo_1].[MLineInfoId] = [planBD1].[dbo].[MLineInfo].[MLineInfoId] as [MLineInfo_1].[MLineInfoId] AND [planBD1].[dbo].[MSection].[MFormId] = [planBD1].[dbo].[MSection].[MFormId]">
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="IS">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLineInfo]" Alias="[MLineInfo_1]" Column="MLineInfoId" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLineInfo]" Alias="[MLineInfo_1]" Column="MLineInfoId" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="IS">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MSection]" Column="MFormId" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MSection]" Column="MFormId" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</BuildResidual>
<RelOp AvgRowSize="39" EstimateCPU="0.0529815" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch" EstimateRows="67.9545" LogicalOp="Inner Join" NodeId="29" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="2.98433">
<OutputList>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MSection]" Column="MFormId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MForm]" Column="MFormKod" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MGrafInfo]" Column="MTableId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLineInfo]" Alias="[MLineInfo_1]" Column="MLineInfoId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLineInfo]" Alias="[MLineInfo_1]" Column="MLineId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[SCodeLine]" Alias="[SCodeLine_1]" Column="SCodeLineName" />
</OutputList>
<MemoryFractions Input="0.318434" Output="0.318434" />
<Hash>
<DefinedValues />
<HashKeysBuild>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLine]" Column="MLineId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MTable]" Column="MTableId" />
</HashKeysBuild>
<HashKeysProbe>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLineInfo]" Alias="[MLineInfo_1]" Column="MLineId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MGrafInfo]" Column="MTableId" />
</HashKeysProbe>
<ProbeResidual>
<ScalarOperator ScalarString="[planBD1].[dbo].[MLine].[MLineId]=[planBD1].[dbo].[MLineInfo].[MLineId] as [MLineInfo_1].[MLineId] AND [planBD1].[dbo].[MTable].[MTableId]=[planBD1].[dbo].[MGrafInfo].[MTableId]">
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLine]" Column="MLineId" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLineInfo]" Alias="[MLineInfo_1]" Column="MLineId" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MTable]" Column="MTableId" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MGrafInfo]" Column="MTableId" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</ProbeResidual>
<RelOp AvgRowSize="31" EstimateCPU="0.05024" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch" EstimateRows="186536" LogicalOp="Inner Join" NodeId="30" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="1.75822">
<OutputList>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLine]" Column="MLineId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MTable]" Column="MTableId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MSection]" Column="MFormId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MForm]" Column="MFormKod" />
</OutputList>
<MemoryFractions Input="0.142726" Output="0.142726" />
<Hash>
<DefinedValues />
<HashKeysBuild>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLineInfo]" Column="MLineId" />
</HashKeysBuild>
<HashKeysProbe>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLine]" Column="MLineId" />
</HashKeysProbe>
<ProbeResidual>
<ScalarOperator ScalarString="[planBD1].[dbo].[MLineInfo].[MLineId]=[planBD1].[dbo].[MLine].[MLineId]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLineInfo]" Column="MLineId" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLine]" Column="MLineId" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</ProbeResidual>
<RelOp AvgRowSize="11" EstimateCPU="0.0462281" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch" EstimateRows="211107" LogicalOp="Inner Join" NodeId="31" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="1.10852">
<OutputList>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLineInfo]" Column="MLineId" />
</OutputList>
<MemoryFractions Input="0.012135" Output="0.012135" />
<Hash BitmapCreator="true">
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Opt_Bitmap1256" />
</DefinedValue>
</DefinedValues>
<HashKeysBuild>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[SCodeLine]" Column="SCodeLineId" />
</HashKeysBuild>
<HashKeysProbe>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLineInfo]" Column="SCodeLineId" />
</HashKeysProbe>
<ProbeResidual>
<ScalarOperator ScalarString="[planBD1].[dbo].[MLineInfo].[SCodeLineId]=[planBD1].[dbo].[SCodeLine].[SCodeLineId]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLineInfo]" Column="SCodeLineId" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[SCodeLine]" Column="SCodeLineId" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</ProbeResidual>
<RelOp AvgRowSize="11" EstimateCPU="0.000802963" EstimateIO="0.020162" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch" EstimateRows="5697" EstimatedRowsRead="5697" LogicalOp="Index Scan" NodeId="32" Parallel="true" PhysicalOp="Index Scan" EstimatedTotalSubtreeCost="0.020965" TableCardinality="5697">
<OutputList>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[SCodeLine]" Column="SCodeLineId" />
</OutputList>
<IndexScan Ordered="false" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[SCodeLine]" Column="SCodeLineId" />
</DefinedValue>
</DefinedValues>
<Object Database="[planBD1]" Schema="[dbo]" Table="[SCodeLine]" Index="[Code]" IndexKind="NonClustered" Storage="RowStore" />
</IndexScan>
</RelOp>
<RelOp AvgRowSize="15" EstimateCPU="0.0663514" EstimateIO="0.974977" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch" EstimateRows="482413" EstimatedRowsRead="482413" LogicalOp="Index Scan" NodeId="34" Parallel="true" PhysicalOp="Index Scan" EstimatedTotalSubtreeCost="1.04133" TableCardinality="482413">
<OutputList>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLineInfo]" Column="MLineId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLineInfo]" Column="SCodeLineId" />
</OutputList>
<IndexScan Ordered="false" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLineInfo]" Column="MLineId" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLineInfo]" Column="SCodeLineId" />
</DefinedValue>
</DefinedValues>
<Object Database="[planBD1]" Schema="[dbo]" Table="[MLineInfo]" Index="[NonClusteredIndex-20230612-144845]" IndexKind="NonClustered" Storage="RowStore" />
<Predicate>
<ScalarOperator ScalarString="PROBE([Opt_Bitmap1256],[planBD1].[dbo].[MLineInfo].[SCodeLineId])">
<Intrinsic FunctionName="PROBE">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Opt_Bitmap1256" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLineInfo]" Column="SCodeLineId" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
</Hash>
</RelOp>
<RelOp AvgRowSize="27" EstimateCPU="0.000365438" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch" EstimateRows="146175" LogicalOp="Inner Join" NodeId="35" Parallel="true" PhysicalOp="Adaptive Join" IsAdaptive="true" AdaptiveThresholdRows="817.795" EstimatedTotalSubtreeCost="0.599818" EstimatedJoinType="Hash Match">
<OutputList>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLine]" Column="MLineId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MTable]" Column="MTableId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MSection]" Column="MFormId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MForm]" Column="MFormKod" />
</OutputList>
<AdaptiveJoin Optimized="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLine]" Column="MLineId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLine]" Column="MLineId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLine]" Column="MLineId" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MTable]" Column="MTableId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MTable]" Column="MTableId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MTable]" Column="MTableId" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MSection]" Column="MFormId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MSection]" Column="MFormId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MSection]" Column="MFormId" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MForm]" Column="MFormKod" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MForm]" Column="MFormKod" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MForm]" Column="MFormKod" />
</DefinedValue>
</DefinedValues>
<HashKeysBuild>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MTable]" Column="MTableId" />
</HashKeysBuild>
<HashKeysProbe>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLine]" Column="MTableId" />
</HashKeysProbe>
<OuterReferences>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MTable]" Column="MTableId" />
</OuterReferences>
<RelOp AvgRowSize="23" EstimateCPU="1.17016E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch" EstimateRows="4680.62" LogicalOp="Inner Join" NodeId="37" Parallel="true" PhysicalOp="Adaptive Join" IsAdaptive="true" AdaptiveThresholdRows="94.3055" EstimatedTotalSubtreeCost="0.0406842" EstimatedJoinType="Hash Match">
<OutputList>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MTable]" Column="MTableId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MSection]" Column="MFormId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MForm]" Column="MFormKod" />
</OutputList>
<AdaptiveJoin Optimized="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MTable]" Column="MTableId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MTable]" Column="MTableId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MTable]" Column="MTableId" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MSection]" Column="MFormId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MSection]" Column="MFormId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MSection]" Column="MFormId" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MForm]" Column="MFormKod" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MForm]" Column="MFormKod" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MForm]" Column="MFormKod" />
</DefinedValue>
</DefinedValues>
<HashKeysBuild>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MSection]" Column="MSectionId" />
</HashKeysBuild>
<HashKeysProbe>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MTable]" Column="MSectionId" />
</HashKeysProbe>
<OuterReferences>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MSection]" Column="MSectionId" />
</OuterReferences>
<RelOp AvgRowSize="23" EstimateCPU="4.13574E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch" EstimateRows="1654.3" LogicalOp="Inner Join" NodeId="39" Parallel="true" PhysicalOp="Adaptive Join" IsAdaptive="true" AdaptiveThresholdRows="34.5047" EstimatedTotalSubtreeCost="0.0178306" EstimatedJoinType="Hash Match">
<OutputList>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MSection]" Column="MSectionId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MSection]" Column="MFormId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MForm]" Column="MFormKod" />
</OutputList>
<AdaptiveJoin Optimized="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MSection]" Column="MSectionId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MSection]" Column="MSectionId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MSection]" Column="MSectionId" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MSection]" Column="MFormId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MSection]" Column="MFormId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MSection]" Column="MFormId" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MForm]" Column="MFormKod" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MForm]" Column="MFormKod" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MForm]" Column="MFormKod" />
</DefinedValue>
</DefinedValues>
<HashKeysBuild>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MForm]" Column="MFormId" />
</HashKeysBuild>
<HashKeysProbe>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MSection]" Column="MFormId" />
</HashKeysProbe>
<OuterReferences>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MForm]" Column="MFormId" />
</OuterReferences>
<RelOp AvgRowSize="19" EstimateCPU="0.000218588" EstimateIO="0.00831019" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch" EstimateRows="1447" EstimatedRowsRead="1447" LogicalOp="Index Scan" NodeId="41" Parallel="true" PhysicalOp="Index Scan" EstimatedTotalSubtreeCost="0.00852877" TableCardinality="1447">
<OutputList>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MForm]" Column="MFormId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MForm]" Column="MFormKod" />
</OutputList>
<IndexScan Ordered="false" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MForm]" Column="MFormId" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MForm]" Column="MFormKod" />
</DefinedValue>
</DefinedValues>
<Object Database="[planBD1]" Schema="[dbo]" Table="[MForm]" Index="[Id+Id]" IndexKind="NonClustered" Storage="RowStore" />
</IndexScan>
</RelOp>
<RelOp AvgRowSize="15" EstimateCPU="0.000255713" EstimateIO="0.0068287" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch" EstimateRows="1717" EstimatedRowsRead="1717" LogicalOp="Index Scan" NodeId="42" Parallel="true" PhysicalOp="Index Scan" EstimatedTotalSubtreeCost="0.00708442" TableCardinality="1717">
<OutputList>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MSection]" Column="MSectionId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MSection]" Column="MFormId" />
</OutputList>
<IndexScan Ordered="false" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MSection]" Column="MSectionId" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MSection]" Column="MFormId" />
</DefinedValue>
</DefinedValues>
<Object Database="[planBD1]" Schema="[dbo]" Table="[MSection]" Index="[FormId]" IndexKind="NonClustered" Storage="RowStore" />
</IndexScan>
</RelOp>
<RelOp AvgRowSize="15" EstimateCPU="0.000158258" EstimateIO="0.003125" EstimateRebinds="1446" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.14326" EstimatedRowsRead="1.14326" LogicalOp="Index Seek" NodeId="45" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.247749" TableCardinality="1717">
<OutputList>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MSection]" Column="MSectionId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MSection]" Column="MFormId" />
</OutputList>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MSection]" Column="MSectionId" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MSection]" Column="MFormId" />
</DefinedValue>
</DefinedValues>
<Object Database="[planBD1]" Schema="[dbo]" Table="[MSection]" Index="[FormId]" IndexKind="NonClustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MSection]" Column="MFormId" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[planBD1].[dbo].[MForm].[MFormId]">
<Identifier>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MForm]" Column="MFormId" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</AdaptiveJoin>
</RelOp>
<RelOp AvgRowSize="15" EstimateCPU="0.000718263" EstimateIO="0.0194213" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch" EstimateRows="5081" EstimatedRowsRead="5081" LogicalOp="Index Scan" NodeId="46" Parallel="true" PhysicalOp="Index Scan" EstimatedTotalSubtreeCost="0.0201396" TableCardinality="5081">
<OutputList>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MTable]" Column="MTableId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MTable]" Column="MSectionId" />
</OutputList>
<IndexScan Ordered="false" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MTable]" Column="MTableId" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MTable]" Column="MSectionId" />
</DefinedValue>
</DefinedValues>
<Object Database="[planBD1]" Schema="[dbo]" Table="[MTable]" Index="[Table]" IndexKind="NonClustered" Storage="RowStore" />
</IndexScan>
</RelOp>
<RelOp AvgRowSize="11" EstimateCPU="0.000160112" EstimateIO="0.003125" EstimateRebinds="1653.3" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="2.82937" EstimatedRowsRead="2.82937" LogicalOp="Index Seek" NodeId="49" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.336748" TableCardinality="5081">
<OutputList>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MTable]" Column="MTableId" />
</OutputList>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MTable]" Column="MTableId" />
</DefinedValue>
</DefinedValues>
<Object Database="[planBD1]" Schema="[dbo]" Table="[MTable]" Index="[Table]" IndexKind="NonClustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MTable]" Column="MSectionId" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[planBD1].[dbo].[MSection].[MSectionId]">
<Identifier>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MSection]" Column="MSectionId" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</AdaptiveJoin>
</RelOp>
<RelOp AvgRowSize="15" EstimateCPU="0.0217437" EstimateIO="0.514236" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch" EstimateRows="157993" EstimatedRowsRead="157993" LogicalOp="Index Scan" NodeId="50" Parallel="true" PhysicalOp="Index Scan" EstimatedTotalSubtreeCost="0.53598" TableCardinality="157993">
<OutputList>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLine]" Column="MLineId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLine]" Column="MTableId" />
</OutputList>
<IndexScan Ordered="false" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLine]" Column="MLineId" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLine]" Column="MTableId" />
</DefinedValue>
</DefinedValues>
<Object Database="[planBD1]" Schema="[dbo]" Table="[MLine]" Index="[TableId]" IndexKind="NonClustered" Storage="RowStore" />
</IndexScan>
</RelOp>
<RelOp AvgRowSize="11" EstimateCPU="0.000191353" EstimateIO="0.003125" EstimateRebinds="4679.62" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="31.2299" EstimatedRowsRead="31.2299" LogicalOp="Index Seek" NodeId="53" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="3.05257" TableCardinality="157993">
<OutputList>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLine]" Column="MLineId" />
</OutputList>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLine]" Column="MLineId" />
</DefinedValue>
</DefinedValues>
<Object Database="[planBD1]" Schema="[dbo]" Table="[MLine]" Index="[TableId]" IndexKind="NonClustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLine]" Column="MTableId" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[planBD1].[dbo].[MTable].[MTableId]">
<Identifier>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MTable]" Column="MTableId" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</AdaptiveJoin>
</RelOp>
</Hash>
</RelOp>
<RelOp AvgRowSize="27" EstimateCPU="0.0308535" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch" EstimateRows="202185" LogicalOp="Inner Join" NodeId="54" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="1.17312">
<OutputList>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MGrafInfo]" Column="MTableId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLineInfo]" Alias="[MLineInfo_1]" Column="MLineInfoId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLineInfo]" Alias="[MLineInfo_1]" Column="MLineId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[SCodeLine]" Alias="[SCodeLine_1]" Column="SCodeLineName" />
</OutputList>
<MemoryFractions Input="0.0300036" Output="0.0300036" />
<Hash>
<DefinedValues />
<HashKeysBuild>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MGrafInfo]" Column="MGrafInfoId" />
</HashKeysBuild>
<HashKeysProbe>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLineInfo]" Alias="[MLineInfo_1]" Column="MGrafInfoId" />
</HashKeysProbe>
<ProbeResidual>
<ScalarOperator ScalarString="[planBD1].[dbo].[MGrafInfo].[MGrafInfoId]=[planBD1].[dbo].[MLineInfo].[MGrafInfoId] as [MLineInfo_1].[MGrafInfoId]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MGrafInfo]" Column="MGrafInfoId" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLineInfo]" Alias="[MLineInfo_1]" Column="MGrafInfoId" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</ProbeResidual>
<RelOp AvgRowSize="15" EstimateCPU="0.00145581" EstimateIO="0.0320139" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch" EstimateRows="10445" EstimatedRowsRead="10445" LogicalOp="Index Scan" NodeId="55" Parallel="true" PhysicalOp="Index Scan" EstimatedTotalSubtreeCost="0.0334697" TableCardinality="10445">
<OutputList>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MGrafInfo]" Column="MGrafInfoId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MGrafInfo]" Column="MTableId" />
</OutputList>
<IndexScan Ordered="false" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MGrafInfo]" Column="MGrafInfoId" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MGrafInfo]" Column="MTableId" />
</DefinedValue>
</DefinedValues>
<Object Database="[planBD1]" Schema="[dbo]" Table="[MGrafInfo]" Index="[TableId]" IndexKind="NonClustered" Storage="RowStore" />
</IndexScan>
</RelOp>
<RelOp AvgRowSize="27" EstimateCPU="0.0464958" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch" EstimateRows="211107" LogicalOp="Inner Join" NodeId="56" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="1.10879">
<OutputList>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLineInfo]" Alias="[MLineInfo_1]" Column="MLineInfoId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLineInfo]" Alias="[MLineInfo_1]" Column="MLineId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLineInfo]" Alias="[MLineInfo_1]" Column="MGrafInfoId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[SCodeLine]" Alias="[SCodeLine_1]" Column="SCodeLineName" />
</OutputList>
<MemoryFractions Input="0.0138885" Output="0.0138885" />
<Hash BitmapCreator="true">
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Opt_Bitmap1279" />
</DefinedValue>
</DefinedValues>
<HashKeysBuild>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[SCodeLine]" Alias="[SCodeLine_1]" Column="SCodeLineId" />
</HashKeysBuild>
<HashKeysProbe>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLineInfo]" Alias="[MLineInfo_1]" Column="SCodeLineId" />
</HashKeysProbe>
<ProbeResidual>
<ScalarOperator ScalarString="[planBD1].[dbo].[MLineInfo].[SCodeLineId] as [MLineInfo_1].[SCodeLineId]=[planBD1].[dbo].[SCodeLine].[SCodeLineId] as [SCodeLine_1].[SCodeLineId]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLineInfo]" Alias="[MLineInfo_1]" Column="SCodeLineId" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[SCodeLine]" Alias="[SCodeLine_1]" Column="SCodeLineId" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</ProbeResidual>
<RelOp AvgRowSize="19" EstimateCPU="0.000802963" EstimateIO="0.020162" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch" EstimateRows="5697" EstimatedRowsRead="5697" LogicalOp="Index Scan" NodeId="57" Parallel="true" PhysicalOp="Index Scan" EstimatedTotalSubtreeCost="0.020965" TableCardinality="5697">
<OutputList>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[SCodeLine]" Alias="[SCodeLine_1]" Column="SCodeLineId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[SCodeLine]" Alias="[SCodeLine_1]" Column="SCodeLineName" />
</OutputList>
<IndexScan Ordered="false" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[SCodeLine]" Alias="[SCodeLine_1]" Column="SCodeLineId" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[SCodeLine]" Alias="[SCodeLine_1]" Column="SCodeLineName" />
</DefinedValue>
</DefinedValues>
<Object Database="[planBD1]" Schema="[dbo]" Table="[SCodeLine]" Index="[Code]" Alias="[SCodeLine_1]" IndexKind="NonClustered" Storage="RowStore" />
</IndexScan>
</RelOp>
<RelOp AvgRowSize="23" EstimateCPU="0.0663514" EstimateIO="0.974977" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch" EstimateRows="482413" EstimatedRowsRead="482413" LogicalOp="Index Scan" NodeId="59" Parallel="true" PhysicalOp="Index Scan" EstimatedTotalSubtreeCost="1.04133" TableCardinality="482413">
<OutputList>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLineInfo]" Alias="[MLineInfo_1]" Column="MLineInfoId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLineInfo]" Alias="[MLineInfo_1]" Column="MLineId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLineInfo]" Alias="[MLineInfo_1]" Column="MGrafInfoId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLineInfo]" Alias="[MLineInfo_1]" Column="SCodeLineId" />
</OutputList>
<IndexScan Ordered="false" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLineInfo]" Alias="[MLineInfo_1]" Column="MLineInfoId" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLineInfo]" Alias="[MLineInfo_1]" Column="MLineId" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLineInfo]" Alias="[MLineInfo_1]" Column="MGrafInfoId" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLineInfo]" Alias="[MLineInfo_1]" Column="SCodeLineId" />
</DefinedValue>
</DefinedValues>
<Object Database="[planBD1]" Schema="[dbo]" Table="[MLineInfo]" Index="[NonClusteredIndex-20230612-144845]" Alias="[MLineInfo_1]" IndexKind="NonClustered" Storage="RowStore" />
<Predicate>
<ScalarOperator ScalarString="PROBE([Opt_Bitmap1279],[planBD1].[dbo].[MLineInfo].[SCodeLineId] as [MLineInfo_1].[SCodeLineId])">
<Intrinsic FunctionName="PROBE">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Opt_Bitmap1279" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLineInfo]" Alias="[MLineInfo_1]" Column="SCodeLineId" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
</Hash>
</RelOp>
</Hash>
</RelOp>
</Hash>
</RelOp>
</Hash>
</RelOp>
</ComputeScalar>
</RelOp>
<Predicate>
<ScalarOperator ScalarString="[Expr1012]=(1)">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1012" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(1)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</Filter>
</RelOp>
<RelOp AvgRowSize="11" EstimateCPU="0.000177205" EstimateIO="0.003125" EstimateRebinds="17645" EstimateRewinds="39.9009" EstimatedExecutionMode="Row" EstimateRows="18.3682" EstimatedRowsRead="18.3682" LogicalOp="Index Seek" NodeId="60" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="22.3826" TableCardinality="95636">
<OutputList>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MGrafWork]" Column="MGrafWorkId" />
</OutputList>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MGrafWork]" Column="MGrafWorkId" />
</DefinedValue>
</DefinedValues>
<Object Database="[planBD1]" Schema="[dbo]" Table="[MGrafWork]" Index="[=MTableId]" IndexKind="NonClustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MGrafWork]" Column="MTableId" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[planBD1].[dbo].[MGrafInfo].[MTableId]">
<Identifier>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MGrafInfo]" Column="MTableId" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="12" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="28.0178" EstimateRewinds="0.167123" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="62" Parallel="true" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.081316" TableCardinality="95636">
<OutputList>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MGrafWork]" Column="MGrafWorkNum" />
</OutputList>
<IndexScan Lookup="true" Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MGrafWork]" Column="MGrafWorkNum" />
</DefinedValue>
</DefinedValues>
<Object Database="[planBD1]" Schema="[dbo]" Table="[MGrafWork]" Index="[PK_MGrafWork]" TableReferenceId="-1" IndexKind="Clustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MGrafWork]" Column="MGrafWorkId" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[planBD1].[dbo].[MGrafWork].[MGrafWorkId]">
<Identifier>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MGrafWork]" Column="MGrafWorkId" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="19" EstimateCPU="0.257165" EstimateIO="3.10016" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch" EstimateRows="187185" EstimatedRowsRead="1871850" LogicalOp="Index Scan" NodeId="64" Parallel="true" PhysicalOp="Index Scan" EstimatedTotalSubtreeCost="3.35733" TableCardinality="1871850">
<OutputList>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MBoxTable]" Column="MBoxTableId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MBoxTable]" Column="MGrafWorkId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MBoxTable]" Column="MLineId" />
</OutputList>
<IndexScan Ordered="false" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MBoxTable]" Column="MBoxTableId" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MBoxTable]" Column="MGrafWorkId" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MBoxTable]" Column="MLineId" />
</DefinedValue>
</DefinedValues>
<Object Database="[planBD1]" Schema="[dbo]" Table="[MBoxTable]" Index="[MLine+MGrafWork->MBoxTableId]" IndexKind="NonClustered" Storage="RowStore" />
<Predicate>
<ScalarOperator ScalarString="PROBE([Opt_Bitmap3330],[planBD1].[dbo].[MBoxTable].[MLineId]) AND PROBE([Opt_Bitmap3330],[planBD1].[dbo].[MBoxTable].[MGrafWorkId])">
<Logical Operation="AND">
<ScalarOperator>
<Intrinsic FunctionName="PROBE">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Opt_Bitmap3330" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MBoxTable]" Column="MLineId" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
<ScalarOperator>
<Intrinsic FunctionName="PROBE">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Opt_Bitmap3330" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MBoxTable]" Column="MGrafWorkId" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
<RelOp AvgRowSize="11" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="128847" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" EstimatedRowsRead="1" LogicalOp="Index Seek" NodeId="67" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="393.919" TableCardinality="1871850">
<OutputList>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MBoxTable]" Column="MBoxTableId" />
</OutputList>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MBoxTable]" Column="MBoxTableId" />
</DefinedValue>
</DefinedValues>
<Object Database="[planBD1]" Schema="[dbo]" Table="[MBoxTable]" Index="[MLine+MGrafWork->MBoxTableId]" IndexKind="NonClustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MBoxTable]" Column="MLineId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MBoxTable]" Column="MGrafWorkId" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[planBD1].[dbo].[MLineInfo].[MLineId] as [MLineInfo_1].[MLineId]">
<Identifier>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MLineInfo]" Alias="[MLineInfo_1]" Column="MLineId" />
</Identifier>
</ScalarOperator>
<ScalarOperator ScalarString="[planBD1].[dbo].[MGrafWork].[MGrafWorkId]">
<Identifier>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MGrafWork]" Column="MGrafWorkId" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</AdaptiveJoin>
</RelOp>
<RelOp AvgRowSize="26" EstimateCPU="0.033394" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch" EstimateRows="90779" LogicalOp="Inner Join" NodeId="68" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="2518.97">
<OutputList>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[RMain]" Column="MboxTableId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[RMain]" Column="RMainValue" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[RMain]" Column="RMainPeriod" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[TFormBranch]" Column="SBranchId" />
</OutputList>
<MemoryFractions Input="0.0752595" Output="0.0752595" />
<Hash>
<DefinedValues />
<HashKeysBuild>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[TFormBranch]" Column="TFormBranchId" />
</HashKeysBuild>
<HashKeysProbe>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[RMain]" Column="TFormBranchId" />
</HashKeysProbe>
<ProbeResidual>
<ScalarOperator ScalarString="[planBD1].[dbo].[RMain].[TFormBranchId]=[planBD1].[dbo].[TFormBranch].[TFormBranchId]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[RMain]" Column="TFormBranchId" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[TFormBranch]" Column="TFormBranchId" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</ProbeResidual>
<RelOp AvgRowSize="15" EstimateCPU="0.0184248" EstimateIO="0.401644" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch" EstimateRows="133856" EstimatedRowsRead="133856" LogicalOp="Index Scan" NodeId="69" Parallel="true" PhysicalOp="Index Scan" EstimatedTotalSubtreeCost="0.420068" TableCardinality="133856">
<OutputList>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[TFormBranch]" Column="TFormBranchId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[TFormBranch]" Column="SBranchId" />
</OutputList>
<IndexScan Ordered="false" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[TFormBranch]" Column="TFormBranchId" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[TFormBranch]" Column="SBranchId" />
</DefinedValue>
</DefinedValues>
<Object Database="[planBD1]" Schema="[dbo]" Table="[TFormBranch]" Index="[MFormId+SBranchId]" IndexKind="NonClustered" Storage="RowStore" />
</IndexScan>
</RelOp>
<RelOp AvgRowSize="30" EstimateCPU="95.8889" EstimateIO="2380.75" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch" EstimateRows="91034.3" EstimatedRowsRead="697989000" LogicalOp="Index Scan" NodeId="71" Parallel="true" Partitioned="true" PhysicalOp="Index Scan" EstimatedTotalSubtreeCost="2476.64" TableCardinality="697989000">
<OutputList>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[RMain]" Column="TFormBranchId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[RMain]" Column="MboxTableId" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[RMain]" Column="RMainValue" />
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[RMain]" Column="RMainPeriod" />
</OutputList>
<IndexScan Ordered="false" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[RMain]" Column="TFormBranchId" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[RMain]" Column="MboxTableId" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[RMain]" Column="RMainValue" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[RMain]" Column="RMainPeriod" />
</DefinedValue>
</DefinedValues>
<Object Database="[planBD1]" Schema="[dbo]" Table="[RMain]" Index="[test]" IndexKind="NonClustered" Storage="RowStore" />
<Predicate>
<ScalarOperator ScalarString="[planBD1].[dbo].[RMain].[RMainTypePeriod]=(1) AND PROBE([Opt_Bitmap1285],[planBD1].[dbo].[RMain].[MboxTableId])">
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[RMain]" Column="RMainTypePeriod" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(1)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Intrinsic FunctionName="PROBE">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Opt_Bitmap1285" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[RMain]" Column="MboxTableId" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
</Hash>
</RelOp>
</Hash>
</RelOp>
<Predicate>
<ScalarOperator ScalarString="PROBE([Opt_Bitmap1360],[planBD1].[dbo].[TFormBranch].[SBranchId],[planBD1].[dbo].[MForm].[MFormKod])">
<Intrinsic FunctionName="PROBE">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Opt_Bitmap1360" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[TFormBranch]" Column="SBranchId" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[planBD1]" Schema="[dbo]" Table="[MForm]" Column="MFormKod" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Predicate>
</Filter>
</RelOp>
</Hash>
</RelOp>
</Sort>
</RelOp>
</Parallelism>
</RelOp>
</StreamAggregate>
</RelOp>
</ComputeScalar>
</RelOp>
</QueryPlan>
</StmtSimple>
</Statements>
</Batch>
</BatchSequence>
</ShowPlanXML>