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.3.1" Build="12.0.5207.0" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
- <BatchSequence>
- <Batch>
- <Statements>
- <StmtSimple StatementCompId="1" StatementEstRows="287664" StatementId="1" StatementOptmLevel="FULL" CardinalityEstimationModelVersion="70" StatementSubTreeCost="295.952" StatementText="select 
 [Id]
 ,[Occurrence_id]
 ,[AtsReport_id]
from InputResult
where 
 (InputUniqueId = '5D797CE2-F8C6-4790-B9F4-1D04FD9348D5' and contains(ValueAsString,'"asd*"'))

or (InputUniqueId = '9823FC63-8169-45AD-8AFD-C1E8DBCA6A9B' and contains(ValueAsString,'LRBB'))

or (InputUniqueId = 'B4F16CEA-1B06-4F43-BD64-1016F9A69E1D' and ValueAsNumber=6575)

or (InputUniqueId = '25625057-E245-4EE1-8627-7F26D220301E' and contains(ValueAsString,'asd2223'))

or (InputUniqueId = '7BBECDB1-BE4E-45B3-AC7D-DA6482E512D0' and ValueAsGuid='076D5382-6DA5-4F62-89B3-5B7A2581025B')

or (InputUniqueId = 'E58D56A0-B7BD-4BCC-BF7B-8C381C90C176' and ValueAsGuid='456F53A5-A2BD-4ABD-A340-8C523F632483')

or (InputUniqueId = 'E58D56A0-B7BD-4BCC-BF7B-8C381C90C176' and ValueAsGuid='456F53A5-A2BD-4ABD-A340-8C523F632483')

or (InputUniqueId = '19FD3F45-633F-46FF-A2AC-C6ABE82C74DE' and contains(ValueAsListGuids,'76ffbce1-037d-4ae7-9ddc-ea6923b9823b'))

or (InputUniqueId = 'AC2D106B-B0ED-4766-9923-B5729BDA8A62' and ValueAsDateTime=convert(datetime2,'2016-07-04 00:00:00.0000000'))

or (InputUniqueId = '4E97C4A0-8363-4DB3-916C-D88A231A3743' and ValueAsTime=72000000000)

or (InputUniqueId = 'AF360B91-3B5C-408E-AED5-4450E2B3344C' and ValueAsDateTime>=convert(datetime2,'2017-07-04 00:00:00.0000000'))

or (InputUniqueId = '1A09012C-EC76-41D2-BAD8-9E6FE4040DC6' and ValueAsInteger=12)

or (InputUniqueId = 'A51081F6-B266-4032-8026-6E1D82FA3BC8' and ValueAsInteger<=1234)

or (InputUniqueId = 'D9A548F7-A917-4103-A636-AC033D7175C9' and ValueAsTime<=54000000000)

-------------------------------------------------------------------------------------------
or (InputUniqueId = '9823FC63-8169-45AD-8AFD-C1E8DBCA6A9B' and contains(ValueAsString,'"LRBB*"'))

or (InputUniqueId = 'B4F16CEA-1B06-4F43-BD64-1016F9A69E1D' and ValueAsNumber<655)

or (InputUniqueId = '25625057-E245-4EE1-8627-7F26D220301E' and contains(ValueAsString,'asd2223'))

or (InputUniqueId = '7BBECDB1-BE4E-45B3-AC7D-DA6482E512D0' and ValueAsGuid='076D5382-6DA5-4F62-89B3-5B7A2581025B')

or (InputUniqueId = 'E58D56A0-B7BD-4BCC-BF7B-8C381C90C176' and ValueAsGuid='456F53A5-A2BD-4ABD-A340-8C523F632483')

or (InputUniqueId = 'E58D56A0-B7BD-4BCC-BF7B-8C381C90C176' and ValueAsGuid='456F53A5-A2BD-4ABD-A340-8C523F632483')

or (InputUniqueId = '19FD3F45-633F-46FF-A2AC-C6ABE82C74DE' and contains(ValueAsListGuids,'76ffbce1-037d-4ae7-9ddc-ea6923b9823b'))

or (InputUniqueId = 'AC2D106B-B0ED-4766-9923-B5729BDA8A62' and ValueAsDateTime>=convert(datetime2,'2016-07-04 00:00:00.0000000'))

or (InputUniqueId = '4E97C4A0-8363-4DB3-916C-D88A231A3743' and ValueAsTime<=72000000000)

or (InputUniqueId = 'AF360B91-3B5C-408E-AED5-4450E2B3344C' and ValueAsDateTime<=convert(datetime2,'2017-07-04 00:00:00.0000000'))

or (InputUniqueId = '1A09012C-EC76-41D2-BAD8-9E6FE4040DC6' and ValueAsInteger<=12)

or (InputUniqueId = 'A51081F6-B266-4032-8026-6E1D82FA3BC8' and ValueAsInteger>1234)

or (InputUniqueId = 'D9A548F7-A917-4103-A636-AC033D7175C9' and ValueAsTime<=54000000000)

------------------------------------

or (InputUniqueId = '9823FC63-8169-45AD-8AFD-C1E8DBCA6A9B' and contains(ValueAsString,'asd'))

or (InputUniqueId = 'B4F16CEA-1B06-4F43-BD64-1016F9A69E1D' and ValueAsNumber>6575)

or (InputUniqueId = '25625057-E245-4EE1-8627-7F26D220301E' and contains(ValueAsString,'aaa'))

or (InputUniqueId = '7BBECDB1-BE4E-45B3-AC7D-DA6482E512D0' and ValueAsGuid='076D5382-6DA5-4F62-89B3-5B7A2581025B')

or (InputUniqueId = 'E58D56A0-B7BD-4BCC-BF7B-8C381C90C176' and ValueAsGuid='456F53A5-A2BD-4ABD-A340-8C523F632483')

or (InputUniqueId = 'E58D56A0-B7BD-4BCC-BF7B-8C381C90C176' and ValueAsGuid='456F53A5-A2BD-4ABD-A340-8C523F632483')

or (InputUniqueId = '19FD3F45-633F-46FF-A2AC-C6ABE82C74DE' and contains(ValueAsListGuids,'76ffbce1-037d-4ae7-9ddc-ea6923b9823b'))

