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.2" Build="11.0.3128.0" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
- <BatchSequence>
- <Batch>
- <Statements>
- <StmtSimple StatementCompId="1" StatementEstRows="7" StatementId="1" StatementOptmLevel="FULL" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" StatementSubTreeCost="0.0411462" StatementText="SELECT 
 [UnionAll3].[C2] AS [C1], 
 [UnionAll3].[C3] AS [C2], 
 [UnionAll3].[C4] AS [C3], 
 [UnionAll3].[C5] AS [C4], 
 [UnionAll3].[C6] AS [C5], 
 [UnionAll3].[C7] AS [C6], 
 [UnionAll3].[C8] AS [C7], 
 [UnionAll3].[C9] AS [C8], 
 [UnionAll3].[C10] AS [C9], 
 [UnionAll3].[C11] AS [C10], 
 [UnionAll3].[C12] AS [C11], 
 [UnionAll3].[C13] AS [C12], 
 [UnionAll3].[C1] AS [C13], 
 [UnionAll3].[C14] AS [C14], 
 [UnionAll3].[C15] AS [C15], 
 [UnionAll3].[C16] AS [C16], 
 [UnionAll3].[C17] AS [C17], 
 [UnionAll3].[C18] AS [C18], 
 [UnionAll3].[C19] AS [C19], 
 [UnionAll3].[C20] AS [C20], 
 [UnionAll3].[C21] AS [C21], 
 [UnionAll3].[C22] AS [C22], 
 [UnionAll3].[C23] AS [C23], 
 [UnionAll3].[C24] AS [C24], 
 [UnionAll3].[C25] AS [C25], 
 [UnionAll3].[C26] AS [C26], 
 [UnionAll3].[C27] AS [C27], 
 [UnionAll3].[C28] AS [C28], 
 [UnionAll3].[C29] AS [C29], 
 [UnionAll3].[C30] AS [C30], 
 [UnionAll3].[C31] AS [C31], 
 [UnionAll3].[C32] AS [C32], 
 [UnionAll3].[C33] AS [C33], 
 [UnionAll3].[C34] AS [C34], 
 [UnionAll3].[C35] AS [C35], 
 [UnionAll3].[C36] AS [C36], 
 [UnionAll3].[C37] AS [C37], 
 [UnionAll3].[C38] AS [C38], 
 [UnionAll3].[C39] AS [C39], 
 [UnionAll3].[C40] AS [C40], 
 [UnionAll3].[C41] AS [C41], 
 [UnionAll3].[C42] AS [C42], 
 [UnionAll3].[C43] AS [C43], 
 [UnionAll3].[C44] AS [C44], 
 [UnionAll3].[C45] AS [C45], 
 [UnionAll3].[C46] AS [C46], 
 [UnionAll3].[C47] AS [C47], 
 [UnionAll3].[C48] AS [C48], 
 [UnionAll3].[C49] AS [C49], 
 [UnionAll3].[C50] AS [C50], 
 [UnionAll3].[C51] AS [C51]
 FROM (SELECT 
 [UnionAll2].[C1] AS [C1], 
 [UnionAll2].[C2] AS [C2], 
 [UnionAll2].[C3] AS [C3], 
 [UnionAll2].[C4] AS [C4], 
 [UnionAll2].[C5] AS [C5], 
 [UnionAll2].[C6] AS [C6], 
 [UnionAll2].[C7] AS [C7], 
 [UnionAll2].[C8] AS [C8], 
 [UnionAll2].[C9] AS [C9], 
 [UnionAll2].[C10] AS [C10], 
 [UnionAll2].[C11] AS [C11], 
 [UnionAll2].[C12] AS [C12], 
 [UnionAll2].[C13] AS [C13], 
 [UnionAll2].[C14] AS [C14], 
 [UnionAll2].[C15] AS [C15], 
 [UnionAll2].[C16] AS [C16], 
 [UnionAll2].[C17] AS [C17], 
 [UnionAll2].[C18] AS [C18], 
 [UnionAll2].[C19] AS [C19], 
 [UnionAll2].[C20] AS [C20], 
 [UnionAll2].[C21] AS [C21], 
 [UnionAll2].[C22] AS [C22], 
 [UnionAll2].[C23] AS [C23], 
 [UnionAll2].[C24] AS [C24], 
 [UnionAll2].[C25] AS [C25], 
 [UnionAll2].[C26] AS [C26], 
 [UnionAll2].[C27] AS [C27], 
 [UnionAll2].[C28] AS [C28], 
 [UnionAll2].[C29] AS [C29], 
 [UnionAll2].[C30] AS [C30], 
 [UnionAll2].[C31] AS [C31], 
 [UnionAll2].[C32] AS [C32], 
 [UnionAll2].[C33] AS [C33], 
 [UnionAll2].[C34] AS [C34], 
 [UnionAll2].[C35] AS [C35], 
 [UnionAll2].[C36] AS [C36], 
 [UnionAll2].[C37] AS [C37], 
 [UnionAll2].[C38] AS [C38], 
 [UnionAll2].[C39] AS [C39], 
 [UnionAll2].[C40] AS [C40], 
 [UnionAll2].[C41] AS [C41], 
 [UnionAll2].[C42] AS [C42], 
 [UnionAll2].[C43] AS [C43], 
 [UnionAll2].[C44] AS [C44], 
 [UnionAll2].[C45] AS [C45], 
 [UnionAll2].[C46] AS [C46], 
 [UnionAll2].[C47] AS [C47], 
 [UnionAll2].[C48] AS [C48], 
 [UnionAll2].[C49] AS [C49], 
 [UnionAll2].[C50] AS [C50], 
 [UnionAll2].[C51] AS [C51]
 FROM (SELECT 
 [UnionAll1].[C1] AS [C1], 
 [UnionAll1].[MainId] AS [C2], 
 [UnionAll1].[MainId1] AS [C3], 
 [UnionAll1].[Field1] AS [C4], 
 [UnionAll1].[Field11] AS [C5], 
 [UnionAll1].[Field12] AS [C6], 
 [UnionAll1].[Field13] AS [C7], 
 " StatementType="SELECT" QueryHash="0x7C5EA7065D08ACB2" QueryPlanHash="0x4FF967453929AC2B" RetrievedFromCache="true">
- <StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" />
- <QueryPlan DegreeOfParallelism="0" NonParallelPlanReason="NoParallelPlansInDesktopOrExpressEdition" MemoryGrant="1024" CachedPlanSize="256" CompileTime="9" CompileCPU="9" CompileMemory="2144">
- <MemoryGrantInfo SerialRequiredMemory="512" SerialDesiredMemory="544" RequiredMemory="512" DesiredMemory="544" RequestedMemory="1024" GrantWaitTime="0" GrantedMemory="1024" MaxUsedMemory="16" />
- <OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="209123" EstimatedPagesCached="52280" EstimatedAvailableDegreeOfParallelism="2" />
- <RelOp AvgRowSize="619" EstimateCPU="0.000131275" EstimateIO="0.0112613" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="7" LogicalOp="Sort" NodeId="0" Parallel="false" PhysicalOp="Sort" EstimatedTotalSubtreeCost="0.0411462">
- <OutputList>
- <ColumnReference Column="Union1263" />
- <ColumnReference Column="Union1264" />
- <ColumnReference Column="Union1265" />
- <ColumnReference Column="Union1266" />
- <ColumnReference Column="Union1267" />
- <ColumnReference Column="Union1268" />
- <ColumnReference Column="Union1269" />
- <ColumnReference Column="Union1270" />
- <ColumnReference Column="Union1271" />
- <ColumnReference Column="Union1272" />
- <ColumnReference Column="Union1273" />
- <ColumnReference Column="Union1274" />
- <ColumnReference Column="Union1275" />
- <ColumnReference Column="Union1276" />
- <ColumnReference Column="Union1277" />
- <ColumnReference Column="Union1278" />
- <ColumnReference Column="Union1279" />
- <ColumnReference Column="Union1280" />
- <ColumnReference Column="Union1281" />
- <ColumnReference Column="Union1282" />
- <ColumnReference Column="Union1283" />
- <ColumnReference Column="Union1284" />
- <ColumnReference Column="Union1285" />
- <ColumnReference Column="Union1286" />
- <ColumnReference Column="Union1287" />
- <ColumnReference Column="Union1288" />
- <ColumnReference Column="Union1289" />
- <ColumnReference Column="Union1290" />
- <ColumnReference Column="Union1291" />
- <ColumnReference Column="Union1292" />
- <ColumnReference Column="Union1293" />
- <ColumnReference Column="Union1294" />
- <ColumnReference Column="Union1295" />
- <ColumnReference Column="Union1296" />
- <ColumnReference Column="Union1297" />
- <ColumnReference Column="Union1298" />
- <ColumnReference Column="Union1299" />
- <ColumnReference Column="Union1300" />
- <ColumnReference Column="Union1301" />
- <ColumnReference Column="Union1302" />
- <ColumnReference Column="Union1303" />
- <ColumnReference Column="Union1304" />
- <ColumnReference Column="Union1305" />
- <ColumnReference Column="Union1306" />
- <ColumnReference Column="Union1307" />
- <ColumnReference Column="Union1308" />
- <ColumnReference Column="Union1309" />
- <ColumnReference Column="Union1310" />
- <ColumnReference Column="Union1311" />
- <ColumnReference Column="Union1312" />
- <ColumnReference Column="Union1313" />
- </OutputList>
- <MemoryFractions Input="1" Output="1" />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRebinds="1" ActualRewinds="0" ActualRows="8" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <Sort Distinct="false">
- <OrderBy>
- <OrderByColumn Ascending="true">
- <ColumnReference Column="Union1265" />
- </OrderByColumn>
- <OrderByColumn Ascending="true">
- <ColumnReference Column="Union1263" />
- </OrderByColumn>
- </OrderBy>
- <RelOp AvgRowSize="619" EstimateCPU="7E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="7" LogicalOp="Concatenation" NodeId="1" Parallel="false" PhysicalOp="Concatenation" EstimatedTotalSubtreeCost="0.0297536">
- <OutputList>
- <ColumnReference Column="Union1263" />
- <ColumnReference Column="Union1264" />
- <ColumnReference Column="Union1265" />
- <ColumnReference Column="Union1266" />
- <ColumnReference Column="Union1267" />
- <ColumnReference Column="Union1268" />
- <ColumnReference Column="Union1269" />
- <ColumnReference Column="Union1270" />
- <ColumnReference Column="Union1271" />
- <ColumnReference Column="Union1272" />
- <ColumnReference Column="Union1273" />
- <ColumnReference Column="Union1274" />
- <ColumnReference Column="Union1275" />
- <ColumnReference Column="Union1276" />
- <ColumnReference Column="Union1277" />
- <ColumnReference Column="Union1278" />
- <ColumnReference Column="Union1279" />
- <ColumnReference Column="Union1280" />
- <ColumnReference Column="Union1281" />
- <ColumnReference Column="Union1282" />
- <ColumnReference Column="Union1283" />
- <ColumnReference Column="Union1284" />
- <ColumnReference Column="Union1285" />
- <ColumnReference Column="Union1286" />
- <ColumnReference Column="Union1287" />
- <ColumnReference Column="Union1288" />
- <ColumnReference Column="Union1289" />
- <ColumnReference Column="Union1290" />
- <ColumnReference Column="Union1291" />
- <ColumnReference Column="Union1292" />
- <ColumnReference Column="Union1293" />
- <ColumnReference Column="Union1294" />
- <ColumnReference Column="Union1295" />
- <ColumnReference Column="Union1296" />
- <ColumnReference Column="Union1297" />
- <ColumnReference Column="Union1298" />
- <ColumnReference Column="Union1299" />
- <ColumnReference Column="Union1300" />
- <ColumnReference Column="Union1301" />
- <ColumnReference Column="Union1302" />
- <ColumnReference Column="Union1303" />
- <ColumnReference Column="Union1304" />
- <ColumnReference Column="Union1305" />
- <ColumnReference Column="Union1306" />
- <ColumnReference Column="Union1307" />
- <ColumnReference Column="Union1308" />
- <ColumnReference Column="Union1309" />
- <ColumnReference Column="Union1310" />
- <ColumnReference Column="Union1311" />
- <ColumnReference Column="Union1312" />
- <ColumnReference Column="Union1313" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="8" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <Concat>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Union1263" />
- <ColumnReference Column="Union1172" />
- <ColumnReference Column="Expr1236" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1264" />
- <ColumnReference Column="Union1173" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="MainId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1265" />
- <ColumnReference Column="Union1174" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="MainId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1266" />
- <ColumnReference Column="Union1175" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field1" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1267" />
- <ColumnReference Column="Union1176" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field11" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1268" />
- <ColumnReference Column="Union1177" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field12" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1269" />
- <ColumnReference Column="Union1178" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field13" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1270" />
- <ColumnReference Column="Union1179" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field14" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1271" />
- <ColumnReference Column="Union1180" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field15" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1272" />
- <ColumnReference Column="Union1181" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field16" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1273" />
- <ColumnReference Column="Union1182" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field17" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1274" />
- <ColumnReference Column="Union1183" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field18" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1275" />
- <ColumnReference Column="Union1184" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field19" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1276" />
- <ColumnReference Column="Union1185" />
- <ColumnReference Column="Expr1237" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1277" />
- <ColumnReference Column="Union1186" />
- <ColumnReference Column="Expr1238" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1278" />
- <ColumnReference Column="Union1187" />
- <ColumnReference Column="Expr1239" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1279" />
- <ColumnReference Column="Union1188" />
- <ColumnReference Column="Expr1240" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1280" />
- <ColumnReference Column="Union1189" />
- <ColumnReference Column="Expr1241" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1281" />
- <ColumnReference Column="Union1190" />
- <ColumnReference Column="Expr1242" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1282" />
- <ColumnReference Column="Union1191" />
- <ColumnReference Column="Expr1243" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1283" />
- <ColumnReference Column="Union1192" />
- <ColumnReference Column="Expr1244" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1284" />
- <ColumnReference Column="Union1193" />
- <ColumnReference Column="Expr1245" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1285" />
- <ColumnReference Column="Union1194" />
- <ColumnReference Column="Expr1246" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1286" />
- <ColumnReference Column="Union1195" />
- <ColumnReference Column="Expr1247" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1287" />
- <ColumnReference Column="Union1196" />
- <ColumnReference Column="Expr1248" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1288" />
- <ColumnReference Column="Union1197" />
- <ColumnReference Column="Expr1249" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1289" />
- <ColumnReference Column="Union1198" />
- <ColumnReference Column="Expr1250" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1290" />
- <ColumnReference Column="Union1199" />
- <ColumnReference Column="Expr1251" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1291" />
- <ColumnReference Column="Union1200" />
- <ColumnReference Column="Expr1252" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1292" />
- <ColumnReference Column="Union1201" />
- <ColumnReference Column="Expr1253" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1293" />
- <ColumnReference Column="Union1202" />
- <ColumnReference Column="Expr1254" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1294" />
- <ColumnReference Column="Union1203" />
- <ColumnReference Column="Expr1255" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1295" />
- <ColumnReference Column="Union1204" />
- <ColumnReference Column="Expr1256" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1296" />
- <ColumnReference Column="Union1205" />
- <ColumnReference Column="Expr1257" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1297" />
- <ColumnReference Column="Union1206" />
- <ColumnReference Column="Expr1258" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1298" />
- <ColumnReference Column="Union1207" />
- <ColumnReference Column="Expr1259" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1299" />
- <ColumnReference Column="Union1208" />
- <ColumnReference Column="Expr1260" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1300" />
- <ColumnReference Column="Union1209" />
- <ColumnReference Column="Expr1261" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1301" />
- <ColumnReference Column="Union1210" />
- <ColumnReference Column="Expr1262" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1302" />
- <ColumnReference Column="Union1211" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_EvenMoreData]" Alias="[Extent9]" Column="LookupId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1303" />
- <ColumnReference Column="Union1212" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_EvenMoreData]" Alias="[Extent9]" Column="MainId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1304" />
- <ColumnReference Column="Expr1223" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_EvenMoreData]" Alias="[Extent9]" Column="MoreMoreData" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1305" />
- <ColumnReference Column="Expr1224" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_EvenMoreData]" Alias="[Extent9]" Column="Field17" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1306" />
- <ColumnReference Column="Expr1225" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_EvenMoreData]" Alias="[Extent9]" Column="Field16" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1307" />
- <ColumnReference Column="Expr1226" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_EvenMoreData]" Alias="[Extent9]" Column="Field15" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1308" />
- <ColumnReference Column="Expr1227" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_EvenMoreData]" Alias="[Extent9]" Column="Field14" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1309" />
- <ColumnReference Column="Expr1228" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_EvenMoreData]" Alias="[Extent9]" Column="Field13" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1310" />
- <ColumnReference Column="Expr1229" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_EvenMoreData]" Alias="[Extent9]" Column="Field12" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1311" />
- <ColumnReference Column="Expr1230" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_EvenMoreData]" Alias="[Extent9]" Column="Field11" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1312" />
- <ColumnReference Column="Expr1231" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_EvenMoreData]" Alias="[Extent9]" Column="Field1" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1313" />
- <ColumnReference Column="Union1222" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_EvenMoreData]" Alias="[Extent9]" Column="MainId" />
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="619" EstimateCPU="5E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="5" LogicalOp="Compute Scalar" NodeId="2" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.023176">
- <OutputList>
- <ColumnReference Column="Union1172" />
- <ColumnReference Column="Union1173" />
- <ColumnReference Column="Union1174" />
- <ColumnReference Column="Union1175" />
- <ColumnReference Column="Union1176" />
- <ColumnReference Column="Union1177" />
- <ColumnReference Column="Union1178" />
- <ColumnReference Column="Union1179" />
- <ColumnReference Column="Union1180" />
- <ColumnReference Column="Union1181" />
- <ColumnReference Column="Union1182" />
- <ColumnReference Column="Union1183" />
- <ColumnReference Column="Union1184" />
- <ColumnReference Column="Union1185" />
- <ColumnReference Column="Union1186" />
- <ColumnReference Column="Union1187" />
- <ColumnReference Column="Union1188" />
- <ColumnReference Column="Union1189" />
- <ColumnReference Column="Union1190" />
- <ColumnReference Column="Union1191" />
- <ColumnReference Column="Union1192" />
- <ColumnReference Column="Union1193" />
- <ColumnReference Column="Union1194" />
- <ColumnReference Column="Union1195" />
- <ColumnReference Column="Union1196" />
- <ColumnReference Column="Union1197" />
- <ColumnReference Column="Union1198" />
- <ColumnReference Column="Union1199" />
- <ColumnReference Column="Union1200" />
- <ColumnReference Column="Union1201" />
- <ColumnReference Column="Union1202" />
- <ColumnReference Column="Union1203" />
- <ColumnReference Column="Union1204" />
- <ColumnReference Column="Union1205" />
- <ColumnReference Column="Union1206" />
- <ColumnReference Column="Union1207" />
- <ColumnReference Column="Union1208" />
- <ColumnReference Column="Union1209" />
- <ColumnReference Column="Union1210" />
- <ColumnReference Column="Union1211" />
- <ColumnReference Column="Union1212" />
- <ColumnReference Column="Union1222" />
- <ColumnReference Column="Expr1223" />
- <ColumnReference Column="Expr1224" />
- <ColumnReference Column="Expr1225" />
- <ColumnReference Column="Expr1226" />
- <ColumnReference Column="Expr1227" />
- <ColumnReference Column="Expr1228" />
- <ColumnReference Column="Expr1229" />
- <ColumnReference Column="Expr1230" />
- <ColumnReference Column="Expr1231" />
- </OutputList>
- <ComputeScalar>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1223" />
- <ScalarOperator ScalarString="CONVERT_IMPLICIT(nvarchar(10),[Union1213],0)">
- <Convert DataType="nvarchar" Length="20" Style="0" Implicit="true">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Union1213" />
- </Identifier>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1224" />
- <ScalarOperator ScalarString="CONVERT_IMPLICIT(nvarchar(10),[Union1214],0)">
- <Convert DataType="nvarchar" Length="20" Style="0" Implicit="true">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Union1214" />
- </Identifier>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1225" />
- <ScalarOperator ScalarString="CONVERT_IMPLICIT(nvarchar(10),[Union1215],0)">
- <Convert DataType="nvarchar" Length="20" Style="0" Implicit="true">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Union1215" />
- </Identifier>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1226" />
- <ScalarOperator ScalarString="CONVERT_IMPLICIT(nvarchar(10),[Union1216],0)">
- <Convert DataType="nvarchar" Length="20" Style="0" Implicit="true">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Union1216" />
- </Identifier>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1227" />
- <ScalarOperator ScalarString="CONVERT_IMPLICIT(nvarchar(10),[Union1217],0)">
- <Convert DataType="nvarchar" Length="20" Style="0" Implicit="true">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Union1217" />
- </Identifier>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1228" />
- <ScalarOperator ScalarString="CONVERT_IMPLICIT(nvarchar(10),[Union1218],0)">
- <Convert DataType="nvarchar" Length="20" Style="0" Implicit="true">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Union1218" />
- </Identifier>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1229" />
- <ScalarOperator ScalarString="CONVERT_IMPLICIT(nvarchar(10),[Union1219],0)">
- <Convert DataType="nvarchar" Length="20" Style="0" Implicit="true">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Union1219" />
- </Identifier>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1230" />
- <ScalarOperator ScalarString="CONVERT_IMPLICIT(nvarchar(10),[Union1220],0)">
- <Convert DataType="nvarchar" Length="20" Style="0" Implicit="true">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Union1220" />
- </Identifier>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1231" />
- <ScalarOperator ScalarString="CONVERT_IMPLICIT(nvarchar(10),[Union1221],0)">
- <Convert DataType="nvarchar" Length="20" Style="0" Implicit="true">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Union1221" />
- </Identifier>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="529" EstimateCPU="5E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="5" LogicalOp="Concatenation" NodeId="3" Parallel="false" PhysicalOp="Concatenation" EstimatedTotalSubtreeCost="0.0231755">
- <OutputList>
- <ColumnReference Column="Union1172" />
- <ColumnReference Column="Union1173" />
- <ColumnReference Column="Union1174" />
- <ColumnReference Column="Union1175" />
- <ColumnReference Column="Union1176" />
- <ColumnReference Column="Union1177" />
- <ColumnReference Column="Union1178" />
- <ColumnReference Column="Union1179" />
- <ColumnReference Column="Union1180" />
- <ColumnReference Column="Union1181" />
- <ColumnReference Column="Union1182" />
- <ColumnReference Column="Union1183" />
- <ColumnReference Column="Union1184" />
- <ColumnReference Column="Union1185" />
- <ColumnReference Column="Union1186" />
- <ColumnReference Column="Union1187" />
- <ColumnReference Column="Union1188" />
- <ColumnReference Column="Union1189" />
- <ColumnReference Column="Union1190" />
- <ColumnReference Column="Union1191" />
- <ColumnReference Column="Union1192" />
- <ColumnReference Column="Union1193" />
- <ColumnReference Column="Union1194" />
- <ColumnReference Column="Union1195" />
- <ColumnReference Column="Union1196" />
- <ColumnReference Column="Union1197" />
- <ColumnReference Column="Union1198" />
- <ColumnReference Column="Union1199" />
- <ColumnReference Column="Union1200" />
- <ColumnReference Column="Union1201" />
- <ColumnReference Column="Union1202" />
- <ColumnReference Column="Union1203" />
- <ColumnReference Column="Union1204" />
- <ColumnReference Column="Union1205" />
- <ColumnReference Column="Union1206" />
- <ColumnReference Column="Union1207" />
- <ColumnReference Column="Union1208" />
- <ColumnReference Column="Union1209" />
- <ColumnReference Column="Union1210" />
- <ColumnReference Column="Union1211" />
- <ColumnReference Column="Union1212" />
- <ColumnReference Column="Union1213" />
- <ColumnReference Column="Union1214" />
- <ColumnReference Column="Union1215" />
- <ColumnReference Column="Union1216" />
- <ColumnReference Column="Union1217" />
- <ColumnReference Column="Union1218" />
- <ColumnReference Column="Union1219" />
- <ColumnReference Column="Union1220" />
- <ColumnReference Column="Union1221" />
- <ColumnReference Column="Union1222" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="6" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <Concat>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Union1172" />
- <ColumnReference Column="Union1080" />
- <ColumnReference Column="Expr1142" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1173" />
- <ColumnReference Column="Union1081" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="MainId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1174" />
- <ColumnReference Column="Union1082" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="MainId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1175" />
- <ColumnReference Column="Union1083" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field1" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1176" />
- <ColumnReference Column="Union1084" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field11" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1177" />
- <ColumnReference Column="Union1085" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field12" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1178" />
- <ColumnReference Column="Union1086" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field13" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1179" />
- <ColumnReference Column="Union1087" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field14" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1180" />
- <ColumnReference Column="Union1088" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field15" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1181" />
- <ColumnReference Column="Union1089" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field16" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1182" />
- <ColumnReference Column="Union1090" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field17" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1183" />
- <ColumnReference Column="Union1091" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field18" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1184" />
- <ColumnReference Column="Union1092" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field19" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1185" />
- <ColumnReference Column="Union1093" />
- <ColumnReference Column="Expr1143" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1186" />
- <ColumnReference Column="Union1094" />
- <ColumnReference Column="Expr1144" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1187" />
- <ColumnReference Column="Union1095" />
- <ColumnReference Column="Expr1145" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1188" />
- <ColumnReference Column="Union1096" />
- <ColumnReference Column="Expr1146" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1189" />
- <ColumnReference Column="Union1097" />
- <ColumnReference Column="Expr1147" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1190" />
- <ColumnReference Column="Union1098" />
- <ColumnReference Column="Expr1148" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1191" />
- <ColumnReference Column="Union1099" />
- <ColumnReference Column="Expr1149" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1192" />
- <ColumnReference Column="Union1100" />
- <ColumnReference Column="Expr1150" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1193" />
- <ColumnReference Column="Union1101" />
- <ColumnReference Column="Expr1151" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1194" />
- <ColumnReference Column="Union1102" />
- <ColumnReference Column="Expr1152" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1195" />
- <ColumnReference Column="Union1103" />
- <ColumnReference Column="Expr1153" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1196" />
- <ColumnReference Column="Union1104" />
- <ColumnReference Column="Expr1154" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1197" />
- <ColumnReference Column="Union1105" />
- <ColumnReference Column="Expr1155" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1198" />
- <ColumnReference Column="Union1106" />
- <ColumnReference Column="Expr1156" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1199" />
- <ColumnReference Column="Union1107" />
- <ColumnReference Column="Expr1157" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1200" />
- <ColumnReference Column="Union1108" />
- <ColumnReference Column="Expr1158" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1201" />
- <ColumnReference Column="Union1109" />
- <ColumnReference Column="Expr1159" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1202" />
- <ColumnReference Column="Union1110" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MaintTable_DataLookup]" Alias="[Extent7]" Column="MainId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1203" />
- <ColumnReference Column="Expr1131" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MaintTable_DataLookup]" Alias="[Extent7]" Column="Data" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1204" />
- <ColumnReference Column="Expr1132" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MaintTable_DataLookup]" Alias="[Extent7]" Column="Field1" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1205" />
- <ColumnReference Column="Expr1133" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MaintTable_DataLookup]" Alias="[Extent7]" Column="Field11" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1206" />
- <ColumnReference Column="Expr1134" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MaintTable_DataLookup]" Alias="[Extent7]" Column="Field12" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1207" />
- <ColumnReference Column="Expr1135" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MaintTable_DataLookup]" Alias="[Extent7]" Column="Field14" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1208" />
- <ColumnReference Column="Expr1136" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MaintTable_DataLookup]" Alias="[Extent7]" Column="Field15" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1209" />
- <ColumnReference Column="Expr1137" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MaintTable_DataLookup]" Alias="[Extent7]" Column="Field13" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1210" />
- <ColumnReference Column="Union1118" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MaintTable_DataLookup]" Alias="[Extent7]" Column="MainId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1211" />
- <ColumnReference Column="Union1119" />
- <ColumnReference Column="Expr1160" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1212" />
- <ColumnReference Column="Union1120" />
- <ColumnReference Column="Expr1161" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1213" />
- <ColumnReference Column="Union1121" />
- <ColumnReference Column="Expr1162" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1214" />
- <ColumnReference Column="Union1122" />
- <ColumnReference Column="Expr1163" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1215" />
- <ColumnReference Column="Union1123" />
- <ColumnReference Column="Expr1164" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1216" />
- <ColumnReference Column="Union1124" />
- <ColumnReference Column="Expr1165" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1217" />
- <ColumnReference Column="Union1125" />
- <ColumnReference Column="Expr1166" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1218" />
- <ColumnReference Column="Union1126" />
- <ColumnReference Column="Expr1167" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1219" />
- <ColumnReference Column="Union1127" />
- <ColumnReference Column="Expr1168" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1220" />
- <ColumnReference Column="Union1128" />
- <ColumnReference Column="Expr1169" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1221" />
- <ColumnReference Column="Union1129" />
- <ColumnReference Column="Expr1170" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1222" />
- <ColumnReference Column="Union1130" />
- <ColumnReference Column="Expr1171" />
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="529" EstimateCPU="3E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3" LogicalOp="Compute Scalar" NodeId="4" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.0165991">
- <OutputList>
- <ColumnReference Column="Union1080" />
- <ColumnReference Column="Union1081" />
- <ColumnReference Column="Union1082" />
- <ColumnReference Column="Union1083" />
- <ColumnReference Column="Union1084" />
- <ColumnReference Column="Union1085" />
- <ColumnReference Column="Union1086" />
- <ColumnReference Column="Union1087" />
- <ColumnReference Column="Union1088" />
- <ColumnReference Column="Union1089" />
- <ColumnReference Column="Union1090" />
- <ColumnReference Column="Union1091" />
- <ColumnReference Column="Union1092" />
- <ColumnReference Column="Union1093" />
- <ColumnReference Column="Union1094" />
- <ColumnReference Column="Union1095" />
- <ColumnReference Column="Union1096" />
- <ColumnReference Column="Union1097" />
- <ColumnReference Column="Union1098" />
- <ColumnReference Column="Union1099" />
- <ColumnReference Column="Union1100" />
- <ColumnReference Column="Union1101" />
- <ColumnReference Column="Union1102" />
- <ColumnReference Column="Union1103" />
- <ColumnReference Column="Union1104" />
- <ColumnReference Column="Union1105" />
- <ColumnReference Column="Union1106" />
- <ColumnReference Column="Union1107" />
- <ColumnReference Column="Union1108" />
- <ColumnReference Column="Union1109" />
- <ColumnReference Column="Union1110" />
- <ColumnReference Column="Union1118" />
- <ColumnReference Column="Union1119" />
- <ColumnReference Column="Union1120" />
- <ColumnReference Column="Union1121" />
- <ColumnReference Column="Union1122" />
- <ColumnReference Column="Union1123" />
- <ColumnReference Column="Union1124" />
- <ColumnReference Column="Union1125" />
- <ColumnReference Column="Union1126" />
- <ColumnReference Column="Union1127" />
- <ColumnReference Column="Union1128" />
- <ColumnReference Column="Union1129" />
- <ColumnReference Column="Union1130" />
- <ColumnReference Column="Expr1131" />
- <ColumnReference Column="Expr1132" />
- <ColumnReference Column="Expr1133" />
- <ColumnReference Column="Expr1134" />
- <ColumnReference Column="Expr1135" />
- <ColumnReference Column="Expr1136" />
- <ColumnReference Column="Expr1137" />
- </OutputList>
- <ComputeScalar>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1131" />
- <ScalarOperator ScalarString="CONVERT_IMPLICIT(nvarchar(10),[Union1111],0)">
- <Convert DataType="nvarchar" Length="20" Style="0" Implicit="true">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Union1111" />
- </Identifier>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1132" />
- <ScalarOperator ScalarString="CONVERT_IMPLICIT(nvarchar(10),[Union1112],0)">
- <Convert DataType="nvarchar" Length="20" Style="0" Implicit="true">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Union1112" />
- </Identifier>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1133" />
- <ScalarOperator ScalarString="CONVERT_IMPLICIT(nvarchar(10),[Union1113],0)">
- <Convert DataType="nvarchar" Length="20" Style="0" Implicit="true">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Union1113" />
- </Identifier>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1134" />
- <ScalarOperator ScalarString="CONVERT_IMPLICIT(nvarchar(10),[Union1114],0)">
- <Convert DataType="nvarchar" Length="20" Style="0" Implicit="true">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Union1114" />
- </Identifier>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1135" />
- <ScalarOperator ScalarString="CONVERT_IMPLICIT(nvarchar(10),[Union1115],0)">
- <Convert DataType="nvarchar" Length="20" Style="0" Implicit="true">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Union1115" />
- </Identifier>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1136" />
- <ScalarOperator ScalarString="CONVERT_IMPLICIT(nvarchar(10),[Union1116],0)">
- <Convert DataType="nvarchar" Length="20" Style="0" Implicit="true">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Union1116" />
- </Identifier>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1137" />
- <ScalarOperator ScalarString="CONVERT_IMPLICIT(nvarchar(10),[Union1117],0)">
- <Convert DataType="nvarchar" Length="20" Style="0" Implicit="true">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Union1117" />
- </Identifier>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="459" EstimateCPU="3E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3" LogicalOp="Concatenation" NodeId="5" Parallel="false" PhysicalOp="Concatenation" EstimatedTotalSubtreeCost="0.0165988">
- <OutputList>
- <ColumnReference Column="Union1080" />
- <ColumnReference Column="Union1081" />
- <ColumnReference Column="Union1082" />
- <ColumnReference Column="Union1083" />
- <ColumnReference Column="Union1084" />
- <ColumnReference Column="Union1085" />
- <ColumnReference Column="Union1086" />
- <ColumnReference Column="Union1087" />
- <ColumnReference Column="Union1088" />
- <ColumnReference Column="Union1089" />
- <ColumnReference Column="Union1090" />
- <ColumnReference Column="Union1091" />
- <ColumnReference Column="Union1092" />
- <ColumnReference Column="Union1093" />
- <ColumnReference Column="Union1094" />
- <ColumnReference Column="Union1095" />
- <ColumnReference Column="Union1096" />
- <ColumnReference Column="Union1097" />
- <ColumnReference Column="Union1098" />
- <ColumnReference Column="Union1099" />
- <ColumnReference Column="Union1100" />
- <ColumnReference Column="Union1101" />
- <ColumnReference Column="Union1102" />
- <ColumnReference Column="Union1103" />
- <ColumnReference Column="Union1104" />
- <ColumnReference Column="Union1105" />
- <ColumnReference Column="Union1106" />
- <ColumnReference Column="Union1107" />
- <ColumnReference Column="Union1108" />
- <ColumnReference Column="Union1109" />
- <ColumnReference Column="Union1110" />
- <ColumnReference Column="Union1111" />
- <ColumnReference Column="Union1112" />
- <ColumnReference Column="Union1113" />
- <ColumnReference Column="Union1114" />
- <ColumnReference Column="Union1115" />
- <ColumnReference Column="Union1116" />
- <ColumnReference Column="Union1117" />
- <ColumnReference Column="Union1118" />
- <ColumnReference Column="Union1119" />
- <ColumnReference Column="Union1120" />
- <ColumnReference Column="Union1121" />
- <ColumnReference Column="Union1122" />
- <ColumnReference Column="Union1123" />
- <ColumnReference Column="Union1124" />
- <ColumnReference Column="Union1125" />
- <ColumnReference Column="Union1126" />
- <ColumnReference Column="Union1127" />
- <ColumnReference Column="Union1128" />
- <ColumnReference Column="Union1129" />
- <ColumnReference Column="Union1130" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="4" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <Concat>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Union1080" />
- <ColumnReference Column="Expr1015" />
- <ColumnReference Column="Expr1050" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1081" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="MainId" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="MainId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1082" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="MainId" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="MainId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1083" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field1" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field1" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1084" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field11" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field11" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1085" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field12" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field12" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1086" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field13" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field13" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1087" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field14" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field14" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1088" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field15" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field15" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1089" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field16" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field16" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1090" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field17" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field17" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1091" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field18" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field18" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1092" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field19" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field19" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1093" />
- <ColumnReference Column="Expr1007" />
- <ColumnReference Column="Expr1051" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1094" />
- <ColumnReference Column="Expr1008" />
- <ColumnReference Column="Expr1052" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1095" />
- <ColumnReference Column="Expr1009" />
- <ColumnReference Column="Expr1053" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1096" />
- <ColumnReference Column="Expr1010" />
- <ColumnReference Column="Expr1054" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1097" />
- <ColumnReference Column="Expr1011" />
- <ColumnReference Column="Expr1055" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1098" />
- <ColumnReference Column="Expr1012" />
- <ColumnReference Column="Expr1056" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1099" />
- <ColumnReference Column="Expr1013" />
- <ColumnReference Column="Expr1057" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1100" />
- <ColumnReference Column="Expr1014" />
- <ColumnReference Column="Expr1058" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1101" />
- <ColumnReference Column="Expr1016" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_MoreData]" Alias="[Extent5]" Column="DataId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1102" />
- <ColumnReference Column="Expr1017" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_MoreData]" Alias="[Extent5]" Column="MainId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1103" />
- <ColumnReference Column="Expr1018" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_MoreData]" Alias="[Extent5]" Column="SomeData" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1104" />
- <ColumnReference Column="Expr1019" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_MoreData]" Alias="[Extent5]" Column="Field1" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1105" />
- <ColumnReference Column="Expr1020" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_MoreData]" Alias="[Extent5]" Column="Field11" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1106" />
- <ColumnReference Column="Expr1021" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_MoreData]" Alias="[Extent5]" Column="Field12" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1107" />
- <ColumnReference Column="Expr1022" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_MoreData]" Alias="[Extent5]" Column="Field13" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1108" />
- <ColumnReference Column="Expr1023" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_MoreData]" Alias="[Extent5]" Column="Field14" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1109" />
- <ColumnReference Column="Expr1024" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_MoreData]" Alias="[Extent5]" Column="Field15" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1110" />
- <ColumnReference Column="Expr1025" />
- <ColumnReference Column="Expr1059" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1111" />
- <ColumnReference Column="Expr1026" />
- <ColumnReference Column="Expr1060" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1112" />
- <ColumnReference Column="Expr1027" />
- <ColumnReference Column="Expr1061" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1113" />
- <ColumnReference Column="Expr1028" />
- <ColumnReference Column="Expr1062" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1114" />
- <ColumnReference Column="Expr1029" />
- <ColumnReference Column="Expr1063" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1115" />
- <ColumnReference Column="Expr1030" />
- <ColumnReference Column="Expr1064" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1116" />
- <ColumnReference Column="Expr1031" />
- <ColumnReference Column="Expr1065" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1117" />
- <ColumnReference Column="Expr1032" />
- <ColumnReference Column="Expr1066" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1118" />
- <ColumnReference Column="Expr1033" />
- <ColumnReference Column="Expr1067" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1119" />
- <ColumnReference Column="Expr1034" />
- <ColumnReference Column="Expr1068" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1120" />
- <ColumnReference Column="Expr1035" />
- <ColumnReference Column="Expr1069" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1121" />
- <ColumnReference Column="Expr1036" />
- <ColumnReference Column="Expr1070" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1122" />
- <ColumnReference Column="Expr1037" />
- <ColumnReference Column="Expr1071" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1123" />
- <ColumnReference Column="Expr1038" />
- <ColumnReference Column="Expr1072" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1124" />
- <ColumnReference Column="Expr1039" />
- <ColumnReference Column="Expr1073" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1125" />
- <ColumnReference Column="Expr1040" />
- <ColumnReference Column="Expr1074" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1126" />
- <ColumnReference Column="Expr1041" />
- <ColumnReference Column="Expr1075" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1127" />
- <ColumnReference Column="Expr1042" />
- <ColumnReference Column="Expr1076" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1128" />
- <ColumnReference Column="Expr1043" />
- <ColumnReference Column="Expr1077" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1129" />
- <ColumnReference Column="Expr1044" />
- <ColumnReference Column="Expr1078" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1130" />
- <ColumnReference Column="Expr1045" />
- <ColumnReference Column="Expr1079" />
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="511" EstimateCPU="1E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Compute Scalar" NodeId="6" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.0100215">
- <OutputList>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="MainId" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field1" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field11" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field12" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field13" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field14" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field15" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field16" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field17" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field18" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field19" />
- <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="Expr1017" />
- <ColumnReference Column="Expr1018" />
- <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="Expr1033" />
- <ColumnReference Column="Expr1034" />
- <ColumnReference Column="Expr1035" />
- <ColumnReference Column="Expr1036" />
- <ColumnReference Column="Expr1037" />
- <ColumnReference Column="Expr1038" />
- <ColumnReference Column="Expr1039" />
- <ColumnReference Column="Expr1040" />
- <ColumnReference Column="Expr1041" />
- <ColumnReference Column="Expr1042" />
- <ColumnReference Column="Expr1043" />
- <ColumnReference Column="Expr1044" />
- <ColumnReference Column="Expr1045" />
- </OutputList>
- <ComputeScalar>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1015" />
- <ScalarOperator ScalarString="CASE WHEN [Expr1006] IS NULL THEN NULL ELSE (1) END">
- <IF>
- <Condition>
- <ScalarOperator>
- <Compare CompareOp="IS">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Expr1006" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Condition>
- <Then>
- <ScalarOperator>
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </Then>
- <Else>
- <ScalarOperator>
- <Const ConstValue="(1)" />
- </ScalarOperator>
- </Else>
- </IF>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1016" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1017" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1018" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1019" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1020" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1021" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1022" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1023" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1024" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1025" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1026" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1027" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1028" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1029" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1030" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1031" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1032" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1033" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1034" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1035" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1036" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1037" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1038" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1039" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1040" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1041" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1042" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1043" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1044" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1045" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="361" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Left Outer Join" NodeId="7" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0100214">
- <OutputList>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="MainId" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field1" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field11" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field12" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field13" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field14" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field15" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field16" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field17" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field18" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field19" />
- <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" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="2" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <NestedLoops Optimized="false">
- <RelOp AvgRowSize="212" EstimateCPU="1E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Top" NodeId="8" Parallel="false" PhysicalOp="Top" EstimatedTotalSubtreeCost="0.0032832">
- <OutputList>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="MainId" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field1" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field11" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field12" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field13" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field14" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field15" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field16" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field17" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field18" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field19" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <Top RowCount="false" IsPercent="false" WithTies="false">
- <TopExpression>
- <ScalarOperator ScalarString="(1)">
- <Const ConstValue="(1)" />
- </ScalarOperator>
- </TopExpression>
- <RelOp AvgRowSize="212" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="9" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="1">
- <OutputList>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="MainId" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field1" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field11" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field12" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field13" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field14" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field15" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field16" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field17" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field18" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field19" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="0" ActualExecutions="1" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="MainId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field1" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field11" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field12" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field13" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field14" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field15" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field16" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field17" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field18" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="Field19" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[testing]" Schema="[dbo]" Table="[MainTable]" Index="[PK_MainTable]" Alias="[Extent1]" IndexKind="Clustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent1]" Column="MainId" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="(10)">
- <Const ConstValue="(10)" />
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </Top>
- </RelOp>
- <RelOp AvgRowSize="156" EstimateCPU="1E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Compute Scalar" NodeId="11" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.00673406">
- <OutputList>
- <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" />
- </OutputList>
- <ComputeScalar>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1007" />
- <ScalarOperator ScalarString="[testing].[dbo].[LookupTable].[LookupId] as [Extent3].[LookupId]">
- <Identifier>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[LookupTable]" Alias="[Extent3]" Column="LookupId" />
- </Identifier>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1008" />
- <ScalarOperator ScalarString="[testing].[dbo].[LookupTable].[Field16] as [Extent3].[Field16]">
- <Identifier>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[LookupTable]" Alias="[Extent3]" Column="Field16" />
- </Identifier>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1009" />
- <ScalarOperator ScalarString="[testing].[dbo].[LookupTable].[Field15] as [Extent3].[Field15]">
- <Identifier>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[LookupTable]" Alias="[Extent3]" Column="Field15" />
- </Identifier>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1010" />
- <ScalarOperator ScalarString="[testing].[dbo].[LookupTable].[Field14] as [Extent3].[Field14]">
- <Identifier>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[LookupTable]" Alias="[Extent3]" Column="Field14" />
- </Identifier>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1011" />
- <ScalarOperator ScalarString="[testing].[dbo].[LookupTable].[Field13] as [Extent3].[Field13]">
- <Identifier>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[LookupTable]" Alias="[Extent3]" Column="Field13" />
- </Identifier>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1012" />
- <ScalarOperator ScalarString="[testing].[dbo].[LookupTable].[Field12] as [Extent3].[Field12]">
- <Identifier>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[LookupTable]" Alias="[Extent3]" Column="Field12" />
- </Identifier>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1013" />
- <ScalarOperator ScalarString="[testing].[dbo].[LookupTable].[Field11] as [Extent3].[Field11]">
- <Identifier>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[LookupTable]" Alias="[Extent3]" Column="Field11" />
- </Identifier>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1014" />
- <ScalarOperator ScalarString="[testing].[dbo].[LookupTable].[Field1] as [Extent3].[Field1]">
- <Identifier>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[LookupTable]" Alias="[Extent3]" Column="Field1" />
- </Identifier>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="156" EstimateCPU="8.36E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Inner Join" NodeId="12" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.00673396">
- <OutputList>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[LookupTable]" Alias="[Extent3]" Column="LookupId" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[LookupTable]" Alias="[Extent3]" Column="Field16" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[LookupTable]" Alias="[Extent3]" Column="Field15" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[LookupTable]" Alias="[Extent3]" Column="Field14" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[LookupTable]" Alias="[Extent3]" Column="Field13" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[LookupTable]" Alias="[Extent3]" Column="Field12" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[LookupTable]" Alias="[Extent3]" Column="Field11" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[LookupTable]" Alias="[Extent3]" Column="Field1" />
- <ColumnReference Column="Expr1006" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="2" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <NestedLoops Optimized="false">
- <OuterReferences>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_LookupTable]" Alias="[Extent2]" Column="LookupId" />
- </OuterReferences>
- <RelOp AvgRowSize="15" EstimateCPU="2E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="2" LogicalOp="Compute Scalar" NodeId="13" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.0032844">
- <OutputList>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_LookupTable]" Alias="[Extent2]" Column="LookupId" />
- <ColumnReference Column="Expr1006" />
- </OutputList>
- <ComputeScalar>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1006" />
- <ScalarOperator ScalarString="[testing].[dbo].[MainTable_LookupTable].[MainId] as [Extent2].[MainId]">
- <Identifier>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_LookupTable]" Alias="[Extent2]" Column="MainId" />
- </Identifier>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="15" EstimateCPU="0.0001592" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="2" LogicalOp="Clustered Index Seek" NodeId="14" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0032842" TableCardinality="2">
- <OutputList>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_LookupTable]" Alias="[Extent2]" Column="MainId" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_LookupTable]" Alias="[Extent2]" Column="LookupId" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="2" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_LookupTable]" Alias="[Extent2]" Column="MainId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_LookupTable]" Alias="[Extent2]" Column="LookupId" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[testing]" Schema="[dbo]" Table="[MainTable_LookupTable]" Index="[PK_MainTable_LookupTable]" Alias="[Extent2]" IndexKind="Clustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_LookupTable]" Alias="[Extent2]" Column="MainId" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="(10)">
- <Const ConstValue="(10)" />
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </ComputeScalar>
- </RelOp>
- <RelOp AvgRowSize="151" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="1" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="18" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0034412" TableCardinality="2">
- <OutputList>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[LookupTable]" Alias="[Extent3]" Column="LookupId" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[LookupTable]" Alias="[Extent3]" Column="Field16" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[LookupTable]" Alias="[Extent3]" Column="Field15" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[LookupTable]" Alias="[Extent3]" Column="Field14" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[LookupTable]" Alias="[Extent3]" Column="Field13" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[LookupTable]" Alias="[Extent3]" Column="Field12" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[LookupTable]" Alias="[Extent3]" Column="Field11" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[LookupTable]" Alias="[Extent3]" Column="Field1" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="2" ActualEndOfScans="0" ActualExecutions="2" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[LookupTable]" Alias="[Extent3]" Column="LookupId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[LookupTable]" Alias="[Extent3]" Column="Field16" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[LookupTable]" Alias="[Extent3]" Column="Field15" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[LookupTable]" Alias="[Extent3]" Column="Field14" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[LookupTable]" Alias="[Extent3]" Column="Field13" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[LookupTable]" Alias="[Extent3]" Column="Field12" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[LookupTable]" Alias="[Extent3]" Column="Field11" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[LookupTable]" Alias="[Extent3]" Column="Field1" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[testing]" Schema="[dbo]" Table="[LookupTable]" Index="[PK_LookupTable]" Alias="[Extent3]" IndexKind="Clustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[LookupTable]" Alias="[Extent3]" Column="LookupId" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[testing].[dbo].[MainTable_LookupTable].[LookupId] as [Extent2].[LookupId]">
- <Identifier>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_LookupTable]" Alias="[Extent2]" Column="LookupId" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- </ComputeScalar>
- </RelOp>
- </NestedLoops>
- </RelOp>
- </ComputeScalar>
- </RelOp>
- <RelOp AvgRowSize="511" EstimateCPU="2E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="2" LogicalOp="Compute Scalar" NodeId="99" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.00657692">
- <OutputList>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="MainId" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field1" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field11" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field12" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field13" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field14" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field15" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field16" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field17" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field18" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field19" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_MoreData]" Alias="[Extent5]" Column="DataId" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_MoreData]" Alias="[Extent5]" Column="MainId" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_MoreData]" Alias="[Extent5]" Column="SomeData" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_MoreData]" Alias="[Extent5]" Column="Field1" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_MoreData]" Alias="[Extent5]" Column="Field11" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_MoreData]" Alias="[Extent5]" Column="Field12" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_MoreData]" Alias="[Extent5]" Column="Field13" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_MoreData]" Alias="[Extent5]" Column="Field14" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_MoreData]" Alias="[Extent5]" Column="Field15" />
- <ColumnReference Column="Expr1050" />
- <ColumnReference Column="Expr1051" />
- <ColumnReference Column="Expr1052" />
- <ColumnReference Column="Expr1053" />
- <ColumnReference Column="Expr1054" />
- <ColumnReference Column="Expr1055" />
- <ColumnReference Column="Expr1056" />
- <ColumnReference Column="Expr1057" />
- <ColumnReference Column="Expr1058" />
- <ColumnReference Column="Expr1059" />
- <ColumnReference Column="Expr1060" />
- <ColumnReference Column="Expr1061" />
- <ColumnReference Column="Expr1062" />
- <ColumnReference Column="Expr1063" />
- <ColumnReference Column="Expr1064" />
- <ColumnReference Column="Expr1065" />
- <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="Expr1078" />
- <ColumnReference Column="Expr1079" />
- </OutputList>
- <ComputeScalar>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1050" />
- <ScalarOperator ScalarString="(2)">
- <Const ConstValue="(2)" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1051" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1052" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1053" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1054" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1055" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1056" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1057" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1058" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1059" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1060" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1061" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1062" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1063" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1064" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1065" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1066" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1067" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1068" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1069" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1070" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1071" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1072" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1073" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1074" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1075" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1076" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1077" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1078" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1079" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="361" EstimateCPU="8.36E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="2" LogicalOp="Inner Join" NodeId="100" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.00657672">
- <OutputList>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="MainId" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field1" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field11" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field12" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field13" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field14" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field15" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field16" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field17" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field18" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field19" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_MoreData]" Alias="[Extent5]" Column="DataId" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_MoreData]" Alias="[Extent5]" Column="MainId" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_MoreData]" Alias="[Extent5]" Column="SomeData" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_MoreData]" Alias="[Extent5]" Column="Field1" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_MoreData]" Alias="[Extent5]" Column="Field11" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_MoreData]" Alias="[Extent5]" Column="Field12" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_MoreData]" Alias="[Extent5]" Column="Field13" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_MoreData]" Alias="[Extent5]" Column="Field14" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_MoreData]" Alias="[Extent5]" Column="Field15" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="2" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <NestedLoops Optimized="false">
- <RelOp AvgRowSize="212" EstimateCPU="1E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Top" NodeId="101" Parallel="false" PhysicalOp="Top" EstimatedTotalSubtreeCost="0.0032832">
- <OutputList>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="MainId" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field1" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field11" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field12" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field13" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field14" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field15" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field16" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field17" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field18" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field19" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <Top RowCount="false" IsPercent="false" WithTies="false">
- <TopExpression>
- <ScalarOperator ScalarString="(1)">
- <Const ConstValue="(1)" />
- </ScalarOperator>
- </TopExpression>
- <RelOp AvgRowSize="212" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="102" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="1">
- <OutputList>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="MainId" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field1" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field11" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field12" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field13" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field14" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field15" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field16" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field17" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field18" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field19" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="0" ActualExecutions="1" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="MainId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field1" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field11" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field12" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field13" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field14" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field15" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field16" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field17" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field18" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="Field19" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[testing]" Schema="[dbo]" Table="[MainTable]" Index="[PK_MainTable]" Alias="[Extent4]" IndexKind="Clustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent4]" Column="MainId" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="(10)">
- <Const ConstValue="(10)" />
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </Top>
- </RelOp>
- <RelOp AvgRowSize="156" EstimateCPU="0.0001592" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="2" LogicalOp="Clustered Index Scan" NodeId="104" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0032842" TableCardinality="2">
- <OutputList>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_MoreData]" Alias="[Extent5]" Column="DataId" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_MoreData]" Alias="[Extent5]" Column="MainId" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_MoreData]" Alias="[Extent5]" Column="SomeData" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_MoreData]" Alias="[Extent5]" Column="Field1" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_MoreData]" Alias="[Extent5]" Column="Field11" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_MoreData]" Alias="[Extent5]" Column="Field12" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_MoreData]" Alias="[Extent5]" Column="Field13" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_MoreData]" Alias="[Extent5]" Column="Field14" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_MoreData]" Alias="[Extent5]" Column="Field15" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="2" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <IndexScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_MoreData]" Alias="[Extent5]" Column="DataId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_MoreData]" Alias="[Extent5]" Column="MainId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_MoreData]" Alias="[Extent5]" Column="SomeData" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_MoreData]" Alias="[Extent5]" Column="Field1" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_MoreData]" Alias="[Extent5]" Column="Field11" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_MoreData]" Alias="[Extent5]" Column="Field12" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_MoreData]" Alias="[Extent5]" Column="Field13" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_MoreData]" Alias="[Extent5]" Column="Field14" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_MoreData]" Alias="[Extent5]" Column="Field15" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[testing]" Schema="[dbo]" Table="[MainTable_MoreData]" Index="[PK_MainTable_MoreData]" Alias="[Extent5]" IndexKind="Clustered" />
- <Predicate>
- <ScalarOperator ScalarString="[testing].[dbo].[MainTable_MoreData].[MainId] as [Extent5].[MainId]=(10)">
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_MoreData]" Alias="[Extent5]" Column="MainId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(10)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Predicate>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- </ComputeScalar>
- </RelOp>
- </Concat>
- </RelOp>
- </ComputeScalar>
- </RelOp>
- <RelOp AvgRowSize="577" EstimateCPU="2E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="2" LogicalOp="Compute Scalar" NodeId="181" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.00657596">
- <OutputList>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="MainId" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field1" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field11" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field12" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field13" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field14" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field15" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field16" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field17" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field18" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field19" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MaintTable_DataLookup]" Alias="[Extent7]" Column="MainId" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MaintTable_DataLookup]" Alias="[Extent7]" Column="Data" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MaintTable_DataLookup]" Alias="[Extent7]" Column="Field1" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MaintTable_DataLookup]" Alias="[Extent7]" Column="Field11" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MaintTable_DataLookup]" Alias="[Extent7]" Column="Field12" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MaintTable_DataLookup]" Alias="[Extent7]" Column="Field14" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MaintTable_DataLookup]" Alias="[Extent7]" Column="Field15" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MaintTable_DataLookup]" Alias="[Extent7]" Column="Field13" />
- <ColumnReference Column="Expr1142" />
- <ColumnReference Column="Expr1143" />
- <ColumnReference Column="Expr1144" />
- <ColumnReference Column="Expr1145" />
- <ColumnReference Column="Expr1146" />
- <ColumnReference Column="Expr1147" />
- <ColumnReference Column="Expr1148" />
- <ColumnReference Column="Expr1149" />
- <ColumnReference Column="Expr1150" />
- <ColumnReference Column="Expr1151" />
- <ColumnReference Column="Expr1152" />
- <ColumnReference Column="Expr1153" />
- <ColumnReference Column="Expr1154" />
- <ColumnReference Column="Expr1155" />
- <ColumnReference Column="Expr1156" />
- <ColumnReference Column="Expr1157" />
- <ColumnReference Column="Expr1158" />
- <ColumnReference Column="Expr1159" />
- <ColumnReference Column="Expr1160" />
- <ColumnReference Column="Expr1161" />
- <ColumnReference Column="Expr1162" />
- <ColumnReference Column="Expr1163" />
- <ColumnReference Column="Expr1164" />
- <ColumnReference Column="Expr1165" />
- <ColumnReference Column="Expr1166" />
- <ColumnReference Column="Expr1167" />
- <ColumnReference Column="Expr1168" />
- <ColumnReference Column="Expr1169" />
- <ColumnReference Column="Expr1170" />
- <ColumnReference Column="Expr1171" />
- </OutputList>
- <ComputeScalar>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1142" />
- <ScalarOperator ScalarString="(3)">
- <Const ConstValue="(3)" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1143" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1144" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1145" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1146" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1147" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1148" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1149" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1150" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1151" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1152" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1153" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1154" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1155" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1156" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1157" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1158" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1159" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1160" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1161" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1162" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1163" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1164" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1165" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1166" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1167" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1168" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1169" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1170" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1171" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="357" EstimateCPU="8.36E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="2" LogicalOp="Inner Join" NodeId="182" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.00657576">
- <OutputList>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="MainId" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field1" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field11" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field12" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field13" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field14" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field15" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field16" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field17" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field18" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field19" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MaintTable_DataLookup]" Alias="[Extent7]" Column="MainId" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MaintTable_DataLookup]" Alias="[Extent7]" Column="Data" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MaintTable_DataLookup]" Alias="[Extent7]" Column="Field1" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MaintTable_DataLookup]" Alias="[Extent7]" Column="Field11" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MaintTable_DataLookup]" Alias="[Extent7]" Column="Field12" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MaintTable_DataLookup]" Alias="[Extent7]" Column="Field14" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MaintTable_DataLookup]" Alias="[Extent7]" Column="Field15" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MaintTable_DataLookup]" Alias="[Extent7]" Column="Field13" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="2" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <NestedLoops Optimized="false">
- <RelOp AvgRowSize="212" EstimateCPU="1E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Top" NodeId="183" Parallel="false" PhysicalOp="Top" EstimatedTotalSubtreeCost="0.0032832">
- <OutputList>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="MainId" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field1" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field11" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field12" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field13" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field14" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field15" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field16" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field17" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field18" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field19" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <Top RowCount="false" IsPercent="false" WithTies="false">
- <TopExpression>
- <ScalarOperator ScalarString="(1)">
- <Const ConstValue="(1)" />
- </ScalarOperator>
- </TopExpression>
- <RelOp AvgRowSize="212" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="184" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="1">
- <OutputList>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="MainId" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field1" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field11" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field12" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field13" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field14" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field15" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field16" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field17" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field18" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field19" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="0" ActualExecutions="1" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="MainId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field1" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field11" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field12" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field13" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field14" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field15" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field16" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field17" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field18" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="Field19" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[testing]" Schema="[dbo]" Table="[MainTable]" Index="[PK_MainTable]" Alias="[Extent6]" IndexKind="Clustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent6]" Column="MainId" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="(10)">
- <Const ConstValue="(10)" />
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </Top>
- </RelOp>
- <RelOp AvgRowSize="151" EstimateCPU="0.0001592" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="2" LogicalOp="Clustered Index Seek" NodeId="186" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0032842" TableCardinality="2">
- <OutputList>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MaintTable_DataLookup]" Alias="[Extent7]" Column="MainId" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MaintTable_DataLookup]" Alias="[Extent7]" Column="Data" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MaintTable_DataLookup]" Alias="[Extent7]" Column="Field1" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MaintTable_DataLookup]" Alias="[Extent7]" Column="Field11" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MaintTable_DataLookup]" Alias="[Extent7]" Column="Field12" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MaintTable_DataLookup]" Alias="[Extent7]" Column="Field14" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MaintTable_DataLookup]" Alias="[Extent7]" Column="Field15" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MaintTable_DataLookup]" Alias="[Extent7]" Column="Field13" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="2" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MaintTable_DataLookup]" Alias="[Extent7]" Column="MainId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MaintTable_DataLookup]" Alias="[Extent7]" Column="Data" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MaintTable_DataLookup]" Alias="[Extent7]" Column="Field1" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MaintTable_DataLookup]" Alias="[Extent7]" Column="Field11" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MaintTable_DataLookup]" Alias="[Extent7]" Column="Field12" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MaintTable_DataLookup]" Alias="[Extent7]" Column="Field14" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MaintTable_DataLookup]" Alias="[Extent7]" Column="Field15" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MaintTable_DataLookup]" Alias="[Extent7]" Column="Field13" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[testing]" Schema="[dbo]" Table="[MaintTable_DataLookup]" Index="[PK_MaintTable_DataLookup]" Alias="[Extent7]" IndexKind="Clustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MaintTable_DataLookup]" Alias="[Extent7]" Column="MainId" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="(10)">
- <Const ConstValue="(10)" />
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- </ComputeScalar>
- </RelOp>
- </Concat>
- </RelOp>
- </ComputeScalar>
- </RelOp>
- <RelOp AvgRowSize="683" EstimateCPU="2E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="2" LogicalOp="Compute Scalar" NodeId="267" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.00657692">
- <OutputList>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="MainId" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field1" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field11" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field12" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field13" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field14" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field15" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field16" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field17" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field18" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field19" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_EvenMoreData]" Alias="[Extent9]" Column="LookupId" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_EvenMoreData]" Alias="[Extent9]" Column="MainId" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_EvenMoreData]" Alias="[Extent9]" Column="MoreMoreData" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_EvenMoreData]" Alias="[Extent9]" Column="Field17" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_EvenMoreData]" Alias="[Extent9]" Column="Field16" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_EvenMoreData]" Alias="[Extent9]" Column="Field15" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_EvenMoreData]" Alias="[Extent9]" Column="Field14" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_EvenMoreData]" Alias="[Extent9]" Column="Field13" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_EvenMoreData]" Alias="[Extent9]" Column="Field12" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_EvenMoreData]" Alias="[Extent9]" Column="Field11" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_EvenMoreData]" Alias="[Extent9]" Column="Field1" />
- <ColumnReference Column="Expr1236" />
- <ColumnReference Column="Expr1237" />
- <ColumnReference Column="Expr1238" />
- <ColumnReference Column="Expr1239" />
- <ColumnReference Column="Expr1240" />
- <ColumnReference Column="Expr1241" />
- <ColumnReference Column="Expr1242" />
- <ColumnReference Column="Expr1243" />
- <ColumnReference Column="Expr1244" />
- <ColumnReference Column="Expr1245" />
- <ColumnReference Column="Expr1246" />
- <ColumnReference Column="Expr1247" />
- <ColumnReference Column="Expr1248" />
- <ColumnReference Column="Expr1249" />
- <ColumnReference Column="Expr1250" />
- <ColumnReference Column="Expr1251" />
- <ColumnReference Column="Expr1252" />
- <ColumnReference Column="Expr1253" />
- <ColumnReference Column="Expr1254" />
- <ColumnReference Column="Expr1255" />
- <ColumnReference Column="Expr1256" />
- <ColumnReference Column="Expr1257" />
- <ColumnReference Column="Expr1258" />
- <ColumnReference Column="Expr1259" />
- <ColumnReference Column="Expr1260" />
- <ColumnReference Column="Expr1261" />
- <ColumnReference Column="Expr1262" />
- </OutputList>
- <ComputeScalar>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1236" />
- <ScalarOperator ScalarString="(4)">
- <Const ConstValue="(4)" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1237" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1238" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1239" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1240" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1241" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1242" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1243" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1244" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1245" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1246" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1247" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1248" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1249" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1250" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1251" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1252" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1253" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1254" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1255" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1256" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1257" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1258" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1259" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1260" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1261" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1262" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="401" EstimateCPU="8.36E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="2" LogicalOp="Inner Join" NodeId="268" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.00657672">
- <OutputList>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="MainId" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field1" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field11" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field12" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field13" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field14" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field15" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field16" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field17" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field18" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field19" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_EvenMoreData]" Alias="[Extent9]" Column="LookupId" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_EvenMoreData]" Alias="[Extent9]" Column="MainId" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_EvenMoreData]" Alias="[Extent9]" Column="MoreMoreData" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_EvenMoreData]" Alias="[Extent9]" Column="Field17" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_EvenMoreData]" Alias="[Extent9]" Column="Field16" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_EvenMoreData]" Alias="[Extent9]" Column="Field15" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_EvenMoreData]" Alias="[Extent9]" Column="Field14" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_EvenMoreData]" Alias="[Extent9]" Column="Field13" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_EvenMoreData]" Alias="[Extent9]" Column="Field12" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_EvenMoreData]" Alias="[Extent9]" Column="Field11" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_EvenMoreData]" Alias="[Extent9]" Column="Field1" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="2" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <NestedLoops Optimized="false">
- <RelOp AvgRowSize="212" EstimateCPU="1E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Top" NodeId="269" Parallel="false" PhysicalOp="Top" EstimatedTotalSubtreeCost="0.0032832">
- <OutputList>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="MainId" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field1" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field11" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field12" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field13" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field14" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field15" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field16" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field17" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field18" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field19" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <Top RowCount="false" IsPercent="false" WithTies="false">
- <TopExpression>
- <ScalarOperator ScalarString="(1)">
- <Const ConstValue="(1)" />
- </ScalarOperator>
- </TopExpression>
- <RelOp AvgRowSize="212" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="270" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="1">
- <OutputList>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="MainId" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field1" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field11" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field12" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field13" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field14" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field15" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field16" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field17" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field18" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field19" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="0" ActualExecutions="1" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="MainId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field1" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field11" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field12" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field13" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field14" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field15" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field16" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field17" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field18" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="Field19" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[testing]" Schema="[dbo]" Table="[MainTable]" Index="[PK_MainTable]" Alias="[Extent8]" IndexKind="Clustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable]" Alias="[Extent8]" Column="MainId" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="(10)">
- <Const ConstValue="(10)" />
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </Top>
- </RelOp>
- <RelOp AvgRowSize="196" EstimateCPU="0.0001592" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="2" LogicalOp="Clustered Index Scan" NodeId="272" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0032842" TableCardinality="2">
- <OutputList>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_EvenMoreData]" Alias="[Extent9]" Column="LookupId" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_EvenMoreData]" Alias="[Extent9]" Column="MainId" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_EvenMoreData]" Alias="[Extent9]" Column="MoreMoreData" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_EvenMoreData]" Alias="[Extent9]" Column="Field17" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_EvenMoreData]" Alias="[Extent9]" Column="Field16" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_EvenMoreData]" Alias="[Extent9]" Column="Field15" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_EvenMoreData]" Alias="[Extent9]" Column="Field14" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_EvenMoreData]" Alias="[Extent9]" Column="Field13" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_EvenMoreData]" Alias="[Extent9]" Column="Field12" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_EvenMoreData]" Alias="[Extent9]" Column="Field11" />
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_EvenMoreData]" Alias="[Extent9]" Column="Field1" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="2" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <IndexScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_EvenMoreData]" Alias="[Extent9]" Column="LookupId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_EvenMoreData]" Alias="[Extent9]" Column="MainId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_EvenMoreData]" Alias="[Extent9]" Column="MoreMoreData" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_EvenMoreData]" Alias="[Extent9]" Column="Field17" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_EvenMoreData]" Alias="[Extent9]" Column="Field16" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_EvenMoreData]" Alias="[Extent9]" Column="Field15" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_EvenMoreData]" Alias="[Extent9]" Column="Field14" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_EvenMoreData]" Alias="[Extent9]" Column="Field13" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_EvenMoreData]" Alias="[Extent9]" Column="Field12" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_EvenMoreData]" Alias="[Extent9]" Column="Field11" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_EvenMoreData]" Alias="[Extent9]" Column="Field1" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[testing]" Schema="[dbo]" Table="[MainTable_EvenMoreData]" Index="[PK_MainTable_EvenMoreData]" Alias="[Extent9]" IndexKind="Clustered" />
- <Predicate>
- <ScalarOperator ScalarString="[testing].[dbo].[MainTable_EvenMoreData].[MainId] as [Extent9].[MainId]=(10)">
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[testing]" Schema="[dbo]" Table="[MainTable_EvenMoreData]" Alias="[Extent9]" Column="MainId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(10)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Predicate>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- </ComputeScalar>
- </RelOp>
- </Concat>
- </RelOp>
- </Sort>
- </RelOp>
- </QueryPlan>
- </StmtSimple>
- </Statements>
- </Batch>
- </BatchSequence>
- </ShowPlanXML>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement