dexter/DBAdmin
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
master
DBAdmin/journals/incidents/INC0794075/after.sqlplan
T
Paweł Domański 64944cf004 May 17, 2026, 11:40 PM
2026-05-18 06:40:19 +00:00

313 lines
66 KiB
XML
Raw Permalink Blame History

<?xml version="1.0" encoding="utf-16"?>
<ShowPlanXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="1.539" Build="15.0.4455.2" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
<BatchSequence>
<Batch>
<Statements>
<StmtSimple StatementCompId="1" StatementEstRows="1" StatementId="2" StatementOptmLevel="FULL" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="150" StatementSubTreeCost="0.00657038" StatementText="SELECT [ol1_0].[TransactionNo],[ol1_0].[AccessType],[ol1_0].[Amount],[ol1_0].[AmountIncludingVAT],[ol1_0].[BID],[ol1_0].[BillToCustomerNo],[ol1_0].[BookingDate],[ol1_0].[CampaignNo],[ol1_0].[Description],[ol1_0].[GlobalUsageID],[ol1_0].[LineDiscount],[ol1_0].[LineDiscountAmount],[ol1_0].[MasterSubscriptionNo],[ol1_0].[OrderDate],[ol1_0].[OrderLineNo],[ol1_0].[OrderNo],[ol1_0].[PricelistCode],[ol1_0].[ProductCode],[ol1_0].[Quantity],[ol1_0].[QuantityInvoiced],[ol1_0].[QuantityShipped],[ol1_0].[QuantityShippedNotInvoiced],[ol1_0].[QuantityToInvoice],[ol1_0].[QuantityToShip],[ol1_0].[SellToCustomerNo],[ol1_0].[ShipToCustomerNo],[ol1_0].[ShipmentDate],[ol1_0].[ShipmentNo],[ol1_0].[ShippedNotInvoiced],[ol1_0].[SubjectCity],[ol1_0].[SubjectCountryCode],[ol1_0].[SubjectName],[ol1_0].[SubjectNo],[ol1_0].[SubjectSupplierCountryCode],[ol1_0].[SubjectUserId],[ol1_0].[SubscriptionNo],[ol1_0].[UnitCost],[ol1_0].[UnitOfMeasure],[ol1_0].[UnitPrice],[ol1_0].[VAT] FROM [XML_SubscriptionOrderLine] [ol1_0] WHERE [ol1_0].[OrderLineNo]=@1" StatementType="SELECT" QueryHash="0xFCB815D5AFA1775F" QueryPlanHash="0x87CC4A072F9EBC57" RetrievedFromCache="false" StatementSqlHandle="0x0900F75AD16A0880B4F5611F7A522E1BC86D0000000000000000000000000000000000000000000000000000" DatabaseContextSettingsId="8" ParentObjectId="0" StatementParameterizationType="0" SecurityPolicyApplied="false">
<StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" />
<QueryPlan DegreeOfParallelism="1" MemoryGrant="1024" CachedPlanSize="88" CompileTime="4" CompileCPU="4" CompileMemory="472">
<MemoryGrantInfo SerialRequiredMemory="512" SerialDesiredMemory="544" RequiredMemory="512" DesiredMemory="544" RequestedMemory="1024" GrantWaitTime="0" GrantedMemory="1024" MaxUsedMemory="0" MaxQueryMemory="3866152" LastRequestedMemory="0" IsMemoryGrantFeedbackAdjusted="No: First Execution" />
<OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="267059" EstimatedPagesCached="133529" EstimatedAvailableDegreeOfParallelism="4" MaxCompileMemory="12719712" />
<OptimizerStatsUsage>
<StatisticsInfo Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Statistics="[idx_tmp_XML_SubscriptionOrderLine]" ModificationCount="0" SamplingPercent="100" LastUpdate="2026-04-20T15:06:34.35" />
<StatisticsInfo Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Statistics="[_WA_Sys_00000003_24927208]" ModificationCount="0" SamplingPercent="0.821795" LastUpdate="2026-04-20T15:03:48.29" />
<StatisticsInfo Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Statistics="[PK_XMLSubscriptionOrderLine]" ModificationCount="43690" SamplingPercent="0.822175" LastUpdate="2026-04-17T13:49:20.62" />
</OptimizerStatsUsage>
<WaitStats>
<Wait WaitType="ASYNC_NETWORK_IO" WaitTimeMs="144" WaitCount="1" />
</WaitStats>
<QueryTimeStats CpuTime="0" ElapsedTime="145" />
<RelOp AvgRowSize="589" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Inner Join" NodeId="0" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.00657038">
<OutputList>
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="TransactionNo" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="OrderLineNo" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="OrderNo" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="SubscriptionNo" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="MasterSubscriptionNo" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="SellToCustomerNo" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="BillToCustomerNo" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="ShipToCustomerNo" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="OrderDate" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="BookingDate" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="ShipmentDate" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="Description" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="UnitOfMeasure" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="Quantity" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="QuantityToInvoice" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="QuantityToShip" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="UnitPrice" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="UnitCost" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="VAT" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="LineDiscount" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="LineDiscountAmount" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="Amount" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="AmountIncludingVAT" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="QuantityShippedNotInvoiced" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="ShippedNotInvoiced" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="QuantityShipped" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="QuantityInvoiced" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="ShipmentNo" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="ProductCode" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="AccessType" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="SubjectUserId" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="SubjectNo" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="SubjectName" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="SubjectCity" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="SubjectCountryCode" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="SubjectSupplierCountryCode" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="PricelistCode" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="CampaignNo" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="GlobalUsageID" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="BID" />
</OutputList>
<MemoryFractions Input="0" Output="1" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" InputMemoryGrant="0" OutputMemoryGrant="1024" UsedMemoryGrant="0" />
</RunTimeInformation>
<NestedLoops Optimized="true">
<OuterReferences>
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="TransactionNo" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="OrderLineNo" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="OrderNo" />
</OuterReferences>
<RelOp AvgRowSize="108" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" EstimatedRowsRead="1" LogicalOp="Index Seek" NodeId="2" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="22466500">
<OutputList>
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="TransactionNo" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="OrderLineNo" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="OrderNo" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="4" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
</RunTimeInformation>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="TransactionNo" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="OrderLineNo" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="OrderNo" />
</DefinedValue>
</DefinedValues>
<Object Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Index="[idx_tmp_XML_SubscriptionOrderLine]" Alias="[ol1_0]" IndexKind="NonClustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="OrderLineNo" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="'5E36B652-B41C-404E-9D75-028609740FF9'">
<Const ConstValue="'5E36B652-B41C-404E-9D75-028609740FF9'" />
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
<RelOp AvgRowSize="490" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="4" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="22466500">
<OutputList>
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="SubscriptionNo" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="MasterSubscriptionNo" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="SellToCustomerNo" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="BillToCustomerNo" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="ShipToCustomerNo" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="OrderDate" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="BookingDate" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="ShipmentDate" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="Description" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="UnitOfMeasure" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="Quantity" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="QuantityToInvoice" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="QuantityToShip" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="UnitPrice" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="UnitCost" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="VAT" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="LineDiscount" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="LineDiscountAmount" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="Amount" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="AmountIncludingVAT" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="QuantityShippedNotInvoiced" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="ShippedNotInvoiced" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="QuantityShipped" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="QuantityInvoiced" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="ShipmentNo" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="ProductCode" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="AccessType" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="SubjectUserId" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="SubjectNo" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="SubjectName" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="SubjectCity" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="SubjectCountryCode" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="SubjectSupplierCountryCode" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="PricelistCode" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="CampaignNo" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="GlobalUsageID" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="BID" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
</RunTimeInformation>
<IndexScan Lookup="true" Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="SubscriptionNo" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="MasterSubscriptionNo" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="SellToCustomerNo" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="BillToCustomerNo" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="ShipToCustomerNo" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="OrderDate" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="BookingDate" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="ShipmentDate" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="Description" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="UnitOfMeasure" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="Quantity" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="QuantityToInvoice" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="QuantityToShip" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="UnitPrice" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="UnitCost" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="VAT" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="LineDiscount" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="LineDiscountAmount" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="Amount" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="AmountIncludingVAT" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="QuantityShippedNotInvoiced" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="ShippedNotInvoiced" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="QuantityShipped" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="QuantityInvoiced" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="ShipmentNo" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="ProductCode" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="AccessType" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="SubjectUserId" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="SubjectNo" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="SubjectName" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="SubjectCity" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="SubjectCountryCode" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="SubjectSupplierCountryCode" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="PricelistCode" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="CampaignNo" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="GlobalUsageID" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="BID" />
</DefinedValue>
</DefinedValues>
<Object Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Index="[PK_XMLSubscriptionOrderLine]" Alias="[ol1_0]" TableReferenceId="-1" IndexKind="Clustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="TransactionNo" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="OrderNo" />
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="OrderLineNo" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[AboSystem_DNB].[dbo].[XML_SubscriptionOrderLine].[TransactionNo] as [ol1_0].[TransactionNo]">
<Identifier>
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="TransactionNo" />
</Identifier>
</ScalarOperator>
<ScalarOperator ScalarString="[AboSystem_DNB].[dbo].[XML_SubscriptionOrderLine].[OrderNo] as [ol1_0].[OrderNo]">
<Identifier>
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="OrderNo" />
</Identifier>
</ScalarOperator>
<ScalarOperator ScalarString="[AboSystem_DNB].[dbo].[XML_SubscriptionOrderLine].[OrderLineNo] as [ol1_0].[OrderLineNo]">
<Identifier>
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="OrderLineNo" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<ParameterList>
<ColumnReference Column="@1" ParameterDataType="varchar(8000)" ParameterCompiledValue="'5E36B652-B41C-404E-9D75-028609740FF9'" ParameterRuntimeValue="'5E36B652-B41C-404E-9D75-028609740FF9'" />
</ParameterList>
</QueryPlan>
</StmtSimple>
</Statements>
</Batch>
</BatchSequence>
</ShowPlanXML>
Reference in New Issue View Git Blame Copy Permalink