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

284 lines
61 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.00389" StatementId="2" StatementOptmLevel="FULL" CardinalityEstimationModelVersion="150" StatementSubTreeCost="812.959" 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="0xA0F3DF8157155C31" RetrievedFromCache="true" StatementSqlHandle="0x09000BC59B4C21C9EE3095F8360DA83D34D40000000000000000000000000000000000000000000000000000" DatabaseContextSettingsId="8" ParentObjectId="0" StatementParameterizationType="2" 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="4" MemoryGrant="72" CachedPlanSize="64" CompileTime="954" CompileCPU="868" CompileMemory="352">
<ThreadStat Branches="1" UsedThreads="4">
<ThreadReservation NodeId="0" ReservedThreads="4" />
</ThreadStat>
<MissingIndexes>
<MissingIndexGroup Impact="99.996">
<MissingIndex Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]">
<ColumnGroup Usage="EQUALITY">
<Column Name="[OrderLineNo]" ColumnId="2" />
</ColumnGroup>
</MissingIndex>
</MissingIndexGroup>
</MissingIndexes>
<MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0" RequiredMemory="72" DesiredMemory="72" RequestedMemory="72" GrantWaitTime="0" GrantedMemory="72" MaxUsedMemory="72" MaxQueryMemory="3866240" />
<OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="267059" EstimatedPagesCached="133529" EstimatedAvailableDegreeOfParallelism="4" MaxCompileMemory="12727240" />
<OptimizerStatsUsage>
<StatisticsInfo Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Statistics="[_WA_Sys_00000002_24927208]" ModificationCount="86723" SamplingPercent="0.823376" LastUpdate="2026-04-13T03:22:34.83" />
<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="PAGEIOLATCH_SH" WaitTimeMs="7660" WaitCount="4557" />
<Wait WaitType="SOS_SCHEDULER_YIELD" WaitTimeMs="3692" WaitCount="3955" />
<Wait WaitType="MEMORY_ALLOCATION_EXT" WaitTimeMs="960" WaitCount="534887" />
<Wait WaitType="LATCH_EX" WaitTimeMs="20" WaitCount="195" />
</WaitStats>
<QueryTimeStats CpuTime="23813" ElapsedTime="9144" />
<RelOp AvgRowSize="589" EstimateCPU="0.0285606" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.00389" LogicalOp="Gather Streams" NodeId="0" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="812.959">
<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>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="9138" ActualCPUms="0" />
</RunTimeInformation>
<Parallelism>
<RelOp AvgRowSize="589" EstimateCPU="6.17834" EstimateIO="804.056" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.00389" EstimatedRowsRead="22466500" LogicalOp="Clustered Index Scan" NodeId="1" Parallel="true" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="810.234" 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" />
<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="4" ActualRows="0" ActualRowsRead="5015077" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="6934" ActualCPUms="5493" ActualScans="1" ActualLogicalReads="256498" ActualPhysicalReads="0" ActualReadAheads="177405" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="3" ActualRows="0" ActualRowsRead="5295628" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="7565" ActualCPUms="5103" ActualScans="1" ActualLogicalReads="270393" ActualPhysicalReads="0" ActualReadAheads="189294" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="2" ActualRows="0" ActualRowsRead="6817536" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="9137" ActualCPUms="7656" ActualScans="1" ActualLogicalReads="345604" ActualPhysicalReads="0" ActualReadAheads="264324" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="1" ActualRows="0" ActualRowsRead="5338300" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="7313" ActualCPUms="5551" ActualScans="1" ActualLogicalReads="272393" ActualPhysicalReads="0" ActualReadAheads="193190" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="608" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
</RunTimeInformation>
<IndexScan Ordered="false" ForcedIndex="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>
<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]" IndexKind="Clustered" Storage="RowStore" />
<Predicate>
<ScalarOperator ScalarString="[AboSystem_DNB].[dbo].[XML_SubscriptionOrderLine].[OrderLineNo] as [ol1_0].[OrderLineNo]=[@1]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[AboSystem_DNB]" Schema="[dbo]" Table="[XML_SubscriptionOrderLine]" Alias="[ol1_0]" Column="OrderLineNo" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Column="@1" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
</Parallelism>
</RelOp>
<ParameterList>
<ColumnReference Column="@1" ParameterDataType="varchar(8000)" ParameterCompiledValue="'0EDEB732-97D3-462F-B318-03F7CEB20047'" ParameterRuntimeValue="'0EDEB732-97D3-462F-B318-03F7CEB20047'" />
</ParameterList>
</QueryPlan>
</StmtSimple>
</Statements>
</Batch>
</BatchSequence>
</ShowPlanXML>
Reference in New Issue View Git Blame Copy Permalink