or (InputUniqueId = 'AC2D106B-B0ED-4766-9923-B5729BDA8A62' and ValueAsDateTime>=convert(datetime2,'2016-07-04 00:00:0" StatementType="SELECT" QueryHash="0xA50F53EA8A1B7FE2" QueryPlanHash="0x61BCEF732F6696FD" 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="8" MemoryGrant="26888" CachedPlanSize="616" CompileTime="38" CompileCPU="38" CompileMemory="5408">
- <ThreadStat Branches="1" UsedThreads="8">
- <ThreadReservation NodeId="0" ReservedThreads="8" />
- </ThreadStat>
- <Warnings>
- <MemoryGrantWarning GrantWarningKind="Excessive Grant" RequestedMemory="26888" GrantedMemory="26888" MaxUsedMemory="136" />
- </Warnings>
- <MemoryGrantInfo SerialRequiredMemory="512" SerialDesiredMemory="23152" RequiredMemory="4232" DesiredMemory="26888" RequestedMemory="26888" GrantWaitTime="0" GrantedMemory="26888" MaxUsedMemory="136" MaxQueryMemory="1884416" />
- <OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="208386" EstimatedPagesCached="104193" EstimatedAvailableDegreeOfParallelism="4" MaxCompileMemory="7678280" />
- <RelOp AvgRowSize="55" EstimateCPU="0.451043" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="287664" LogicalOp="Gather Streams" NodeId="0" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="295.952">
- <OutputList>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="Id" />
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="Occurrence_id" />
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="AtsReport_id" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="782508" ActualEndOfScans="1" ActualExecutions="1" ActualElapsedms="2426" ActualCPUms="53" />
- </RunTimeInformation>
- <Parallelism>
- <RelOp AvgRowSize="55" EstimateCPU="0.33401" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="287664" LogicalOp="Left Semi Join" NodeId="1" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="295.501">
- <OutputList>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="Id" />
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="Occurrence_id" />
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="AtsReport_id" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="7" ActualRows="137711" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="5017" ActualCPUms="2045" />
- <RunTimeCountersPerThread Thread="4" ActualRows="37594" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="4441" ActualCPUms="2612" />
- <RunTimeCountersPerThread Thread="2" ActualRows="260748" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="4178" ActualCPUms="2383" />
- <RunTimeCountersPerThread Thread="3" ActualRows="18234" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="4820" ActualCPUms="1576" />
- <RunTimeCountersPerThread Thread="1" ActualRows="59602" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="4680" ActualCPUms="4544" />
- <RunTimeCountersPerThread Thread="8" ActualRows="5000" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="5228" ActualCPUms="3451" />
- <RunTimeCountersPerThread Thread="6" ActualRows="225008" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="4305" ActualCPUms="2531" />
- <RunTimeCountersPerThread Thread="5" ActualRows="38611" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="4616" ActualCPUms="2094" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" ActualElapsedms="0" ActualCPUms="0" />
- </RunTimeInformation>
- <NestedLoops Optimized="false">
- <OuterReferences>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="Id" />
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsInteger" />
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsNumber" />
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsDateTime" />
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsTime" />
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsGuid" />
- </OuterReferences>
- <RelOp AvgRowSize="116" EstimateCPU="47.1057" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="319627" LogicalOp="Filter" NodeId="2" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="260.236">
- <OutputList>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="Id" />
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="Occurrence_id" />
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="AtsReport_id" />
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsInteger" />
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsNumber" />
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsDateTime" />
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsTime" />
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsGuid" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="7" ActualRows="137776" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="703" ActualCPUms="689" />
- <RunTimeCountersPerThread Thread="8" ActualRows="5000" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="3414" ActualCPUms="3401" />
- <RunTimeCountersPerThread Thread="4" ActualRows="37746" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="344" ActualCPUms="318" />
- <RunTimeCountersPerThread Thread="2" ActualRows="260748" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="1295" ActualCPUms="1264" />
- <RunTimeCountersPerThread Thread="1" ActualRows="83003" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="320" ActualCPUms="306" />
- <RunTimeCountersPerThread Thread="6" ActualRows="225008" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="1845" ActualCPUms="1834" />
- <RunTimeCountersPerThread Thread="3" ActualRows="31085" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="1094" ActualCPUms="1081" />
- <RunTimeCountersPerThread Thread="5" ActualRows="38682" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="448" ActualCPUms="435" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" ActualElapsedms="0" ActualCPUms="0" />
- </RunTimeInformation>
- <Filter StartupExpression="false">
- <RelOp AvgRowSize="116" EstimateCPU="3.20253" EstimateIO="209.928" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="11645400" LogicalOp="Index Scan" NodeId="3" Parallel="true" PhysicalOp="Index Scan" EstimatedTotalSubtreeCost="213.13" TableCardinality="11645400">
- <OutputList>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="Id" />
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="Occurrence_id" />
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="AtsReport_id" />
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsInteger" />
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsNumber" />
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsDateTime" />
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsTime" />
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsGuid" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="7" ActualRows="862647" ActualRowsRead="862647" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="152" ActualCPUms="138" ActualScans="1" ActualLogicalReads="21502" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="8" ActualRows="4266986" ActualRowsRead="4266986" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="642" ActualCPUms="629" ActualScans="1" ActualLogicalReads="106057" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="4" ActualRows="359312" ActualRowsRead="359312" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="93" ActualCPUms="66" ActualScans="1" ActualLogicalReads="9078" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="2" ActualRows="1671395" ActualRowsRead="1671395" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="278" ActualCPUms="247" ActualScans="1" ActualLogicalReads="41608" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="1" ActualRows="368612" ActualRowsRead="368612" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="80" ActualCPUms="67" ActualScans="1" ActualLogicalReads="9277" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="6" ActualRows="2300876" ActualRowsRead="2300876" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="362" ActualCPUms="351" ActualScans="1" ActualLogicalReads="57349" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="3" ActualRows="1312705" ActualRowsRead="1312705" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="214" ActualCPUms="202" ActualScans="1" ActualLogicalReads="32705" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="5" ActualRows="502875" ActualRowsRead="502875" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="94" ActualCPUms="81" ActualScans="1" ActualLogicalReads="12527" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="181" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- </RunTimeInformation>
- <IndexScan Ordered="false" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="Id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="Occurrence_id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="AtsReport_id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsInteger" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsNumber" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsDateTime" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsTime" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsGuid" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Index="[index_by_values]" IndexKind="NonClustered" Storage="RowStore" />
- </IndexScan>
- </RelOp>
- <Predicate>
- <ScalarOperator ScalarString="[TestDB].[dbo].[InputResult].[InputUniqueId]={guid'5D797CE2-F8C6-4790-B9F4-1D04FD9348D5'} OR [TestDB].[dbo].[InputResult].[InputUniqueId]={guid'9823FC63-8169-45AD-8AFD-C1E8DBCA6A9B'} OR [TestDB].[dbo].[InputResult].[InputUniqueId]={guid'B4F16CEA-1B06-4F43-BD64-1016F9A69E1D'} AND [TestDB].[dbo].[InputResult].[ValueAsNumber]=(6.575000000000000e+003) OR [TestDB].[dbo].[InputResult].[InputUniqueId]={guid'25625057-E245-4EE1-8627-7F26D220301E'} OR [TestDB].[dbo].[InputResult].[InputUniqueId]={guid'7BBECDB1-BE4E-45B3-AC7D-DA6482E512D0'} AND [TestDB].[dbo].[InputResult].[ValueAsGuid]={guid'076D5382-6DA5-4F62-89B3-5B7A2581025B'} OR [TestDB].[dbo].[InputResult].[InputUniqueId]={guid'E58D56A0-B7BD-4BCC-BF7B-8C381C90C176'} AND [TestDB].[dbo].[InputResult].[ValueAsGuid]={guid'456F53A5-A2BD-4ABD-A340-8C523F632483'} OR [TestDB].[dbo].[InputResult].[InputUniqueId]={guid'19FD3F45-633F-46FF-A2AC-C6ABE82C74DE'} OR [TestDB].[dbo].[InputResult].[InputUniqueId]={guid'AC2D106B-B0ED-4766-9923-B5729BDA8A62'} AND [TestDB].[dbo].[InputResult].[ValueAsDateTime]='2016-07-04 00:00:00.0000000' OR [TestDB].[dbo].[InputResult].[InputUniqueId]={guid'4E97C4A0-8363-4DB3-916C-D88A231A3743'} AND [TestDB].[dbo].[InputResult].[ValueAsTime]=(72000000000.) OR [TestDB].[dbo].[InputResult].[InputUniqueId]={guid'AF360B91-3B5C-408E-AED5-4450E2B3344C'} AND [TestDB].[dbo].[InputResult].[ValueAsDateTime]>='2017-07-04 00:00:00.0000000' OR [TestDB].[dbo].[InputResult].[InputUniqueId]={guid'1A09012C-EC76-41D2-BAD8-9E6FE4040DC6'} AND [TestDB].[dbo].[InputResult].[ValueAsInteger]=(12) OR [TestDB].[dbo].[InputResult].[InputUniqueId]={guid'A51081F6-B266-4032-8026-6E1D82FA3BC8'} AND [TestDB].[dbo].[InputResult].[ValueAsInteger]<=(1234) OR [TestDB].[dbo].[InputResult].[InputUniqueId]={guid'D9A548F7-A917-4103-A636-AC033D7175C9'} AND [TestDB].[dbo].[InputResult].[ValueAsTime]<=(54000000000.) OR [TestDB].[dbo].[InputResult].[InputUniqueId]={guid'B4F16CEA-1B06-4F43-BD64-1016F9A69E1D'} AND [TestDB].[dbo].[InputResult].[ValueAsNumber]<(6.550000000000000e+002) OR [TestDB].[dbo].[InputResult].[InputUniqueId]={guid'AC2D106B-B0ED-4766-9923-B5729BDA8A62'} AND [TestDB].[dbo].[InputResult].[ValueAsDateTime]>='2016-07-04 00:00:00.0000000' OR [TestDB].[dbo].[InputResult].[InputUniqueId]={guid'4E97C4A0-8363-4DB3-916C-D88A231A3743'} AND [TestDB].[dbo].[InputResult].[ValueAsTime]<=(72000000000.) OR [TestDB].[dbo].[InputResult].[InputUniqueId]={guid'AF360B91-3B5C-408E-AED5-4450E2B3344C'} AND [TestDB].[dbo].[InputResult].[ValueAsDateTime]<='2017-07-04 00:00:00.0000000' OR [TestDB].[dbo].[InputResult].[InputUniqueId]={guid'1A09012C-EC76-41D2-BAD8-9E6FE4040DC6'} AND [TestDB].[dbo].[InputResult].[ValueAsInteger]<=(12) OR [TestDB].[dbo].[InputResult].[InputUniqueId]={guid'A51081F6-B266-4032-8026-6E1D82FA3BC8'} AND [TestDB].[dbo].[InputResult].[ValueAsInteger]>(1234) OR [TestDB].[dbo].[InputResult].[InputUniqueId]={guid'B4F16CEA-1B06-4F43-BD64-1016F9A69E1D'} AND [TestDB].[dbo].[InputResult].[ValueAsNumber]>(6.575000000000000e+003) OR [TestDB].[dbo].[InputResult].[InputUniqueId]={guid'4E97C4A0-8363-4DB3-916C-D88A231A3743'} AND [TestDB].[dbo].[InputResult].[ValueAsTime]>=(72000000000.) OR [TestDB].[dbo].[InputResult].[InputUniqueId]={guid'AF360B91-3B5C-408E-AED5-4450E2B3344C'} AND [TestDB].[dbo].[InputResult].[ValueAsDateTime]='2017-07-04 00:00:00.0000000' OR [TestDB].[dbo].[InputResult].[InputUniqueId]={guid'1A09012C-EC76-41D2-BAD8-9E6FE4040DC6'} AND [TestDB].[dbo].[InputResult].[ValueAsInteger]>=(12) OR [TestDB].[dbo].[InputResult].[InputUniqueId]={guid'A51081F6-B266-4032-8026-6E1D82FA3BC8'} AND [TestDB].[dbo].[InputResult].[ValueAsInteger]<(1234) OR [TestDB].[dbo].[InputResult].[InputUniqueId]={guid'D9A548F7-A917-4103-A636-AC033D7175C9'} AND [TestDB].[dbo].[InputResult].[ValueAsTime]=(54000000000.)">
- <Logical Operation="OR">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'5D797CE2-F8C6-4790-B9F4-1D04FD9348D5'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'9823FC63-8169-45AD-8AFD-C1E8DBCA6A9B'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'B4F16CEA-1B06-4F43-BD64-1016F9A69E1D'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsNumber" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(6.575000000000000e+003)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'25625057-E245-4EE1-8627-7F26D220301E'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'7BBECDB1-BE4E-45B3-AC7D-DA6482E512D0'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsGuid" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'076D5382-6DA5-4F62-89B3-5B7A2581025B'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- <ScalarOperator>
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'E58D56A0-B7BD-4BCC-BF7B-8C381C90C176'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsGuid" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'456F53A5-A2BD-4ABD-A340-8C523F632483'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'19FD3F45-633F-46FF-A2AC-C6ABE82C74DE'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'AC2D106B-B0ED-4766-9923-B5729BDA8A62'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsDateTime" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="'2016-07-04 00:00:00.0000000'" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- <ScalarOperator>
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'4E97C4A0-8363-4DB3-916C-D88A231A3743'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsTime" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(72000000000.)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- <ScalarOperator>
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'AF360B91-3B5C-408E-AED5-4450E2B3344C'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="GE">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsDateTime" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="'2017-07-04 00:00:00.0000000'" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- <ScalarOperator>
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'1A09012C-EC76-41D2-BAD8-9E6FE4040DC6'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsInteger" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(12)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- <ScalarOperator>
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'A51081F6-B266-4032-8026-6E1D82FA3BC8'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="LE">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsInteger" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(1234)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- <ScalarOperator>
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'D9A548F7-A917-4103-A636-AC033D7175C9'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="LE">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsTime" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(54000000000.)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- <ScalarOperator>
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'B4F16CEA-1B06-4F43-BD64-1016F9A69E1D'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="LT">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsNumber" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(6.550000000000000e+002)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- <ScalarOperator>
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'AC2D106B-B0ED-4766-9923-B5729BDA8A62'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="GE">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsDateTime" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="'2016-07-04 00:00:00.0000000'" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- <ScalarOperator>
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'4E97C4A0-8363-4DB3-916C-D88A231A3743'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="LE">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsTime" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(72000000000.)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- <ScalarOperator>
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'AF360B91-3B5C-408E-AED5-4450E2B3344C'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="LE">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsDateTime" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="'2017-07-04 00:00:00.0000000'" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- <ScalarOperator>
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'1A09012C-EC76-41D2-BAD8-9E6FE4040DC6'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="LE">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsInteger" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(12)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- <ScalarOperator>
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'A51081F6-B266-4032-8026-6E1D82FA3BC8'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="GT">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsInteger" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(1234)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- <ScalarOperator>
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'B4F16CEA-1B06-4F43-BD64-1016F9A69E1D'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="GT">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsNumber" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(6.575000000000000e+003)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- <ScalarOperator>
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'4E97C4A0-8363-4DB3-916C-D88A231A3743'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="GE">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsTime" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(72000000000.)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- <ScalarOperator>
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'AF360B91-3B5C-408E-AED5-4450E2B3344C'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsDateTime" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="'2017-07-04 00:00:00.0000000'" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- <ScalarOperator>
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'1A09012C-EC76-41D2-BAD8-9E6FE4040DC6'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="GE">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsInteger" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(12)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- <ScalarOperator>
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'A51081F6-B266-4032-8026-6E1D82FA3BC8'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="LT">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsInteger" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(1234)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- <ScalarOperator>
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'D9A548F7-A917-4103-A636-AC033D7175C9'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsTime" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(54000000000.)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Predicate>
- </Filter>
- </RelOp>
- <RelOp AvgRowSize="9" EstimateCPU="1.1E-06" EstimateIO="0" EstimateRebinds="319626" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.1" LogicalOp="Concatenation" NodeId="5" Parallel="true" PhysicalOp="Concatenation" EstimatedTotalSubtreeCost="34.9312">
- <OutputList />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="7" ActualRows="137711" Batches="0" ActualEndOfScans="65" ActualExecutions="137776" ActualExecutionMode="Row" ActualElapsedms="3942" ActualCPUms="984" />
- <RunTimeCountersPerThread Thread="4" ActualRows="37594" Batches="0" ActualEndOfScans="152" ActualExecutions="37746" ActualExecutionMode="Row" ActualElapsedms="3979" ActualCPUms="2176" />
- <RunTimeCountersPerThread Thread="2" ActualRows="260748" Batches="0" ActualEndOfScans="0" ActualExecutions="260748" ActualExecutionMode="Row" ActualElapsedms="2151" ActualCPUms="387" />
- <RunTimeCountersPerThread Thread="3" ActualRows="18234" Batches="0" ActualEndOfScans="12851" ActualExecutions="31085" ActualExecutionMode="Row" ActualElapsedms="3622" ActualCPUms="390" />
- <RunTimeCountersPerThread Thread="1" ActualRows="59602" Batches="0" ActualEndOfScans="23401" ActualExecutions="83003" ActualExecutionMode="Row" ActualElapsedms="4110" ActualCPUms="3988" />
- <RunTimeCountersPerThread Thread="8" ActualRows="5000" Batches="0" ActualEndOfScans="0" ActualExecutions="5000" ActualExecutionMode="Row" ActualElapsedms="1796" ActualCPUms="32" />
- <RunTimeCountersPerThread Thread="6" ActualRows="225008" Batches="0" ActualEndOfScans="0" ActualExecutions="225008" ActualExecutionMode="Row" ActualElapsedms="1837" ActualCPUms="74" />
- <RunTimeCountersPerThread Thread="5" ActualRows="38611" Batches="0" ActualEndOfScans="71" ActualExecutions="38682" ActualExecutionMode="Row" ActualElapsedms="4037" ActualCPUms="1529" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" ActualElapsedms="0" ActualCPUms="0" />
- </RunTimeInformation>
- <Concat>
- <DefinedValues />
- <RelOp AvgRowSize="9" EstimateCPU="1.498E-05" EstimateIO="0" EstimateRebinds="319626" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Filter" NodeId="6" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="5.10764">
- <OutputList />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="7" ActualRebinds="34706" ActualRewinds="103070" ActualRows="103072" Batches="0" ActualEndOfScans="34704" ActualExecutions="137776" ActualExecutionMode="Row" ActualElapsedms="44" ActualCPUms="44" />
- <RunTimeCountersPerThread Thread="8" ActualRebinds="5000" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="5000" ActualExecutions="5000" ActualExecutionMode="Row" ActualElapsedms="3" ActualCPUms="3" />
- <RunTimeCountersPerThread Thread="4" ActualRebinds="37746" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="37746" ActualExecutions="37746" ActualExecutionMode="Row" ActualElapsedms="29" ActualCPUms="29" />
- <RunTimeCountersPerThread Thread="2" ActualRebinds="46890" ActualRewinds="213858" ActualRows="213888" Batches="0" ActualEndOfScans="46860" ActualExecutions="260748" ActualExecutionMode="Row" ActualElapsedms="75" ActualCPUms="75" />
- <RunTimeCountersPerThread Thread="1" ActualRebinds="48072" ActualRewinds="34931" ActualRows="34932" Batches="0" ActualEndOfScans="48071" ActualExecutions="83003" ActualExecutionMode="Row" ActualElapsedms="43" ActualCPUms="43" />
- <RunTimeCountersPerThread Thread="6" ActualRebinds="2624" ActualRewinds="222384" ActualRows="222396" Batches="0" ActualEndOfScans="2612" ActualExecutions="225008" ActualExecutionMode="Row" ActualElapsedms="36" ActualCPUms="36" />
- <RunTimeCountersPerThread Thread="3" ActualRebinds="29113" ActualRewinds="1972" ActualRows="1980" Batches="0" ActualEndOfScans="29105" ActualExecutions="31085" ActualExecutionMode="Row" ActualElapsedms="22" ActualCPUms="22" />
- <RunTimeCountersPerThread Thread="5" ActualRebinds="38682" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="38682" ActualExecutions="38682" ActualExecutionMode="Row" ActualElapsedms="31" ActualCPUms="31" />
- <RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" ActualElapsedms="0" ActualCPUms="0" />
- </RunTimeInformation>
- <Filter StartupExpression="true">
- <RelOp AvgRowSize="9" EstimateCPU="1.157E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="319626" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Constant Scan" NodeId="7" Parallel="true" PhysicalOp="Constant Scan" EstimatedTotalSubtreeCost="0.319627">
- <OutputList />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="7" ActualRows="103072" Batches="0" ActualEndOfScans="0" ActualExecutions="137776" ActualExecutionMode="Row" ActualElapsedms="6" ActualCPUms="6" />
- <RunTimeCountersPerThread Thread="8" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="5000" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="4" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="37746" ActualExecutionMode="Row" ActualElapsedms="1" ActualCPUms="1" />
- <RunTimeCountersPerThread Thread="2" ActualRows="213888" Batches="0" ActualEndOfScans="0" ActualExecutions="260748" ActualExecutionMode="Row" ActualElapsedms="11" ActualCPUms="11" />
- <RunTimeCountersPerThread Thread="1" ActualRows="34932" Batches="0" ActualEndOfScans="0" ActualExecutions="83003" ActualExecutionMode="Row" ActualElapsedms="4" ActualCPUms="4" />
- <RunTimeCountersPerThread Thread="6" ActualRows="222396" Batches="0" ActualEndOfScans="0" ActualExecutions="225008" ActualExecutionMode="Row" ActualElapsedms="9" ActualCPUms="9" />
- <RunTimeCountersPerThread Thread="3" ActualRows="1980" Batches="0" ActualEndOfScans="0" ActualExecutions="31085" ActualExecutionMode="Row" ActualElapsedms="1" ActualCPUms="1" />
- <RunTimeCountersPerThread Thread="5" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="38682" ActualExecutionMode="Row" ActualElapsedms="2" ActualCPUms="2" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" ActualElapsedms="0" ActualCPUms="0" />
- </RunTimeInformation>
- <ConstantScan />
- </RelOp>
- <Predicate>
- <ScalarOperator ScalarString="[TestDB].[dbo].[InputResult].[InputUniqueId]={guid'B4F16CEA-1B06-4F43-BD64-1016F9A69E1D'} AND [TestDB].[dbo].[InputResult].[ValueAsNumber]=(6.575000000000000e+003) OR [TestDB].[dbo].[InputResult].[InputUniqueId]={guid'7BBECDB1-BE4E-45B3-AC7D-DA6482E512D0'} AND [TestDB].[dbo].[InputResult].[ValueAsGuid]={guid'076D5382-6DA5-4F62-89B3-5B7A2581025B'} OR [TestDB].[dbo].[InputResult].[InputUniqueId]={guid'E58D56A0-B7BD-4BCC-BF7B-8C381C90C176'} AND [TestDB].[dbo].[InputResult].[ValueAsGuid]={guid'456F53A5-A2BD-4ABD-A340-8C523F632483'} OR [TestDB].[dbo].[InputResult].[InputUniqueId]={guid'AC2D106B-B0ED-4766-9923-B5729BDA8A62'} AND [TestDB].[dbo].[InputResult].[ValueAsDateTime]='2016-07-04 00:00:00.0000000' OR [TestDB].[dbo].[InputResult].[InputUniqueId]={guid'4E97C4A0-8363-4DB3-916C-D88A231A3743'} AND [TestDB].[dbo].[InputResult].[ValueAsTime]=(72000000000.) OR [TestDB].[dbo].[InputResult].[InputUniqueId]={guid'AF360B91-3B5C-408E-AED5-4450E2B3344C'} AND [TestDB].[dbo].[InputResult].[ValueAsDateTime]>='2017-07-04 00:00:00.0000000' OR [TestDB].[dbo].[InputResult].[InputUniqueId]={guid'1A09012C-EC76-41D2-BAD8-9E6FE4040DC6'} AND [TestDB].[dbo].[InputResult].[ValueAsInteger]=(12) OR [TestDB].[dbo].[InputResult].[InputUniqueId]={guid'A51081F6-B266-4032-8026-6E1D82FA3BC8'} AND [TestDB].[dbo].[InputResult].[ValueAsInteger]<=(1234) OR [TestDB].[dbo].[InputResult].[InputUniqueId]={guid'D9A548F7-A917-4103-A636-AC033D7175C9'} AND [TestDB].[dbo].[InputResult].[ValueAsTime]<=(54000000000.) OR [TestDB].[dbo].[InputResult].[InputUniqueId]={guid'B4F16CEA-1B06-4F43-BD64-1016F9A69E1D'} AND [TestDB].[dbo].[InputResult].[ValueAsNumber]<(6.550000000000000e+002) OR [TestDB].[dbo].[InputResult].[InputUniqueId]={guid'AC2D106B-B0ED-4766-9923-B5729BDA8A62'} AND [TestDB].[dbo].[InputResult].[ValueAsDateTime]>='2016-07-04 00:00:00.0000000' OR [TestDB].[dbo].[InputResult].[InputUniqueId]={guid'4E97C4A0-8363-4DB3-916C-D88A231A3743'} AND [TestDB].[dbo].[InputResult].[ValueAsTime]<=(72000000000.) OR [TestDB].[dbo].[InputResult].[InputUniqueId]={guid'AF360B91-3B5C-408E-AED5-4450E2B3344C'} AND [TestDB].[dbo].[InputResult].[ValueAsDateTime]<='2017-07-04 00:00:00.0000000' OR [TestDB].[dbo].[InputResult].[InputUniqueId]={guid'1A09012C-EC76-41D2-BAD8-9E6FE4040DC6'} AND [TestDB].[dbo].[InputResult].[ValueAsInteger]<=(12) OR [TestDB].[dbo].[InputResult].[InputUniqueId]={guid'A51081F6-B266-4032-8026-6E1D82FA3BC8'} AND [TestDB].[dbo].[InputResult].[ValueAsInteger]>(1234) OR [TestDB].[dbo].[InputResult].[InputUniqueId]={guid'B4F16CEA-1B06-4F43-BD64-1016F9A69E1D'} AND [TestDB].[dbo].[InputResult].[ValueAsNumber]>(6.575000000000000e+003) OR [TestDB].[dbo].[InputResult].[InputUniqueId]={guid'4E97C4A0-8363-4DB3-916C-D88A231A3743'} AND [TestDB].[dbo].[InputResult].[ValueAsTime]>=(72000000000.) OR [TestDB].[dbo].[InputResult].[InputUniqueId]={guid'AF360B91-3B5C-408E-AED5-4450E2B3344C'} AND [TestDB].[dbo].[InputResult].[ValueAsDateTime]='2017-07-04 00:00:00.0000000' OR [TestDB].[dbo].[InputResult].[InputUniqueId]={guid'1A09012C-EC76-41D2-BAD8-9E6FE4040DC6'} AND [TestDB].[dbo].[InputResult].[ValueAsInteger]>=(12) OR [TestDB].[dbo].[InputResult].[InputUniqueId]={guid'A51081F6-B266-4032-8026-6E1D82FA3BC8'} AND [TestDB].[dbo].[InputResult].[ValueAsInteger]<(1234) OR [TestDB].[dbo].[InputResult].[InputUniqueId]={guid'D9A548F7-A917-4103-A636-AC033D7175C9'} AND [TestDB].[dbo].[InputResult].[ValueAsTime]=(54000000000.)">
- <Logical Operation="OR">
- <ScalarOperator>
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'B4F16CEA-1B06-4F43-BD64-1016F9A69E1D'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsNumber" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(6.575000000000000e+003)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- <ScalarOperator>
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'7BBECDB1-BE4E-45B3-AC7D-DA6482E512D0'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsGuid" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'076D5382-6DA5-4F62-89B3-5B7A2581025B'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- <ScalarOperator>
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'E58D56A0-B7BD-4BCC-BF7B-8C381C90C176'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsGuid" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'456F53A5-A2BD-4ABD-A340-8C523F632483'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- <ScalarOperator>
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'AC2D106B-B0ED-4766-9923-B5729BDA8A62'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsDateTime" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="'2016-07-04 00:00:00.0000000'" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- <ScalarOperator>
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'4E97C4A0-8363-4DB3-916C-D88A231A3743'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsTime" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(72000000000.)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- <ScalarOperator>
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'AF360B91-3B5C-408E-AED5-4450E2B3344C'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="GE">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsDateTime" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="'2017-07-04 00:00:00.0000000'" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- <ScalarOperator>
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'1A09012C-EC76-41D2-BAD8-9E6FE4040DC6'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsInteger" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(12)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- <ScalarOperator>
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'A51081F6-B266-4032-8026-6E1D82FA3BC8'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="LE">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsInteger" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(1234)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- <ScalarOperator>
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'D9A548F7-A917-4103-A636-AC033D7175C9'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="LE">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsTime" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(54000000000.)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- <ScalarOperator>
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'B4F16CEA-1B06-4F43-BD64-1016F9A69E1D'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="LT">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsNumber" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(6.550000000000000e+002)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- <ScalarOperator>
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'AC2D106B-B0ED-4766-9923-B5729BDA8A62'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="GE">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsDateTime" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="'2016-07-04 00:00:00.0000000'" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- <ScalarOperator>
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'4E97C4A0-8363-4DB3-916C-D88A231A3743'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="LE">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsTime" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(72000000000.)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- <ScalarOperator>
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'AF360B91-3B5C-408E-AED5-4450E2B3344C'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="LE">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsDateTime" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="'2017-07-04 00:00:00.0000000'" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- <ScalarOperator>
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'1A09012C-EC76-41D2-BAD8-9E6FE4040DC6'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="LE">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsInteger" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(12)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- <ScalarOperator>
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'A51081F6-B266-4032-8026-6E1D82FA3BC8'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="GT">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsInteger" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(1234)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- <ScalarOperator>
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'B4F16CEA-1B06-4F43-BD64-1016F9A69E1D'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="GT">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsNumber" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(6.575000000000000e+003)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- <ScalarOperator>
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'4E97C4A0-8363-4DB3-916C-D88A231A3743'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="GE">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsTime" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(72000000000.)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- <ScalarOperator>
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'AF360B91-3B5C-408E-AED5-4450E2B3344C'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsDateTime" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="'2017-07-04 00:00:00.0000000'" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- <ScalarOperator>
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'1A09012C-EC76-41D2-BAD8-9E6FE4040DC6'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="GE">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsInteger" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(12)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- <ScalarOperator>
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'A51081F6-B266-4032-8026-6E1D82FA3BC8'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="LT">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsInteger" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(1234)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- <ScalarOperator>
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'D9A548F7-A917-4103-A636-AC033D7175C9'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="ValueAsTime" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(54000000000.)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Predicate>
- </Filter>
- </RelOp>
- <RelOp AvgRowSize="9" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="319626" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="9" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="295.501">
- <OutputList />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="7" ActualRows="3131" Batches="0" ActualEndOfScans="31573" ActualExecutions="34704" ActualExecutionMode="Row" ActualElapsedms="1803" ActualCPUms="41" />
- <RunTimeCountersPerThread Thread="8" ActualRows="5000" Batches="0" ActualEndOfScans="0" ActualExecutions="5000" ActualExecutionMode="Row" ActualElapsedms="1791" ActualCPUms="27" />
- <RunTimeCountersPerThread Thread="2" ActualRows="46860" Batches="0" ActualEndOfScans="0" ActualExecutions="46860" ActualExecutionMode="Row" ActualElapsedms="2038" ActualCPUms="274" />
- <RunTimeCountersPerThread Thread="4" ActualRows="2626" Batches="0" ActualEndOfScans="35120" ActualExecutions="37746" ActualExecutionMode="Row" ActualElapsedms="1807" ActualCPUms="44" />
- <RunTimeCountersPerThread Thread="1" ActualRows="1884" Batches="0" ActualEndOfScans="46187" ActualExecutions="48071" ActualExecutionMode="Row" ActualElapsedms="1809" ActualCPUms="1808" />
- <RunTimeCountersPerThread Thread="3" ActualRows="3908" Batches="0" ActualEndOfScans="25197" ActualExecutions="29105" ActualExecutionMode="Row" ActualElapsedms="1802" ActualCPUms="38" />
- <RunTimeCountersPerThread Thread="6" ActualRows="2612" Batches="0" ActualEndOfScans="0" ActualExecutions="2612" ActualExecutionMode="Row" ActualElapsedms="1774" ActualCPUms="11" />
- <RunTimeCountersPerThread Thread="5" ActualRows="1951" Batches="0" ActualEndOfScans="36731" ActualExecutions="38682" ActualExecutionMode="Row" ActualElapsedms="1798" ActualCPUms="37" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" ActualElapsedms="0" ActualCPUms="0" />
- </RunTimeInformation>
- <NestedLoops Optimized="false">
- <OuterReferences>
- <ColumnReference Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="docid" />
- </OuterReferences>
- <RelOp AvgRowSize="15" EstimateCPU="4.8E-07" EstimateIO="0" EstimateRebinds="319626" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Filter" NodeId="10" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="210.896">
- <OutputList>
- <ColumnReference Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="docid" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="7" ActualRebinds="34704" ActualRewinds="0" ActualRows="3131" Batches="0" ActualEndOfScans="31573" ActualExecutions="34704" ActualExecutionMode="Row" ActualElapsedms="29" ActualCPUms="29" />
- <RunTimeCountersPerThread Thread="8" ActualRebinds="5000" ActualRewinds="0" ActualRows="5000" Batches="0" ActualEndOfScans="0" ActualExecutions="5000" ActualExecutionMode="Row" ActualElapsedms="16" ActualCPUms="16" />
- <RunTimeCountersPerThread Thread="4" ActualRebinds="37746" ActualRewinds="0" ActualRows="2626" Batches="0" ActualEndOfScans="35120" ActualExecutions="37746" ActualExecutionMode="Row" ActualElapsedms="29" ActualCPUms="29" />
- <RunTimeCountersPerThread Thread="2" ActualRebinds="46860" ActualRewinds="0" ActualRows="46860" Batches="0" ActualEndOfScans="0" ActualExecutions="46860" ActualExecutionMode="Row" ActualElapsedms="160" ActualCPUms="159" />
- <RunTimeCountersPerThread Thread="1" ActualRebinds="48071" ActualRewinds="0" ActualRows="1884" Batches="0" ActualEndOfScans="46187" ActualExecutions="48071" ActualExecutionMode="Row" ActualElapsedms="32" ActualCPUms="32" />
- <RunTimeCountersPerThread Thread="3" ActualRebinds="29105" ActualRewinds="0" ActualRows="3908" Batches="0" ActualEndOfScans="25197" ActualExecutions="29105" ActualExecutionMode="Row" ActualElapsedms="26" ActualCPUms="26" />
- <RunTimeCountersPerThread Thread="6" ActualRebinds="2612" ActualRewinds="0" ActualRows="2612" Batches="0" ActualEndOfScans="0" ActualExecutions="2612" ActualExecutionMode="Row" ActualElapsedms="7" ActualCPUms="7" />
- <RunTimeCountersPerThread Thread="5" ActualRebinds="38682" ActualRewinds="0" ActualRows="1951" Batches="0" ActualEndOfScans="36731" ActualExecutions="38682" ActualExecutionMode="Row" ActualElapsedms="26" ActualCPUms="26" />
- <RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" ActualElapsedms="0" ActualCPUms="0" />
- </RunTimeInformation>
- <Filter StartupExpression="true">
- <RelOp AvgRowSize="15" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="319626" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Index Seek" NodeId="11" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="210.743" TableCardinality="11645400">
- <OutputList>
- <ColumnReference Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="docid" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="7" ActualRows="3131" ActualRowsRead="3131" Batches="0" ActualEndOfScans="0" ActualExecutions="34704" ActualExecutionMode="Row" ActualElapsedms="23" ActualCPUms="23" ActualScans="3131" ActualLogicalReads="12524" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="8" ActualRows="5000" ActualRowsRead="5000" Batches="0" ActualEndOfScans="0" ActualExecutions="5000" ActualExecutionMode="Row" ActualElapsedms="15" ActualCPUms="15" ActualScans="5000" ActualLogicalReads="20000" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="4" ActualRows="2626" ActualRowsRead="2626" Batches="0" ActualEndOfScans="0" ActualExecutions="37746" ActualExecutionMode="Row" ActualElapsedms="23" ActualCPUms="23" ActualScans="2626" ActualLogicalReads="10504" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="2" ActualRows="46860" ActualRowsRead="46860" Batches="0" ActualEndOfScans="0" ActualExecutions="46860" ActualExecutionMode="Row" ActualElapsedms="153" ActualCPUms="153" ActualScans="46860" ActualLogicalReads="187440" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="1" ActualRows="1884" ActualRowsRead="1884" Batches="0" ActualEndOfScans="0" ActualExecutions="48071" ActualExecutionMode="Row" ActualElapsedms="24" ActualCPUms="24" ActualScans="1884" ActualLogicalReads="7536" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="3" ActualRows="3908" ActualRowsRead="3908" Batches="0" ActualEndOfScans="0" ActualExecutions="29105" ActualExecutionMode="Row" ActualElapsedms="21" ActualCPUms="21" ActualScans="3908" ActualLogicalReads="15632" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="6" ActualRows="2612" ActualRowsRead="2612" Batches="0" ActualEndOfScans="0" ActualExecutions="2612" ActualExecutionMode="Row" ActualElapsedms="6" ActualCPUms="6" ActualScans="2612" ActualLogicalReads="10448" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="5" ActualRows="1951" ActualRowsRead="1951" Batches="0" ActualEndOfScans="0" ActualExecutions="38682" ActualExecutionMode="Row" ActualElapsedms="20" ActualCPUms="20" ActualScans="1951" ActualLogicalReads="7804" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" 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="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="docid" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Index="[i2]" TableReferenceId="1" IndexKind="NonClustered" Storage="RowStore" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="ftkey" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[TestDB].[dbo].[InputResult].[Id]">
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="Id" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- <Predicate>
- <ScalarOperator ScalarString="[TestDB].[dbo].[InputResult].[InputUniqueId]={guid'5D797CE2-F8C6-4790-B9F4-1D04FD9348D5'}">
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'5D797CE2-F8C6-4790-B9F4-1D04FD9348D5'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Predicate>
- </Filter>
- </RelOp>
- <RelOp AvgRowSize="9" EstimateCPU="0.660731" EstimateIO="12.7631" EstimateRebinds="319626" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Eager Spool" NodeId="13" Parallel="true" PhysicalOp="Index Spool" EstimatedTotalSubtreeCost="102.409">
- <OutputList />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="7" ActualRebinds="3131" ActualRewinds="0" ActualRows="3131" Batches="0" ActualEndOfScans="0" ActualExecutions="3131" ActualExecutionMode="Row" ActualElapsedms="1767" ActualCPUms="5" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="8" ActualRebinds="5000" ActualRewinds="0" ActualRows="5000" Batches="0" ActualEndOfScans="0" ActualExecutions="5000" ActualExecutionMode="Row" ActualElapsedms="1772" ActualCPUms="8" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="4" ActualRebinds="2626" ActualRewinds="0" ActualRows="2626" Batches="0" ActualEndOfScans="0" ActualExecutions="2626" ActualExecutionMode="Row" ActualElapsedms="1770" ActualCPUms="6" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="2" ActualRebinds="46860" ActualRewinds="0" ActualRows="46860" Batches="0" ActualEndOfScans="0" ActualExecutions="46860" ActualExecutionMode="Row" ActualElapsedms="1855" ActualCPUms="91" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="1" ActualRebinds="1884" ActualRewinds="0" ActualRows="1884" Batches="0" ActualEndOfScans="0" ActualExecutions="1884" ActualExecutionMode="Row" ActualElapsedms="1767" ActualCPUms="1766" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="3" ActualRebinds="3908" ActualRewinds="0" ActualRows="3908" Batches="0" ActualEndOfScans="0" ActualExecutions="3908" ActualExecutionMode="Row" ActualElapsedms="1769" ActualCPUms="6" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="6" ActualRebinds="2612" ActualRewinds="0" ActualRows="2612" Batches="0" ActualEndOfScans="0" ActualExecutions="2612" ActualExecutionMode="Row" ActualElapsedms="1766" ActualCPUms="3" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="5" ActualRebinds="1951" ActualRewinds="0" ActualRows="1951" Batches="0" ActualEndOfScans="0" ActualExecutions="1951" ActualExecutionMode="Row" ActualElapsedms="1764" ActualCPUms="2" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- </RunTimeInformation>
- <Spool>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Table="[FulltextMatch]" Column="docid" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[TestDB].[sys].[fulltext_index_docidmap_1672393027].[docid]">
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="docid" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- <RelOp AvgRowSize="15" EstimateCPU="0.263525" EstimateIO="0.329285" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="660473" LogicalOp="Table-valued function" NodeId="14" Parallel="true" PhysicalOp="Table-valued function" EstimatedTotalSubtreeCost="0.592809">
- <OutputList>
- <ColumnReference Table="[FulltextMatch]" Column="docid" />
- </OutputList>
- <MemoryFractions Input="1" Output="1" />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="7" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="8" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="4" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="2" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="1" ActualRebinds="1" ActualRewinds="0" ActualRows="910560" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="765" ActualCPUms="765" />
- <RunTimeCountersPerThread Thread="3" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="6" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="5" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" ActualElapsedms="0" ActualCPUms="0" />
- </RunTimeInformation>
- <TableValuedFunction>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Table="[FulltextMatch]" Column="docid" />
- </DefinedValue>
- </DefinedValues>
- <Object Table="[FulltextMatch]" />
- <ParameterList>
- <ScalarOperator ScalarString="(0)">
- <Const ConstValue="(0)" />
- </ScalarOperator>
- <ScalarOperator ScalarString="(2)">
- <Const ConstValue="(2)" />
- </ScalarOperator>
- <ScalarOperator ScalarString="(0)">
- <Const ConstValue="(0)" />
- </ScalarOperator>
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </ParameterList>
- </TableValuedFunction>
- </RelOp>
- </Spool>
- </RelOp>
- </NestedLoops>
- </RelOp>
- <RelOp AvgRowSize="9" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="319626" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="20" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="295.501">
- <OutputList />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="7" ActualRows="0" Batches="0" ActualEndOfScans="31573" ActualExecutions="31573" ActualExecutionMode="Row" ActualElapsedms="20" ActualCPUms="20" />
- <RunTimeCountersPerThread Thread="8" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="1" ActualRows="0" Batches="0" ActualEndOfScans="46187" ActualExecutions="46187" ActualExecutionMode="Row" ActualElapsedms="29" ActualCPUms="29" />
- <RunTimeCountersPerThread Thread="2" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="4" ActualRows="34968" Batches="0" ActualEndOfScans="152" ActualExecutions="35120" ActualExecutionMode="Row" ActualElapsedms="798" ActualCPUms="788" />
- <RunTimeCountersPerThread Thread="3" ActualRows="0" Batches="0" ActualEndOfScans="25197" ActualExecutions="25197" ActualExecutionMode="Row" ActualElapsedms="15" ActualCPUms="15" />
- <RunTimeCountersPerThread Thread="6" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="5" ActualRows="0" Batches="0" ActualEndOfScans="36731" ActualExecutions="36731" ActualExecutionMode="Row" ActualElapsedms="23" ActualCPUms="23" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" ActualElapsedms="0" ActualCPUms="0" />
- </RunTimeInformation>
- <NestedLoops Optimized="false">
- <OuterReferences>
- <ColumnReference Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="docid" />
- </OuterReferences>
- <RelOp AvgRowSize="15" EstimateCPU="4.8E-07" EstimateIO="0" EstimateRebinds="319626" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Filter" NodeId="21" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="210.896">
- <OutputList>
- <ColumnReference Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="docid" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="7" ActualRebinds="31573" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="31573" ActualExecutions="31573" ActualExecutionMode="Row" ActualElapsedms="14" ActualCPUms="14" />
- <RunTimeCountersPerThread Thread="8" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="1" ActualRebinds="46187" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="46187" ActualExecutions="46187" ActualExecutionMode="Row" ActualElapsedms="20" ActualCPUms="20" />
- <RunTimeCountersPerThread Thread="2" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="4" ActualRebinds="35120" ActualRewinds="0" ActualRows="35120" Batches="0" ActualEndOfScans="152" ActualExecutions="35120" ActualExecutionMode="Row" ActualElapsedms="103" ActualCPUms="103" />
- <RunTimeCountersPerThread Thread="3" ActualRebinds="25197" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="25197" ActualExecutions="25197" ActualExecutionMode="Row" ActualElapsedms="10" ActualCPUms="10" />
- <RunTimeCountersPerThread Thread="6" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="5" ActualRebinds="36731" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="36731" ActualExecutions="36731" ActualExecutionMode="Row" ActualElapsedms="16" ActualCPUms="16" />
- <RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" ActualElapsedms="0" ActualCPUms="0" />
- </RunTimeInformation>
- <Filter StartupExpression="true">
- <RelOp AvgRowSize="15" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="319626" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Index Seek" NodeId="22" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="210.743" TableCardinality="11645400">
- <OutputList>
- <ColumnReference Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="docid" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="7" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="31573" ActualExecutionMode="Row" ActualElapsedms="9" ActualCPUms="9" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="8" 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" />
- <RunTimeCountersPerThread Thread="1" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="46187" ActualExecutionMode="Row" ActualElapsedms="12" ActualCPUms="12" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="2" 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" />
- <RunTimeCountersPerThread Thread="4" ActualRows="35120" ActualRowsRead="35120" Batches="0" ActualEndOfScans="152" ActualExecutions="35120" ActualExecutionMode="Row" ActualElapsedms="98" ActualCPUms="98" ActualScans="35120" ActualLogicalReads="140480" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="3" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="25197" ActualExecutionMode="Row" ActualElapsedms="6" ActualCPUms="6" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="6" 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" />
- <RunTimeCountersPerThread Thread="5" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="36731" ActualExecutionMode="Row" ActualElapsedms="10" ActualCPUms="10" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" 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="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="docid" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Index="[i2]" TableReferenceId="2" IndexKind="NonClustered" Storage="RowStore" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="ftkey" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[TestDB].[dbo].[InputResult].[Id]">
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="Id" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- <Predicate>
- <ScalarOperator ScalarString="[TestDB].[dbo].[InputResult].[InputUniqueId]={guid'9823FC63-8169-45AD-8AFD-C1E8DBCA6A9B'}">
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'9823FC63-8169-45AD-8AFD-C1E8DBCA6A9B'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Predicate>
- </Filter>
- </RelOp>
- <RelOp AvgRowSize="9" EstimateCPU="0.0416541" EstimateIO="0.810422" EstimateRebinds="319626" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Eager Spool" NodeId="24" Parallel="true" PhysicalOp="Index Spool" EstimatedTotalSubtreeCost="83.7565">
- <OutputList />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="7" ActualRebinds="0" ActualRewinds="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" />
- <RunTimeCountersPerThread Thread="8" ActualRebinds="0" ActualRewinds="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" />
- <RunTimeCountersPerThread Thread="1" ActualRebinds="0" ActualRewinds="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" />
- <RunTimeCountersPerThread Thread="2" ActualRebinds="0" ActualRewinds="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" />
- <RunTimeCountersPerThread Thread="4" ActualRebinds="35120" ActualRewinds="0" ActualRows="34968" Batches="0" ActualEndOfScans="152" ActualExecutions="35120" ActualExecutionMode="Row" ActualElapsedms="680" ActualCPUms="669" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="3" ActualRebinds="0" ActualRewinds="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" />
- <RunTimeCountersPerThread Thread="6" ActualRebinds="0" ActualRewinds="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" />
- <RunTimeCountersPerThread Thread="5" ActualRebinds="0" ActualRewinds="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" />
- <RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- </RunTimeInformation>
- <Spool>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Table="[FulltextMatch]" Column="docid" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[TestDB].[sys].[fulltext_index_docidmap_1672393027].[docid]">
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="docid" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- <RelOp AvgRowSize="15" EstimateCPU="0.0166676" EstimateIO="0.0235675" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="41396" LogicalOp="Table-valued function" NodeId="25" Parallel="true" PhysicalOp="Table-valued function" EstimatedTotalSubtreeCost="0.0402351">
- <OutputList>
- <ColumnReference Table="[FulltextMatch]" Column="docid" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="7" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="8" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="1" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="2" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="4" ActualRebinds="1" ActualRewinds="0" ActualRows="70088" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="509" ActualCPUms="501" />
- <RunTimeCountersPerThread Thread="3" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="6" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="5" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" ActualElapsedms="0" ActualCPUms="0" />
- </RunTimeInformation>
- <TableValuedFunction>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Table="[FulltextMatch]" Column="docid" />
- </DefinedValue>
- </DefinedValues>
- <Object Table="[FulltextMatch]" />
- <ParameterList>
- <ScalarOperator ScalarString="(1)">
- <Const ConstValue="(1)" />
- </ScalarOperator>
- <ScalarOperator ScalarString="(2)">
- <Const ConstValue="(2)" />
- </ScalarOperator>
- <ScalarOperator ScalarString="(0)">
- <Const ConstValue="(0)" />
- </ScalarOperator>
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </ParameterList>
- </TableValuedFunction>
- </RelOp>
- </Spool>
- </RelOp>
- </NestedLoops>
- </RelOp>
- <RelOp AvgRowSize="9" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="319626" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="31" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="295.366">
- <OutputList />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="7" ActualRows="0" Batches="0" ActualEndOfScans="31573" ActualExecutions="31573" ActualExecutionMode="Row" ActualElapsedms="20" ActualCPUms="20" />
- <RunTimeCountersPerThread Thread="4" ActualRows="0" Batches="0" ActualEndOfScans="152" ActualExecutions="152" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="8" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="1" ActualRows="22786" Batches="0" ActualEndOfScans="23401" ActualExecutions="46187" ActualExecutionMode="Row" ActualElapsedms="909" ActualCPUms="788" />
- <RunTimeCountersPerThread Thread="2" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="3" ActualRows="12346" Batches="0" ActualEndOfScans="12851" ActualExecutions="25197" ActualExecutionMode="Row" ActualElapsedms="626" ActualCPUms="129" />
- <RunTimeCountersPerThread Thread="6" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="5" ActualRows="0" Batches="0" ActualEndOfScans="36731" ActualExecutions="36731" ActualExecutionMode="Row" ActualElapsedms="24" ActualCPUms="24" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" ActualElapsedms="0" ActualCPUms="0" />
- </RunTimeInformation>
- <NestedLoops Optimized="false">
- <OuterReferences>
- <ColumnReference Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="docid" />
- </OuterReferences>
- <RelOp AvgRowSize="15" EstimateCPU="4.8E-07" EstimateIO="0" EstimateRebinds="319626" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Filter" NodeId="32" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="210.896">
- <OutputList>
- <ColumnReference Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="docid" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="7" ActualRebinds="31573" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="31573" ActualExecutions="31573" ActualExecutionMode="Row" ActualElapsedms="14" ActualCPUms="14" />
- <RunTimeCountersPerThread Thread="4" ActualRebinds="152" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="152" ActualExecutions="152" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="8" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="1" ActualRebinds="46187" ActualRewinds="0" ActualRows="46187" Batches="0" ActualEndOfScans="23401" ActualExecutions="46187" ActualExecutionMode="Row" ActualElapsedms="155" ActualCPUms="155" />
- <RunTimeCountersPerThread Thread="2" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="3" ActualRebinds="25197" ActualRewinds="0" ActualRows="25197" Batches="0" ActualEndOfScans="12851" ActualExecutions="25197" ActualExecutionMode="Row" ActualElapsedms="81" ActualCPUms="81" />
- <RunTimeCountersPerThread Thread="6" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="5" ActualRebinds="36731" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="36731" ActualExecutions="36731" ActualExecutionMode="Row" ActualElapsedms="17" ActualCPUms="17" />
- <RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" ActualElapsedms="0" ActualCPUms="0" />
- </RunTimeInformation>
- <Filter StartupExpression="true">
- <RelOp AvgRowSize="15" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="319626" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Index Seek" NodeId="33" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="210.743" TableCardinality="11645400">
- <OutputList>
- <ColumnReference Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="docid" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="7" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="31573" ActualExecutionMode="Row" ActualElapsedms="8" ActualCPUms="8" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="4" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="152" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="8" 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" />
- <RunTimeCountersPerThread Thread="1" ActualRows="46187" ActualRowsRead="46187" Batches="0" ActualEndOfScans="23401" ActualExecutions="46187" ActualExecutionMode="Row" ActualElapsedms="145" ActualCPUms="145" ActualScans="46187" ActualLogicalReads="184748" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="2" 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" />
- <RunTimeCountersPerThread Thread="3" ActualRows="25197" ActualRowsRead="25197" Batches="0" ActualEndOfScans="12851" ActualExecutions="25197" ActualExecutionMode="Row" ActualElapsedms="76" ActualCPUms="76" ActualScans="25197" ActualLogicalReads="100788" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="6" 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" />
- <RunTimeCountersPerThread Thread="5" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="36731" ActualExecutionMode="Row" ActualElapsedms="10" ActualCPUms="10" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" 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="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="docid" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Index="[i2]" TableReferenceId="3" IndexKind="NonClustered" Storage="RowStore" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="ftkey" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[TestDB].[dbo].[InputResult].[Id]">
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="Id" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- <Predicate>
- <ScalarOperator ScalarString="[TestDB].[dbo].[InputResult].[InputUniqueId]={guid'25625057-E245-4EE1-8627-7F26D220301E'}">
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'25625057-E245-4EE1-8627-7F26D220301E'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Predicate>
- </Filter>
- </RelOp>
- <RelOp AvgRowSize="9" EstimateCPU="0.0210291" EstimateIO="0.411774" EstimateRebinds="319626" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Eager Spool" NodeId="35" Parallel="true" PhysicalOp="Index Spool" EstimatedTotalSubtreeCost="83.1345">
- <OutputList />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="7" ActualRebinds="0" ActualRewinds="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" />
- <RunTimeCountersPerThread Thread="4" ActualRebinds="0" ActualRewinds="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" />
- <RunTimeCountersPerThread Thread="8" ActualRebinds="0" ActualRewinds="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" />
- <RunTimeCountersPerThread Thread="1" ActualRebinds="46187" ActualRewinds="0" ActualRows="22786" Batches="0" ActualEndOfScans="23401" ActualExecutions="46187" ActualExecutionMode="Row" ActualElapsedms="730" ActualCPUms="610" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="2" ActualRebinds="0" ActualRewinds="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" />
- <RunTimeCountersPerThread Thread="3" ActualRebinds="25197" ActualRewinds="0" ActualRows="12346" Batches="0" ActualEndOfScans="12851" ActualExecutions="25197" ActualExecutionMode="Row" ActualElapsedms="532" ActualCPUms="35" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="6" ActualRebinds="0" ActualRewinds="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" />
- <RunTimeCountersPerThread Thread="5" ActualRebinds="0" ActualRewinds="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" />
- <RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- </RunTimeInformation>
- <Spool>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Table="[FulltextMatch]" Column="docid" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[TestDB].[sys].[fulltext_index_docidmap_1672393027].[docid]">
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="docid" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- <RelOp AvgRowSize="15" EstimateCPU="0.00844342" EstimateIO="0.0133823" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="20771" LogicalOp="Table-valued function" NodeId="36" Parallel="true" PhysicalOp="Table-valued function" EstimatedTotalSubtreeCost="0.0218257">
- <OutputList>
- <ColumnReference Table="[FulltextMatch]" Column="docid" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="7" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="4" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="8" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="1" ActualRebinds="1" ActualRewinds="0" ActualRows="35132" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="477" ActualCPUms="477" />
- <RunTimeCountersPerThread Thread="2" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="3" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="6" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="5" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" ActualElapsedms="0" ActualCPUms="0" />
- </RunTimeInformation>
- <TableValuedFunction>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Table="[FulltextMatch]" Column="docid" />
- </DefinedValue>
- </DefinedValues>
- <Object Table="[FulltextMatch]" />
- <ParameterList>
- <ScalarOperator ScalarString="(2)">
- <Const ConstValue="(2)" />
- </ScalarOperator>
- <ScalarOperator ScalarString="(2)">
- <Const ConstValue="(2)" />
- </ScalarOperator>
- <ScalarOperator ScalarString="(0)">
- <Const ConstValue="(0)" />
- </ScalarOperator>
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </ParameterList>
- </TableValuedFunction>
- </RelOp>
- </Spool>
- </RelOp>
- </NestedLoops>
- </RelOp>
- <RelOp AvgRowSize="9" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="319626" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="42" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="295.501">
- <OutputList />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="7" ActualRows="31508" Batches="0" ActualEndOfScans="65" ActualExecutions="31573" ActualExecutionMode="Row" ActualElapsedms="824" ActualCPUms="823" />
- <RunTimeCountersPerThread Thread="4" ActualRows="0" Batches="0" ActualEndOfScans="152" ActualExecutions="152" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="8" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="2" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="1" ActualRows="0" Batches="0" ActualEndOfScans="23401" ActualExecutions="23401" ActualExecutionMode="Row" ActualElapsedms="17" ActualCPUms="17" />
- <RunTimeCountersPerThread Thread="3" ActualRows="0" Batches="0" ActualEndOfScans="12851" ActualExecutions="12851" ActualExecutionMode="Row" ActualElapsedms="9" ActualCPUms="9" />
- <RunTimeCountersPerThread Thread="6" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="5" ActualRows="36660" Batches="0" ActualEndOfScans="71" ActualExecutions="36731" ActualExecutionMode="Row" ActualElapsedms="934" ActualCPUms="188" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" ActualElapsedms="0" ActualCPUms="0" />
- </RunTimeInformation>
- <NestedLoops Optimized="false">
- <OuterReferences>
- <ColumnReference Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="docid" />
- </OuterReferences>
- <RelOp AvgRowSize="15" EstimateCPU="4.8E-07" EstimateIO="0" EstimateRebinds="319626" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Filter" NodeId="43" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="210.896">
- <OutputList>
- <ColumnReference Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="docid" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="7" ActualRebinds="31573" ActualRewinds="0" ActualRows="31573" Batches="0" ActualEndOfScans="65" ActualExecutions="31573" ActualExecutionMode="Row" ActualElapsedms="101" ActualCPUms="101" />
- <RunTimeCountersPerThread Thread="4" ActualRebinds="152" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="152" ActualExecutions="152" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="8" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="2" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="1" ActualRebinds="23401" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="23401" ActualExecutions="23401" ActualExecutionMode="Row" ActualElapsedms="12" ActualCPUms="12" />
- <RunTimeCountersPerThread Thread="3" ActualRebinds="12851" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="12851" ActualExecutions="12851" ActualExecutionMode="Row" ActualElapsedms="6" ActualCPUms="6" />
- <RunTimeCountersPerThread Thread="6" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="5" ActualRebinds="36731" ActualRewinds="0" ActualRows="36731" Batches="0" ActualEndOfScans="71" ActualExecutions="36731" ActualExecutionMode="Row" ActualElapsedms="116" ActualCPUms="116" />
- <RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" ActualElapsedms="0" ActualCPUms="0" />
- </RunTimeInformation>
- <Filter StartupExpression="true">
- <RelOp AvgRowSize="15" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="319626" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Index Seek" NodeId="44" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="210.743" TableCardinality="11645400">
- <OutputList>
- <ColumnReference Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="docid" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="7" ActualRows="31573" ActualRowsRead="31573" Batches="0" ActualEndOfScans="65" ActualExecutions="31573" ActualExecutionMode="Row" ActualElapsedms="96" ActualCPUms="96" ActualScans="31573" ActualLogicalReads="126292" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="4" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="152" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="8" 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" />
- <RunTimeCountersPerThread Thread="2" 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" />
- <RunTimeCountersPerThread Thread="1" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="23401" ActualExecutionMode="Row" ActualElapsedms="8" ActualCPUms="8" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="3" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="12851" ActualExecutionMode="Row" ActualElapsedms="4" ActualCPUms="4" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="6" 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" />
- <RunTimeCountersPerThread Thread="5" ActualRows="36731" ActualRowsRead="36731" Batches="0" ActualEndOfScans="71" ActualExecutions="36731" ActualExecutionMode="Row" ActualElapsedms="110" ActualCPUms="110" ActualScans="36731" ActualLogicalReads="146924" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" 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="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="docid" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Index="[i2]" TableReferenceId="4" IndexKind="NonClustered" Storage="RowStore" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="ftkey" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[TestDB].[dbo].[InputResult].[Id]">
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="Id" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- <Predicate>
- <ScalarOperator ScalarString="[TestDB].[dbo].[InputResult].[InputUniqueId]={guid'19FD3F45-633F-46FF-A2AC-C6ABE82C74DE'}">
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'19FD3F45-633F-46FF-A2AC-C6ABE82C74DE'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Predicate>
- </Filter>
- </RelOp>
- <RelOp AvgRowSize="9" EstimateCPU="0.0406561" EstimateIO="0.790152" EstimateRebinds="319626" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Eager Spool" NodeId="46" Parallel="true" PhysicalOp="Index Spool" EstimatedTotalSubtreeCost="83.725">
- <OutputList />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="7" ActualRebinds="31573" ActualRewinds="0" ActualRows="31508" Batches="0" ActualEndOfScans="65" ActualExecutions="31573" ActualExecutionMode="Row" ActualElapsedms="708" ActualCPUms="708" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="4" ActualRebinds="0" ActualRewinds="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" />
- <RunTimeCountersPerThread Thread="8" ActualRebinds="0" ActualRewinds="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" />
- <RunTimeCountersPerThread Thread="2" ActualRebinds="0" ActualRewinds="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" />
- <RunTimeCountersPerThread Thread="1" ActualRebinds="0" ActualRewinds="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" />
- <RunTimeCountersPerThread Thread="3" ActualRebinds="0" ActualRewinds="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" />
- <RunTimeCountersPerThread Thread="6" ActualRebinds="0" ActualRewinds="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" />
- <RunTimeCountersPerThread Thread="5" ActualRebinds="36731" ActualRewinds="0" ActualRows="36660" Batches="0" ActualEndOfScans="71" ActualExecutions="36731" ActualExecutionMode="Row" ActualElapsedms="801" ActualCPUms="55" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- </RunTimeInformation>
- <Spool>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Table="[FulltextMatch]" Column="docid" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[TestDB].[sys].[fulltext_index_docidmap_1672393027].[docid]">
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="docid" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- <RelOp AvgRowSize="15" EstimateCPU="0.0162697" EstimateIO="0.0230746" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="40398" LogicalOp="Table-valued function" NodeId="47" Parallel="true" PhysicalOp="Table-valued function" EstimatedTotalSubtreeCost="0.0393443">
- <OutputList>
- <ColumnReference Table="[FulltextMatch]" Column="docid" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="7" ActualRebinds="1" ActualRewinds="0" ActualRows="68168" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="552" ActualCPUms="552" />
- <RunTimeCountersPerThread Thread="4" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="8" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="2" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="1" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="3" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="6" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="5" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" ActualElapsedms="0" ActualCPUms="0" />
- </RunTimeInformation>
- <TableValuedFunction>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Table="[FulltextMatch]" Column="docid" />
- </DefinedValue>
- </DefinedValues>
- <Object Table="[FulltextMatch]" />
- <ParameterList>
- <ScalarOperator ScalarString="(3)">
- <Const ConstValue="(3)" />
- </ScalarOperator>
- <ScalarOperator ScalarString="(2)">
- <Const ConstValue="(2)" />
- </ScalarOperator>
- <ScalarOperator ScalarString="(0)">
- <Const ConstValue="(0)" />
- </ScalarOperator>
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </ParameterList>
- </TableValuedFunction>
- </RelOp>
- </Spool>
- </RelOp>
- </NestedLoops>
- </RelOp>
- <RelOp AvgRowSize="9" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="319626" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="53" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="295.501">
- <OutputList />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="7" ActualRows="0" Batches="0" ActualEndOfScans="65" ActualExecutions="65" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="4" ActualRows="0" Batches="0" ActualEndOfScans="152" ActualExecutions="152" ActualExecutionMode="Row" ActualElapsedms="565" ActualCPUms="555" />
- <RunTimeCountersPerThread Thread="2" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="8" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="1" ActualRows="0" Batches="0" ActualEndOfScans="23401" ActualExecutions="23401" ActualExecutionMode="Row" ActualElapsedms="15" ActualCPUms="15" />
- <RunTimeCountersPerThread Thread="3" ActualRows="0" Batches="0" ActualEndOfScans="12851" ActualExecutions="12851" ActualExecutionMode="Row" ActualElapsedms="8" ActualCPUms="8" />
- <RunTimeCountersPerThread Thread="6" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="5" ActualRows="0" Batches="0" ActualEndOfScans="71" ActualExecutions="71" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" ActualElapsedms="0" ActualCPUms="0" />
- </RunTimeInformation>
- <NestedLoops Optimized="false">
- <OuterReferences>
- <ColumnReference Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="docid" />
- </OuterReferences>
- <RelOp AvgRowSize="15" EstimateCPU="4.8E-07" EstimateIO="0" EstimateRebinds="319626" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Filter" NodeId="54" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="210.896">
- <OutputList>
- <ColumnReference Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="docid" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="7" ActualRebinds="65" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="65" ActualExecutions="65" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="4" ActualRebinds="152" ActualRewinds="0" ActualRows="152" Batches="0" ActualEndOfScans="152" ActualExecutions="152" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="2" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="8" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="1" ActualRebinds="23401" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="23401" ActualExecutions="23401" ActualExecutionMode="Row" ActualElapsedms="10" ActualCPUms="10" />
- <RunTimeCountersPerThread Thread="3" ActualRebinds="12851" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="12851" ActualExecutions="12851" ActualExecutionMode="Row" ActualElapsedms="5" ActualCPUms="5" />
- <RunTimeCountersPerThread Thread="6" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="5" ActualRebinds="71" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="71" ActualExecutions="71" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" ActualElapsedms="0" ActualCPUms="0" />
- </RunTimeInformation>
- <Filter StartupExpression="true">
- <RelOp AvgRowSize="15" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="319626" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Index Seek" NodeId="55" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="210.743" TableCardinality="11645400">
- <OutputList>
- <ColumnReference Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="docid" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="7" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="65" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="4" ActualRows="152" ActualRowsRead="152" Batches="0" ActualEndOfScans="152" ActualExecutions="152" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="152" ActualLogicalReads="608" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="8" 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" />
- <RunTimeCountersPerThread Thread="2" 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" />
- <RunTimeCountersPerThread Thread="1" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="23401" ActualExecutionMode="Row" ActualElapsedms="6" ActualCPUms="6" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="3" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="12851" ActualExecutionMode="Row" ActualElapsedms="3" ActualCPUms="3" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="6" 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" />
- <RunTimeCountersPerThread Thread="5" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="71" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" 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="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="docid" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Index="[i2]" TableReferenceId="5" IndexKind="NonClustered" Storage="RowStore" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="ftkey" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[TestDB].[dbo].[InputResult].[Id]">
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="Id" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- <Predicate>
- <ScalarOperator ScalarString="[TestDB].[dbo].[InputResult].[InputUniqueId]={guid'9823FC63-8169-45AD-8AFD-C1E8DBCA6A9B'}">
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'9823FC63-8169-45AD-8AFD-C1E8DBCA6A9B'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Predicate>
- </Filter>
- </RelOp>
- <RelOp AvgRowSize="9" EstimateCPU="0.0417441" EstimateIO="0.810422" EstimateRebinds="319626" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Eager Spool" NodeId="57" Parallel="true" PhysicalOp="Index Spool" EstimatedTotalSubtreeCost="83.7567">
- <OutputList />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="7" ActualRebinds="0" ActualRewinds="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" />
- <RunTimeCountersPerThread Thread="4" ActualRebinds="152" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="152" ActualExecutions="152" ActualExecutionMode="Row" ActualElapsedms="565" ActualCPUms="554" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="2" ActualRebinds="0" ActualRewinds="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" />
- <RunTimeCountersPerThread Thread="8" ActualRebinds="0" ActualRewinds="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" />
- <RunTimeCountersPerThread Thread="1" ActualRebinds="0" ActualRewinds="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" />
- <RunTimeCountersPerThread Thread="3" ActualRebinds="0" ActualRewinds="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" />
- <RunTimeCountersPerThread Thread="6" ActualRebinds="0" ActualRewinds="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" />
- <RunTimeCountersPerThread Thread="5" ActualRebinds="0" ActualRewinds="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" />
- <RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- </RunTimeInformation>
- <Spool>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Table="[FulltextMatch]" Column="docid" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[TestDB].[sys].[fulltext_index_docidmap_1672393027].[docid]">
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="docid" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- <RelOp AvgRowSize="15" EstimateCPU="0.0167035" EstimateIO="0.0236119" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="41486" LogicalOp="Table-valued function" NodeId="58" Parallel="true" PhysicalOp="Table-valued function" EstimatedTotalSubtreeCost="0.0403154">
- <OutputList>
- <ColumnReference Table="[FulltextMatch]" Column="docid" />
- </OutputList>
- <MemoryFractions Input="1" Output="1" />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="7" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="4" ActualRebinds="1" ActualRewinds="0" ActualRows="70248" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="460" ActualCPUms="451" />
- <RunTimeCountersPerThread Thread="2" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="8" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="1" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="3" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="6" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="5" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" ActualElapsedms="0" ActualCPUms="0" />
- </RunTimeInformation>
- <TableValuedFunction>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Table="[FulltextMatch]" Column="docid" />
- </DefinedValue>
- </DefinedValues>
- <Object Table="[FulltextMatch]" />
- <ParameterList>
- <ScalarOperator ScalarString="(4)">
- <Const ConstValue="(4)" />
- </ScalarOperator>
- <ScalarOperator ScalarString="(2)">
- <Const ConstValue="(2)" />
- </ScalarOperator>
- <ScalarOperator ScalarString="(0)">
- <Const ConstValue="(0)" />
- </ScalarOperator>
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </ParameterList>
- </TableValuedFunction>
- </RelOp>
- </Spool>
- </RelOp>
- </NestedLoops>
- </RelOp>
- <RelOp AvgRowSize="9" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="319626" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="64" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="295.366">
- <OutputList />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="7" ActualRows="0" Batches="0" ActualEndOfScans="65" ActualExecutions="65" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="4" ActualRows="0" Batches="0" ActualEndOfScans="152" ActualExecutions="152" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="1" ActualRows="0" Batches="0" ActualEndOfScans="23401" ActualExecutions="23401" ActualExecutionMode="Row" ActualElapsedms="589" ActualCPUms="589" />
- <RunTimeCountersPerThread Thread="2" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="8" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="3" ActualRows="0" Batches="0" ActualEndOfScans="12851" ActualExecutions="12851" ActualExecutionMode="Row" ActualElapsedms="534" ActualCPUms="61" />
- <RunTimeCountersPerThread Thread="6" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="5" ActualRows="0" Batches="0" ActualEndOfScans="71" ActualExecutions="71" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" ActualElapsedms="0" ActualCPUms="0" />
- </RunTimeInformation>
- <NestedLoops Optimized="false">
- <OuterReferences>
- <ColumnReference Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="docid" />
- </OuterReferences>
- <RelOp AvgRowSize="15" EstimateCPU="4.8E-07" EstimateIO="0" EstimateRebinds="319626" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Filter" NodeId="65" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="210.896">
- <OutputList>
- <ColumnReference Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="docid" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="7" ActualRebinds="65" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="65" ActualExecutions="65" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="4" ActualRebinds="152" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="152" ActualExecutions="152" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="1" ActualRebinds="23401" ActualRewinds="0" ActualRows="23401" Batches="0" ActualEndOfScans="23401" ActualExecutions="23401" ActualExecutionMode="Row" ActualElapsedms="67" ActualCPUms="67" />
- <RunTimeCountersPerThread Thread="2" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="8" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="3" ActualRebinds="12851" ActualRewinds="0" ActualRows="12851" Batches="0" ActualEndOfScans="12851" ActualExecutions="12851" ActualExecutionMode="Row" ActualElapsedms="35" ActualCPUms="35" />
- <RunTimeCountersPerThread Thread="6" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="5" ActualRebinds="71" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="71" ActualExecutions="71" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" ActualElapsedms="0" ActualCPUms="0" />
- </RunTimeInformation>
- <Filter StartupExpression="true">
- <RelOp AvgRowSize="15" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="319626" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Index Seek" NodeId="66" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="210.743" TableCardinality="11645400">
- <OutputList>
- <ColumnReference Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="docid" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="7" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="65" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="4" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="152" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="1" ActualRows="23401" ActualRowsRead="23401" Batches="0" ActualEndOfScans="23401" ActualExecutions="23401" ActualExecutionMode="Row" ActualElapsedms="61" ActualCPUms="61" ActualScans="23401" ActualLogicalReads="93604" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="2" 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" />
- <RunTimeCountersPerThread Thread="8" 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" />
- <RunTimeCountersPerThread Thread="3" ActualRows="12851" ActualRowsRead="12851" Batches="0" ActualEndOfScans="12851" ActualExecutions="12851" ActualExecutionMode="Row" ActualElapsedms="32" ActualCPUms="32" ActualScans="12851" ActualLogicalReads="51404" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="6" 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" />
- <RunTimeCountersPerThread Thread="5" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="71" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" 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="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="docid" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Index="[i2]" TableReferenceId="6" IndexKind="NonClustered" Storage="RowStore" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="ftkey" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[TestDB].[dbo].[InputResult].[Id]">
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="Id" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- <Predicate>
- <ScalarOperator ScalarString="[TestDB].[dbo].[InputResult].[InputUniqueId]={guid'25625057-E245-4EE1-8627-7F26D220301E'}">
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'25625057-E245-4EE1-8627-7F26D220301E'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Predicate>
- </Filter>
- </RelOp>
- <RelOp AvgRowSize="9" EstimateCPU="0.0210291" EstimateIO="0.411774" EstimateRebinds="319626" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Eager Spool" NodeId="68" Parallel="true" PhysicalOp="Index Spool" EstimatedTotalSubtreeCost="83.1345">
- <OutputList />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="7" ActualRebinds="0" ActualRewinds="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" />
- <RunTimeCountersPerThread Thread="4" ActualRebinds="0" ActualRewinds="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" />
- <RunTimeCountersPerThread Thread="1" ActualRebinds="23401" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="23401" ActualExecutions="23401" ActualExecutionMode="Row" ActualElapsedms="508" ActualCPUms="508" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="2" ActualRebinds="0" ActualRewinds="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" />
- <RunTimeCountersPerThread Thread="8" ActualRebinds="0" ActualRewinds="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" />
- <RunTimeCountersPerThread Thread="3" ActualRebinds="12851" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="12851" ActualExecutions="12851" ActualExecutionMode="Row" ActualElapsedms="491" ActualCPUms="18" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="6" ActualRebinds="0" ActualRewinds="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" />
- <RunTimeCountersPerThread Thread="5" ActualRebinds="0" ActualRewinds="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" />
- <RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- </RunTimeInformation>
- <Spool>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Table="[FulltextMatch]" Column="docid" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[TestDB].[sys].[fulltext_index_docidmap_1672393027].[docid]">
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="docid" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- <RelOp AvgRowSize="15" EstimateCPU="0.00844342" EstimateIO="0.0133823" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="20771" LogicalOp="Table-valued function" NodeId="69" Parallel="true" PhysicalOp="Table-valued function" EstimatedTotalSubtreeCost="0.0218257">
- <OutputList>
- <ColumnReference Table="[FulltextMatch]" Column="docid" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="7" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="4" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="1" ActualRebinds="1" ActualRewinds="0" ActualRows="35132" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="415" ActualCPUms="415" />
- <RunTimeCountersPerThread Thread="2" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="8" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="3" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="6" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="5" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" ActualElapsedms="0" ActualCPUms="0" />
- </RunTimeInformation>
- <TableValuedFunction>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Table="[FulltextMatch]" Column="docid" />
- </DefinedValue>
- </DefinedValues>
- <Object Table="[FulltextMatch]" />
- <ParameterList>
- <ScalarOperator ScalarString="(5)">
- <Const ConstValue="(5)" />
- </ScalarOperator>
- <ScalarOperator ScalarString="(2)">
- <Const ConstValue="(2)" />
- </ScalarOperator>
- <ScalarOperator ScalarString="(0)">
- <Const ConstValue="(0)" />
- </ScalarOperator>
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </ParameterList>
- </TableValuedFunction>
- </RelOp>
- </Spool>
- </RelOp>
- </NestedLoops>
- </RelOp>
- <RelOp AvgRowSize="9" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="319626" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="75" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="295.501">
- <OutputList />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="7" ActualRows="0" Batches="0" ActualEndOfScans="65" ActualExecutions="65" ActualExecutionMode="Row" ActualElapsedms="601" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="4" ActualRows="0" Batches="0" ActualEndOfScans="152" ActualExecutions="152" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="2" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="3" ActualRows="0" Batches="0" ActualEndOfScans="12851" ActualExecutions="12851" ActualExecutionMode="Row" ActualElapsedms="8" ActualCPUms="8" />
- <RunTimeCountersPerThread Thread="1" ActualRows="0" Batches="0" ActualEndOfScans="23401" ActualExecutions="23401" ActualExecutionMode="Row" ActualElapsedms="16" ActualCPUms="16" />
- <RunTimeCountersPerThread Thread="8" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="6" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="5" ActualRows="0" Batches="0" ActualEndOfScans="71" ActualExecutions="71" ActualExecutionMode="Row" ActualElapsedms="606" ActualCPUms="606" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" ActualElapsedms="0" ActualCPUms="0" />
- </RunTimeInformation>
- <NestedLoops Optimized="false">
- <OuterReferences>
- <ColumnReference Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="docid" />
- </OuterReferences>
- <RelOp AvgRowSize="15" EstimateCPU="4.8E-07" EstimateIO="0" EstimateRebinds="319626" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Filter" NodeId="76" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="210.896">
- <OutputList>
- <ColumnReference Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="docid" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="7" ActualRebinds="65" ActualRewinds="0" ActualRows="65" Batches="0" ActualEndOfScans="65" ActualExecutions="65" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="4" ActualRebinds="152" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="152" ActualExecutions="152" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="2" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="1" ActualRebinds="23401" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="23401" ActualExecutions="23401" ActualExecutionMode="Row" ActualElapsedms="12" ActualCPUms="12" />
- <RunTimeCountersPerThread Thread="3" ActualRebinds="12851" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="12851" ActualExecutions="12851" ActualExecutionMode="Row" ActualElapsedms="6" ActualCPUms="6" />
- <RunTimeCountersPerThread Thread="8" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="6" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="5" ActualRebinds="71" ActualRewinds="0" ActualRows="71" Batches="0" ActualEndOfScans="71" ActualExecutions="71" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" ActualElapsedms="0" ActualCPUms="0" />
- </RunTimeInformation>
- <Filter StartupExpression="true">
- <RelOp AvgRowSize="15" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="319626" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Index Seek" NodeId="77" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="210.743" TableCardinality="11645400">
- <OutputList>
- <ColumnReference Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="docid" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="7" ActualRows="65" ActualRowsRead="65" Batches="0" ActualEndOfScans="65" ActualExecutions="65" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="65" ActualLogicalReads="260" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="4" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="152" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="2" 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" />
- <RunTimeCountersPerThread Thread="1" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="23401" ActualExecutionMode="Row" ActualElapsedms="7" ActualCPUms="7" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="3" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="12851" ActualExecutionMode="Row" ActualElapsedms="3" ActualCPUms="3" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="8" 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" />
- <RunTimeCountersPerThread Thread="6" 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" />
- <RunTimeCountersPerThread Thread="5" ActualRows="71" ActualRowsRead="71" Batches="0" ActualEndOfScans="71" ActualExecutions="71" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="71" ActualLogicalReads="284" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" 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="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="docid" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Index="[i2]" TableReferenceId="7" IndexKind="NonClustered" Storage="RowStore" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="ftkey" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[TestDB].[dbo].[InputResult].[Id]">
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="Id" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- <Predicate>
- <ScalarOperator ScalarString="[TestDB].[dbo].[InputResult].[InputUniqueId]={guid'19FD3F45-633F-46FF-A2AC-C6ABE82C74DE'}">
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'19FD3F45-633F-46FF-A2AC-C6ABE82C74DE'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Predicate>
- </Filter>
- </RelOp>
- <RelOp AvgRowSize="9" EstimateCPU="0.0406561" EstimateIO="0.790152" EstimateRebinds="319626" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Eager Spool" NodeId="79" Parallel="true" PhysicalOp="Index Spool" EstimatedTotalSubtreeCost="83.725">
- <OutputList />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="7" ActualRebinds="65" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="65" ActualExecutions="65" ActualExecutionMode="Row" ActualElapsedms="600" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="4" ActualRebinds="0" ActualRewinds="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" />
- <RunTimeCountersPerThread Thread="2" ActualRebinds="0" ActualRewinds="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" />
- <RunTimeCountersPerThread Thread="3" ActualRebinds="0" ActualRewinds="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" />
- <RunTimeCountersPerThread Thread="1" ActualRebinds="0" ActualRewinds="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" />
- <RunTimeCountersPerThread Thread="8" ActualRebinds="0" ActualRewinds="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" />
- <RunTimeCountersPerThread Thread="6" ActualRebinds="0" ActualRewinds="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" />
- <RunTimeCountersPerThread Thread="5" ActualRebinds="71" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="71" ActualExecutions="71" ActualExecutionMode="Row" ActualElapsedms="605" ActualCPUms="605" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- </RunTimeInformation>
- <Spool>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Table="[FulltextMatch]" Column="docid" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[TestDB].[sys].[fulltext_index_docidmap_1672393027].[docid]">
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="docid" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- <RelOp AvgRowSize="15" EstimateCPU="0.0162697" EstimateIO="0.0230746" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="40398" LogicalOp="Table-valued function" NodeId="80" Parallel="true" PhysicalOp="Table-valued function" EstimatedTotalSubtreeCost="0.0393443">
- <OutputList>
- <ColumnReference Table="[FulltextMatch]" Column="docid" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="7" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="4" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="2" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="1" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="3" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="8" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="6" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="5" ActualRebinds="1" ActualRewinds="0" ActualRows="68168" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="511" ActualCPUms="511" />
- <RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" ActualElapsedms="0" ActualCPUms="0" />
- </RunTimeInformation>
- <TableValuedFunction>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Table="[FulltextMatch]" Column="docid" />
- </DefinedValue>
- </DefinedValues>
- <Object Table="[FulltextMatch]" />
- <ParameterList>
- <ScalarOperator ScalarString="(6)">
- <Const ConstValue="(6)" />
- </ScalarOperator>
- <ScalarOperator ScalarString="(2)">
- <Const ConstValue="(2)" />
- </ScalarOperator>
- <ScalarOperator ScalarString="(0)">
- <Const ConstValue="(0)" />
- </ScalarOperator>
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </ParameterList>
- </TableValuedFunction>
- </RelOp>
- </Spool>
- </RelOp>
- </NestedLoops>
- </RelOp>
- <RelOp AvgRowSize="9" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="319626" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="86" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="295.501">
- <OutputList />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="7" ActualRows="0" Batches="0" ActualEndOfScans="65" ActualExecutions="65" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="4" ActualRows="0" Batches="0" ActualEndOfScans="152" ActualExecutions="152" ActualExecutionMode="Row" ActualElapsedms="762" ActualCPUms="745" />
- <RunTimeCountersPerThread Thread="2" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="1" ActualRows="0" Batches="0" ActualEndOfScans="23401" ActualExecutions="23401" ActualExecutionMode="Row" ActualElapsedms="15" ActualCPUms="15" />
- <RunTimeCountersPerThread Thread="3" ActualRows="0" Batches="0" ActualEndOfScans="12851" ActualExecutions="12851" ActualExecutionMode="Row" ActualElapsedms="8" ActualCPUms="8" />
- <RunTimeCountersPerThread Thread="8" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="6" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="5" ActualRows="0" Batches="0" ActualEndOfScans="71" ActualExecutions="71" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" ActualElapsedms="0" ActualCPUms="0" />
- </RunTimeInformation>
- <NestedLoops Optimized="false">
- <OuterReferences>
- <ColumnReference Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="docid" />
- </OuterReferences>
- <RelOp AvgRowSize="15" EstimateCPU="4.8E-07" EstimateIO="0" EstimateRebinds="319626" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Filter" NodeId="87" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="210.896">
- <OutputList>
- <ColumnReference Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="docid" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="7" ActualRebinds="65" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="65" ActualExecutions="65" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="4" ActualRebinds="152" ActualRewinds="0" ActualRows="152" Batches="0" ActualEndOfScans="152" ActualExecutions="152" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="2" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="1" ActualRebinds="23401" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="23401" ActualExecutions="23401" ActualExecutionMode="Row" ActualElapsedms="10" ActualCPUms="10" />
- <RunTimeCountersPerThread Thread="3" ActualRebinds="12851" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="12851" ActualExecutions="12851" ActualExecutionMode="Row" ActualElapsedms="5" ActualCPUms="5" />
- <RunTimeCountersPerThread Thread="8" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="6" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="5" ActualRebinds="71" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="71" ActualExecutions="71" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" ActualElapsedms="0" ActualCPUms="0" />
- </RunTimeInformation>
- <Filter StartupExpression="true">
- <RelOp AvgRowSize="15" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="319626" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Index Seek" NodeId="88" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="210.743" TableCardinality="11645400">
- <OutputList>
- <ColumnReference Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="docid" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="7" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="65" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="4" ActualRows="152" ActualRowsRead="152" Batches="0" ActualEndOfScans="152" ActualExecutions="152" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="152" ActualLogicalReads="608" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="2" 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" />
- <RunTimeCountersPerThread Thread="1" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="23401" ActualExecutionMode="Row" ActualElapsedms="6" ActualCPUms="6" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="3" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="12851" ActualExecutionMode="Row" ActualElapsedms="3" ActualCPUms="3" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="8" 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" />
- <RunTimeCountersPerThread Thread="6" 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" />
- <RunTimeCountersPerThread Thread="5" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="71" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" 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="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="docid" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Index="[i2]" TableReferenceId="8" IndexKind="NonClustered" Storage="RowStore" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="ftkey" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[TestDB].[dbo].[InputResult].[Id]">
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="Id" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- <Predicate>
- <ScalarOperator ScalarString="[TestDB].[dbo].[InputResult].[InputUniqueId]={guid'9823FC63-8169-45AD-8AFD-C1E8DBCA6A9B'}">
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'9823FC63-8169-45AD-8AFD-C1E8DBCA6A9B'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Predicate>
- </Filter>
- </RelOp>
- <RelOp AvgRowSize="9" EstimateCPU="0.136441" EstimateIO="2.6415" EstimateRebinds="319626" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Eager Spool" NodeId="90" Parallel="true" PhysicalOp="Index Spool" EstimatedTotalSubtreeCost="86.6139">
- <OutputList />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="7" ActualRebinds="0" ActualRewinds="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" />
- <RunTimeCountersPerThread Thread="4" ActualRebinds="152" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="152" ActualExecutions="152" ActualExecutionMode="Row" ActualElapsedms="762" ActualCPUms="744" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="2" ActualRebinds="0" ActualRewinds="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" />
- <RunTimeCountersPerThread Thread="1" ActualRebinds="0" ActualRewinds="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" />
- <RunTimeCountersPerThread Thread="3" ActualRebinds="0" ActualRewinds="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" />
- <RunTimeCountersPerThread Thread="8" ActualRebinds="0" ActualRewinds="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" />
- <RunTimeCountersPerThread Thread="6" ActualRebinds="0" ActualRewinds="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" />
- <RunTimeCountersPerThread Thread="5" ActualRebinds="0" ActualRewinds="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" />
- <RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- </RunTimeInformation>
- <Spool>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Table="[FulltextMatch]" Column="docid" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[TestDB].[sys].[fulltext_index_docidmap_1672393027].[docid]">
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="docid" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- <RelOp AvgRowSize="15" EstimateCPU="0.054464" EstimateIO="0.0703759" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="136183" LogicalOp="Table-valued function" NodeId="91" Parallel="true" PhysicalOp="Table-valued function" EstimatedTotalSubtreeCost="0.12484">
- <OutputList>
- <ColumnReference Table="[FulltextMatch]" Column="docid" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="7" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="4" ActualRebinds="1" ActualRewinds="0" ActualRows="229500" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="421" ActualCPUms="412" />
- <RunTimeCountersPerThread Thread="2" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="1" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="3" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="8" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="6" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="5" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" ActualElapsedms="0" ActualCPUms="0" />
- </RunTimeInformation>
- <TableValuedFunction>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Table="[FulltextMatch]" Column="docid" />
- </DefinedValue>
- </DefinedValues>
- <Object Table="[FulltextMatch]" />
- <ParameterList>
- <ScalarOperator ScalarString="(7)">
- <Const ConstValue="(7)" />
- </ScalarOperator>
- <ScalarOperator ScalarString="(2)">
- <Const ConstValue="(2)" />
- </ScalarOperator>
- <ScalarOperator ScalarString="(0)">
- <Const ConstValue="(0)" />
- </ScalarOperator>
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </ParameterList>
- </TableValuedFunction>
- </RelOp>
- </Spool>
- </RelOp>
- </NestedLoops>
- </RelOp>
- <RelOp AvgRowSize="9" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="319626" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="97" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="294.765">
- <OutputList />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="7" ActualRows="0" Batches="0" ActualEndOfScans="65" ActualExecutions="65" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="4" ActualRows="0" Batches="0" ActualEndOfScans="152" ActualExecutions="152" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="2" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="3" ActualRows="0" Batches="0" ActualEndOfScans="12851" ActualExecutions="12851" ActualExecutionMode="Row" ActualElapsedms="557" ActualCPUms="59" />
- <RunTimeCountersPerThread Thread="1" ActualRows="0" Batches="0" ActualEndOfScans="23401" ActualExecutions="23401" ActualExecutionMode="Row" ActualElapsedms="608" ActualCPUms="607" />
- <RunTimeCountersPerThread Thread="8" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="6" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="5" ActualRows="0" Batches="0" ActualEndOfScans="71" ActualExecutions="71" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" ActualElapsedms="0" ActualCPUms="0" />
- </RunTimeInformation>
- <NestedLoops Optimized="false">
- <OuterReferences>
- <ColumnReference Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="docid" />
- </OuterReferences>
- <RelOp AvgRowSize="15" EstimateCPU="4.8E-07" EstimateIO="0" EstimateRebinds="319626" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Filter" NodeId="98" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="210.896">
- <OutputList>
- <ColumnReference Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="docid" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="7" ActualRebinds="65" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="65" ActualExecutions="65" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="4" ActualRebinds="152" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="152" ActualExecutions="152" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="2" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="3" ActualRebinds="12851" ActualRewinds="0" ActualRows="12851" Batches="0" ActualEndOfScans="12851" ActualExecutions="12851" ActualExecutionMode="Row" ActualElapsedms="35" ActualCPUms="35" />
- <RunTimeCountersPerThread Thread="1" ActualRebinds="23401" ActualRewinds="0" ActualRows="23401" Batches="0" ActualEndOfScans="23401" ActualExecutions="23401" ActualExecutionMode="Row" ActualElapsedms="66" ActualCPUms="66" />
- <RunTimeCountersPerThread Thread="8" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="6" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="5" ActualRebinds="71" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="71" ActualExecutions="71" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" ActualElapsedms="0" ActualCPUms="0" />
- </RunTimeInformation>
- <Filter StartupExpression="true">
- <RelOp AvgRowSize="15" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="319626" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Index Seek" NodeId="99" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="210.743" TableCardinality="11645400">
- <OutputList>
- <ColumnReference Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="docid" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="7" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="65" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="4" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="152" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="2" 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" />
- <RunTimeCountersPerThread Thread="3" ActualRows="12851" ActualRowsRead="12851" Batches="0" ActualEndOfScans="12851" ActualExecutions="12851" ActualExecutionMode="Row" ActualElapsedms="32" ActualCPUms="32" ActualScans="12851" ActualLogicalReads="51404" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="1" ActualRows="23401" ActualRowsRead="23401" Batches="0" ActualEndOfScans="23401" ActualExecutions="23401" ActualExecutionMode="Row" ActualElapsedms="60" ActualCPUms="60" ActualScans="23401" ActualLogicalReads="93604" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="8" 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" />
- <RunTimeCountersPerThread Thread="6" 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" />
- <RunTimeCountersPerThread Thread="5" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="71" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" 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="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="docid" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Index="[i2]" TableReferenceId="9" IndexKind="NonClustered" Storage="RowStore" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="ftkey" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[TestDB].[dbo].[InputResult].[Id]">
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="Id" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- <Predicate>
- <ScalarOperator ScalarString="[TestDB].[dbo].[InputResult].[InputUniqueId]={guid'25625057-E245-4EE1-8627-7F26D220301E'}">
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'25625057-E245-4EE1-8627-7F26D220301E'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Predicate>
- </Filter>
- </RelOp>
- <RelOp AvgRowSize="9" EstimateCPU="0.0010781" EstimateIO="0.0266385" EstimateRebinds="319626" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Eager Spool" NodeId="101" Parallel="true" PhysicalOp="Index Spool" EstimatedTotalSubtreeCost="82.5334">
- <OutputList />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="7" ActualRebinds="0" ActualRewinds="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" />
- <RunTimeCountersPerThread Thread="4" ActualRebinds="0" ActualRewinds="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" />
- <RunTimeCountersPerThread Thread="2" ActualRebinds="0" ActualRewinds="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" />
- <RunTimeCountersPerThread Thread="3" ActualRebinds="12851" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="12851" ActualExecutions="12851" ActualExecutionMode="Row" ActualElapsedms="514" ActualCPUms="16" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="1" ActualRebinds="23401" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="23401" ActualExecutions="23401" ActualExecutionMode="Row" ActualElapsedms="528" ActualCPUms="527" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="8" ActualRebinds="0" ActualRewinds="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" />
- <RunTimeCountersPerThread Thread="6" ActualRebinds="0" ActualRewinds="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" />
- <RunTimeCountersPerThread Thread="5" ActualRebinds="0" ActualRewinds="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" />
- <RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- </RunTimeInformation>
- <Spool>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Table="[FulltextMatch]" Column="docid" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[TestDB].[sys].[fulltext_index_docidmap_1672393027].[docid]">
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="docid" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- <RelOp AvgRowSize="15" EstimateCPU="0.000487963" EstimateIO="0.00352994" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="820" LogicalOp="Table-valued function" NodeId="102" Parallel="true" PhysicalOp="Table-valued function" EstimatedTotalSubtreeCost="0.0040179">
- <OutputList>
- <ColumnReference Table="[FulltextMatch]" Column="docid" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="7" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="4" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="2" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="3" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="1" ActualRebinds="1" ActualRewinds="0" ActualRows="684" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="495" ActualCPUms="495" />
- <RunTimeCountersPerThread Thread="8" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="6" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="5" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" ActualElapsedms="0" ActualCPUms="0" />
- </RunTimeInformation>
- <TableValuedFunction>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Table="[FulltextMatch]" Column="docid" />
- </DefinedValue>
- </DefinedValues>
- <Object Table="[FulltextMatch]" />
- <ParameterList>
- <ScalarOperator ScalarString="(8)">
- <Const ConstValue="(8)" />
- </ScalarOperator>
- <ScalarOperator ScalarString="(2)">
- <Const ConstValue="(2)" />
- </ScalarOperator>
- <ScalarOperator ScalarString="(0)">
- <Const ConstValue="(0)" />
- </ScalarOperator>
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </ParameterList>
- </TableValuedFunction>
- </RelOp>
- </Spool>
- </RelOp>
- </NestedLoops>
- </RelOp>
- <RelOp AvgRowSize="9" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="319626" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="108" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="295.501">
- <OutputList />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="7" ActualRows="0" Batches="0" ActualEndOfScans="65" ActualExecutions="65" ActualExecutionMode="Row" ActualElapsedms="595" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="4" ActualRows="0" Batches="0" ActualEndOfScans="152" ActualExecutions="152" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="2" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="3" ActualRows="0" Batches="0" ActualEndOfScans="12851" ActualExecutions="12851" ActualExecutionMode="Row" ActualElapsedms="4" ActualCPUms="4" />
- <RunTimeCountersPerThread Thread="1" ActualRows="0" Batches="0" ActualEndOfScans="23401" ActualExecutions="23401" ActualExecutionMode="Row" ActualElapsedms="8" ActualCPUms="8" />
- <RunTimeCountersPerThread Thread="8" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="6" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="5" ActualRows="0" Batches="0" ActualEndOfScans="71" ActualExecutions="71" ActualExecutionMode="Row" ActualElapsedms="595" ActualCPUms="595" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" ActualElapsedms="0" ActualCPUms="0" />
- </RunTimeInformation>
- <NestedLoops Optimized="false">
- <OuterReferences>
- <ColumnReference Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="docid" />
- </OuterReferences>
- <RelOp AvgRowSize="15" EstimateCPU="4.8E-07" EstimateIO="0" EstimateRebinds="319626" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Filter" NodeId="109" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="210.896">
- <OutputList>
- <ColumnReference Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="docid" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="7" ActualRebinds="65" ActualRewinds="0" ActualRows="65" Batches="0" ActualEndOfScans="65" ActualExecutions="65" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="4" ActualRebinds="152" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="152" ActualExecutions="152" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="2" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="3" ActualRebinds="12851" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="12851" ActualExecutions="12851" ActualExecutionMode="Row" ActualElapsedms="2" ActualCPUms="2" />
- <RunTimeCountersPerThread Thread="1" ActualRebinds="23401" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="23401" ActualExecutions="23401" ActualExecutionMode="Row" ActualElapsedms="4" ActualCPUms="4" />
- <RunTimeCountersPerThread Thread="8" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="6" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="5" ActualRebinds="71" ActualRewinds="0" ActualRows="71" Batches="0" ActualEndOfScans="71" ActualExecutions="71" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" ActualElapsedms="0" ActualCPUms="0" />
- </RunTimeInformation>
- <Filter StartupExpression="true">
- <RelOp AvgRowSize="15" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="319626" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Index Seek" NodeId="110" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="210.743" TableCardinality="11645400">
- <OutputList>
- <ColumnReference Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="docid" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="7" ActualRows="65" ActualRowsRead="65" Batches="0" ActualEndOfScans="65" ActualExecutions="65" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="65" ActualLogicalReads="260" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="4" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="152" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="2" 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" />
- <RunTimeCountersPerThread Thread="3" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="12851" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="1" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="23401" ActualExecutionMode="Row" ActualElapsedms="1" ActualCPUms="1" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="8" 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" />
- <RunTimeCountersPerThread Thread="6" 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" />
- <RunTimeCountersPerThread Thread="5" ActualRows="71" ActualRowsRead="71" Batches="0" ActualEndOfScans="71" ActualExecutions="71" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="71" ActualLogicalReads="284" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" 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="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="docid" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Index="[i2]" TableReferenceId="10" IndexKind="NonClustered" Storage="RowStore" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="ftkey" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[TestDB].[dbo].[InputResult].[Id]">
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="Id" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- <Predicate>
- <ScalarOperator ScalarString="[TestDB].[dbo].[InputResult].[InputUniqueId]={guid'19FD3F45-633F-46FF-A2AC-C6ABE82C74DE'}">
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[dbo]" Table="[InputResult]" Column="InputUniqueId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="{guid'19FD3F45-633F-46FF-A2AC-C6ABE82C74DE'}" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Predicate>
- </Filter>
- </RelOp>
- <RelOp AvgRowSize="9" EstimateCPU="0.0406561" EstimateIO="0.790152" EstimateRebinds="319626" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Eager Spool" NodeId="112" Parallel="true" PhysicalOp="Index Spool" EstimatedTotalSubtreeCost="83.725">
- <OutputList />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="7" ActualRebinds="65" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="65" ActualExecutions="65" ActualExecutionMode="Row" ActualElapsedms="594" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="4" ActualRebinds="0" ActualRewinds="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" />
- <RunTimeCountersPerThread Thread="2" ActualRebinds="0" ActualRewinds="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" />
- <RunTimeCountersPerThread Thread="3" ActualRebinds="0" ActualRewinds="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" />
- <RunTimeCountersPerThread Thread="1" ActualRebinds="0" ActualRewinds="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" />
- <RunTimeCountersPerThread Thread="8" ActualRebinds="0" ActualRewinds="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" />
- <RunTimeCountersPerThread Thread="6" ActualRebinds="0" ActualRewinds="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" />
- <RunTimeCountersPerThread Thread="5" ActualRebinds="71" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="71" ActualExecutions="71" ActualExecutionMode="Row" ActualElapsedms="594" ActualCPUms="594" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- </RunTimeInformation>
- <Spool>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Table="[FulltextMatch]" Column="docid" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[TestDB].[sys].[fulltext_index_docidmap_1672393027].[docid]">
- <Identifier>
- <ColumnReference Database="[TestDB]" Schema="[sys]" Table="[fulltext_index_docidmap_1672393027]" Column="docid" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- <RelOp AvgRowSize="15" EstimateCPU="0.0162697" EstimateIO="0.0230746" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="40398" LogicalOp="Table-valued function" NodeId="113" Parallel="true" PhysicalOp="Table-valued function" EstimatedTotalSubtreeCost="0.0393443">
- <OutputList>
- <ColumnReference Table="[FulltextMatch]" Column="docid" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="7" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="4" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="2" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="3" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="1" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="8" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="6" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- <RunTimeCountersPerThread Thread="5" ActualRebinds="1" ActualRewinds="0" ActualRows="68168" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="493" ActualCPUms="493" />
- <RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" ActualElapsedms="0" ActualCPUms="0" />
- </RunTimeInformation>
- <TableValuedFunction>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Table="[FulltextMatch]" Column="docid" />
- </DefinedValue>
- </DefinedValues>
- <Object Table="[FulltextMatch]" />
- <ParameterList>
- <ScalarOperator ScalarString="(9)">
- <Const ConstValue="(9)" />
- </ScalarOperator>
- <ScalarOperator ScalarString="(2)">
- <Const ConstValue="(2)" />
- </ScalarOperator>
- <ScalarOperator ScalarString="(0)">
- <Const ConstValue="(0)" />
- </ScalarOperator>
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </ParameterList>
- </TableValuedFunction>
- </RelOp>
- </Spool>
- </RelOp>
- </NestedLoops>
- </RelOp>
- </Concat>
- </RelOp>
- </NestedLoops>
- </RelOp>
- </Parallelism>
- </RelOp>
- </QueryPlan>
- </StmtSimple>
- </Statements>
- </Batch>
- </BatchSequence>
- </ShowPlanXML>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement