Skip to content

Instantly share code, notes, and snippets.

@gilbonbaggins

gilbonbaggins/CEModel120+T4199.xml

Created February 13, 2020 14:57
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save gilbonbaggins/5e96c8f7dc85d05686e0e70f5ef794f1 to your computer and use it in GitHub Desktop.
Save gilbonbaggins/5e96c8f7dc85d05686e0e70f5ef794f1 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
CEModel120+T4199.xml
<?xml version="1.0" encoding="utf-16"?>
<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.480" Build="12.0.6329.1">
<BatchSequence>
<Batch>
<Statements>
<StmtSimple StatementText="SELECT &#xD;&#xA; t.CanDelete &#xD;&#xA; , t.CanDownload &#xD;&#xA; , t.CanUpload &#xD;&#xA; , t.CanView &#xD;&#xA; , i.ClientCreatedDate &#xD;&#xA; , i.ClientModifiedDate &#xD;&#xA; , i.CreationDate &#xD;&#xA; , uc.FirstName AS CreatorFirstName &#xD;&#xA; , i.CreatorID &#xD;&#xA; , uc.LastName AS CreatorLastName &#xD;&#xA; , i.ExpirationDate &#xD;&#xA; , i.FileCount &#xD;&#xA; , i.FileName &#xD;&#xA; , i.FilePath &#xD;&#xA; , i.FileSizeBytes &#xD;&#xA; , i.Hash &#xD;&#xA; , t.ItemID AS ID &#xD;&#xA; , sl.ExpirationDate AS LockExpirationDate &#xD;&#xA; , sl.LockID &#xD;&#xA; , ea.Email AS LockOwnerEmailAddress &#xD;&#xA; , ul.FirstName AS LockOwnerFirstName &#xD;&#xA; , sl.LockOwnerID &#xD;&#xA; , ul.LastName AS LockOwnerLastName &#xD;&#xA; , sl.StreamLockTypeID AS LockTypeID &#xD;&#xA; , i.Name &#xD;&#xA; , i.ProgenyEditDate &#xD;&#xA; , t.StreamID &#xD;&#xA; , i.[Type] &#xD;&#xA; FROM #CurrentItemsWithPerms t &#xD;&#xA; INNER JOIN dbo.Items i &#xD;&#xA; ON i.ID = t.ItemID &#xD;&#xA; INNER JOIN dbo.Users uc &#xD;&#xA; ON uc.ID = i.CreatorID &#xD;&#xA; LEFT OUTER JOIN dbo.StreamLock sl &#xD;&#xA; ON sl.StreamID = t.StreamID &#xD;&#xA; LEFT OUTER JOIN dbo.Users ul &#xD;&#xA; ON ul.ID = sl.LockOwnerID &#xD;&#xA; LEFT OUTER JOIN dbo.EmailAddresses ea &#xD;&#xA; ON ea.UserID = ul.ID &#xD;&#xA; AND ea.IsPrimary = 1 &#xD;&#xA; WHERE &#xD;&#xA; t.ItemID &lt;&gt; @ParentID -- Exclude the Parent from the results (it was only needed for permissions) &#xD;&#xA; AND t.PermissionsFound = 1" StatementId="9" StatementCompId="36" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="113.782" StatementEstRows="3.9368e+006" StatementOptmLevel="FULL" QueryHash="0xDA586B25C1EC6F86" QueryPlanHash="0xBC4BF1F401FF61C3" CardinalityEstimationModelVersion="120">
<StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="false" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false" />
<QueryPlan DegreeOfParallelism="8" MemoryGrant="50888" CachedPlanSize="184" CompileTime="59" CompileCPU="59" CompileMemory="1624">
<ThreadStat Branches="2" UsedThreads="16">
<ThreadReservation NodeId="0" ReservedThreads="16" />
</ThreadStat>
<MemoryGrantInfo SerialRequiredMemory="2560" SerialDesiredMemory="31544" RequiredMemory="21896" DesiredMemory="50888" RequestedMemory="50888" GrantWaitTime="0" GrantedMemory="50888" MaxUsedMemory="10664" MaxQueryMemory="22623464" />
<OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="759558" EstimatedPagesCached="759558" EstimatedAvailableDegreeOfParallelism="8" MaxCompileMemory="87733448" />
<TraceFlags IsCompileTime="1">
<TraceFlag Value="1117" Scope="Global" />
<TraceFlag Value="1118" Scope="Global" />
<TraceFlag Value="1800" Scope="Global" />
<TraceFlag Value="2371" Scope="Global" />
<TraceFlag Value="4199" Scope="Global" />
</TraceFlags>
<TraceFlags IsCompileTime="0">
<TraceFlag Value="1117" Scope="Global" />
<TraceFlag Value="1118" Scope="Global" />
<TraceFlag Value="1800" Scope="Global" />
<TraceFlag Value="2371" Scope="Global" />
<TraceFlag Value="4199" Scope="Global" />
</TraceFlags>
<QueryTimeStats ElapsedTime="74" CpuTime="197" />
<RelOp NodeId="0" PhysicalOp="Parallelism" LogicalOp="Gather Streams" EstimateRows="3.9368e+006" EstimateIO="0" EstimateCPU="80.8803" AvgRowSize="2176" EstimatedTotalSubtreeCost="113.782" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="StreamID" />
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="ItemID" />
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="CanDelete" />
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="CanDownload" />
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="CanUpload" />
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="CanView" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="Name" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="Type" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="CreationDate" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="ExpirationDate" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="CreatorID" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="FileName" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="FilePath" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="FileSizeBytes" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="Hash" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="FileCount" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="ProgenyEditDate" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="ClientModifiedDate" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="ClientCreatedDate" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Users]" Alias="[uc]" Column="FirstName" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Users]" Alias="[uc]" Column="LastName" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="LockID" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="LockOwnerID" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="StreamLockTypeID" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="ExpirationDate" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Users]" Alias="[ul]" Column="FirstName" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Users]" Alias="[ul]" Column="LastName" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[EmailAddresses]" Alias="[ea]" Column="Email" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="5229" ActualElapsedms="67" ActualCPUms="2" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<Parallelism>
<RelOp NodeId="1" PhysicalOp="Nested Loops" LogicalOp="Left Outer Join" EstimateRows="3.9368e+006" EstimateIO="0" EstimateCPU="0.00544581" AvgRowSize="2176" EstimatedTotalSubtreeCost="32.9015" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="StreamID" />
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="ItemID" />
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="CanDelete" />
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="CanDownload" />
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="CanUpload" />
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="CanView" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="Name" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="Type" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="CreationDate" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="ExpirationDate" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="CreatorID" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="FileName" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="FilePath" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="FileSizeBytes" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="Hash" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="FileCount" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="ProgenyEditDate" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="ClientModifiedDate" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="ClientCreatedDate" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Users]" Alias="[uc]" Column="FirstName" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Users]" Alias="[uc]" Column="LastName" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="LockID" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="LockOwnerID" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="StreamLockTypeID" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="ExpirationDate" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Users]" Alias="[ul]" Column="FirstName" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Users]" Alias="[ul]" Column="LastName" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[EmailAddresses]" Alias="[ea]" Column="Email" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="8" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="38" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="6" ActualRows="5229" Batches="0" ActualExecutionMode="Row" ActualElapsedms="63" ActualCPUms="23" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="7" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="38" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="5" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="38" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="38" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="38" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="38" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="38" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualElapsedms="2" ActualCPUms="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<NestedLoops Optimized="0">
<OuterReferences>
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="LockOwnerID" />
</OuterReferences>
<RelOp NodeId="2" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="10411.6" EstimateIO="0.00140766" EstimateCPU="0.0797368" AvgRowSize="1594" EstimatedTotalSubtreeCost="31.7878" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="StreamID" />
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="ItemID" />
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="CanDelete" />
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="CanDownload" />
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="CanUpload" />
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="CanView" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="Name" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="Type" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="CreationDate" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="ExpirationDate" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="CreatorID" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="FileName" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="FilePath" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="FileSizeBytes" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="Hash" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="FileCount" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="ProgenyEditDate" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="ClientModifiedDate" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="ClientCreatedDate" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Users]" Alias="[uc]" Column="FirstName" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Users]" Alias="[uc]" Column="LastName" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="LockID" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="LockOwnerID" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="StreamLockTypeID" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="ExpirationDate" />
</OutputList>
<Warnings>
<SpillToTempDb SpillLevel="1" SpilledThreadCount="1" />
<SortSpillDetails GrantedMemoryKb="3104" UsedMemoryKb="3104" WritesToTempDb="486" ReadsFromTempDb="486" />
</Warnings>
<MemoryFractions Input="0.716809" Output="1" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="8" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="38" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="3104" OutputMemoryGrant="3752" UsedMemoryGrant="0" />
<RunTimeCountersPerThread Thread="7" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="38" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="3104" OutputMemoryGrant="3752" UsedMemoryGrant="0" />
<RunTimeCountersPerThread Thread="6" ActualRows="5229" Batches="0" ActualExecutionMode="Row" ActualElapsedms="63" ActualCPUms="23" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="3104" OutputMemoryGrant="3752" UsedMemoryGrant="3104" />
<RunTimeCountersPerThread Thread="4" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="38" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="3104" OutputMemoryGrant="3752" UsedMemoryGrant="0" />
<RunTimeCountersPerThread Thread="5" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="38" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="3104" OutputMemoryGrant="3752" UsedMemoryGrant="0" />
<RunTimeCountersPerThread Thread="3" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="38" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="3104" OutputMemoryGrant="3752" UsedMemoryGrant="0" />
<RunTimeCountersPerThread Thread="2" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="38" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="3104" OutputMemoryGrant="3752" UsedMemoryGrant="0" />
<RunTimeCountersPerThread Thread="1" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="38" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="3104" OutputMemoryGrant="3752" UsedMemoryGrant="0" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualElapsedms="2" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="0" ActualRewinds="0" ActualEndOfScans="0" ActualExecutions="0" InputMemoryGrant="3104" OutputMemoryGrant="3752" UsedMemoryGrant="0" />
</RunTimeInformation>
<Sort Distinct="0">
<OrderBy>
<OrderByColumn Ascending="1">
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="LockOwnerID" />
</OrderByColumn>
</OrderBy>
<RelOp NodeId="3" PhysicalOp="Parallelism" LogicalOp="Repartition Streams" EstimateRows="10411.6" EstimateIO="0" EstimateCPU="0.190792" AvgRowSize="1594" EstimatedTotalSubtreeCost="31.7067" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="StreamID" />
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="ItemID" />
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="CanDelete" />
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="CanDownload" />
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="CanUpload" />
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="CanView" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="Name" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="Type" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="CreationDate" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="ExpirationDate" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="CreatorID" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="FileName" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="FilePath" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="FileSizeBytes" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="Hash" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="FileCount" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="ProgenyEditDate" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="ClientModifiedDate" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="ClientCreatedDate" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Users]" Alias="[uc]" Column="FirstName" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Users]" Alias="[uc]" Column="LastName" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="LockID" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="LockOwnerID" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="StreamLockTypeID" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="ExpirationDate" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="8" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="38" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="6" ActualRows="5229" Batches="0" ActualExecutionMode="Row" ActualElapsedms="20" ActualCPUms="4" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="7" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="38" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="5" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="38" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="38" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="38" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="38" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="38" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualElapsedms="2" ActualCPUms="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Parallelism PartitioningType="Hash">
<PartitionColumns>
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="LockOwnerID" />
</PartitionColumns>
<RelOp NodeId="4" PhysicalOp="Hash Match" LogicalOp="Right Outer Join" EstimateRows="10411.6" EstimateIO="0" EstimateCPU="0.0340369" AvgRowSize="1594" EstimatedTotalSubtreeCost="31.5159" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="StreamID" />
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="ItemID" />
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="CanDelete" />
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="CanDownload" />
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="CanUpload" />
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="CanView" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="Name" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="Type" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="CreationDate" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="ExpirationDate" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="CreatorID" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="FileName" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="FilePath" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="FileSizeBytes" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="Hash" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="FileCount" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="ProgenyEditDate" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="ClientModifiedDate" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="ClientCreatedDate" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Users]" Alias="[uc]" Column="FirstName" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Users]" Alias="[uc]" Column="LastName" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="LockID" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="LockOwnerID" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="StreamLockTypeID" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="ExpirationDate" />
</OutputList>
<MemoryFractions Input="0.0380117" Output="0.0107646" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="5" ActualRows="736" Batches="0" ActualExecutionMode="Row" ActualElapsedms="17" ActualCPUms="17" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="1160" OutputMemoryGrant="1056" UsedMemoryGrant="320" />
<RunTimeCountersPerThread Thread="8" ActualRows="736" Batches="0" ActualExecutionMode="Row" ActualElapsedms="18" ActualCPUms="16" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="1160" OutputMemoryGrant="1056" UsedMemoryGrant="320" />
<RunTimeCountersPerThread Thread="2" ActualRows="736" Batches="0" ActualExecutionMode="Row" ActualElapsedms="15" ActualCPUms="14" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="1160" OutputMemoryGrant="1056" UsedMemoryGrant="320" />
<RunTimeCountersPerThread Thread="1" ActualRows="627" Batches="0" ActualExecutionMode="Row" ActualElapsedms="19" ActualCPUms="19" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="1160" OutputMemoryGrant="1056" UsedMemoryGrant="320" />
<RunTimeCountersPerThread Thread="4" ActualRows="736" Batches="0" ActualExecutionMode="Row" ActualElapsedms="17" ActualCPUms="17" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="1160" OutputMemoryGrant="1056" UsedMemoryGrant="320" />
<RunTimeCountersPerThread Thread="3" ActualRows="554" Batches="0" ActualExecutionMode="Row" ActualElapsedms="16" ActualCPUms="16" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="1160" OutputMemoryGrant="1056" UsedMemoryGrant="320" />
<RunTimeCountersPerThread Thread="6" ActualRows="552" Batches="0" ActualExecutionMode="Row" ActualElapsedms="14" ActualCPUms="13" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="1160" OutputMemoryGrant="1056" UsedMemoryGrant="320" />
<RunTimeCountersPerThread Thread="7" ActualRows="552" Batches="0" ActualExecutionMode="Row" ActualElapsedms="17" ActualCPUms="16" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="1160" OutputMemoryGrant="1056" UsedMemoryGrant="320" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="0" ActualExecutions="0" InputMemoryGrant="1160" OutputMemoryGrant="1056" UsedMemoryGrant="0" />
</RunTimeInformation>
<Hash>
<DefinedValues />
<HashKeysBuild>
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="StreamID" />
</HashKeysBuild>
<HashKeysProbe>
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="StreamID" />
</HashKeysProbe>
<ProbeResidual>
<ScalarOperator ScalarString="[sfbks].[dbo].[StreamLock].[StreamID] as [sl].[StreamID]=#CurrentItemsWithPerms.[StreamID] as [t].[StreamID]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="StreamID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="StreamID" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</ProbeResidual>
<RelOp NodeId="5" PhysicalOp="Parallelism" LogicalOp="Distribute Streams" EstimateRows="44" EstimateIO="0" EstimateCPU="0.0290348" AvgRowSize="132" EstimatedTotalSubtreeCost="0.0338467" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="LockID" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="StreamID" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="LockOwnerID" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="StreamLockTypeID" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="ExpirationDate" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="7" ActualRows="44" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="8" ActualRows="44" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="5" ActualRows="44" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="6" ActualRows="44" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="44" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="44" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="44" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="44" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Parallelism PartitioningType="Broadcast">
<RelOp NodeId="6" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="44" EstimateIO="0.00460648" EstimateCPU="0.0002054" AvgRowSize="132" EstimatedTotalSubtreeCost="0.00481188" TableCardinality="44" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="LockID" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="StreamID" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="LockOwnerID" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="StreamLockTypeID" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="ExpirationDate" />
</OutputList>
<Warnings>
<ColumnsWithNoStatistics>
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="StreamID" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="LockOwnerID" />
</ColumnsWithNoStatistics>
</Warnings>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="1" ActualRows="44" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="5" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="44" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<IndexScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="LockID" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="StreamID" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="LockOwnerID" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="StreamLockTypeID" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="ExpirationDate" />
</DefinedValue>
</DefinedValues>
<Object Database="[sfbks]" Schema="[dbo]" Table="[StreamLock]" Index="[PK_StreamLock]" Alias="[sl]" IndexKind="Clustered" Storage="RowStore" />
</IndexScan>
</RelOp>
</Parallelism>
</RelOp>
<RelOp NodeId="7" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="5227.81" EstimateIO="0" EstimateCPU="0.00273164" AvgRowSize="1508" EstimatedTotalSubtreeCost="31.448" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="StreamID" />
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="ItemID" />
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="CanDelete" />
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="CanDownload" />
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="CanUpload" />
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="CanView" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="Name" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="Type" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="CreationDate" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="ExpirationDate" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="CreatorID" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="FileName" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="FilePath" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="FileSizeBytes" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="Hash" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="FileCount" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="ProgenyEditDate" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="ClientModifiedDate" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="ClientCreatedDate" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Users]" Alias="[uc]" Column="FirstName" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Users]" Alias="[uc]" Column="LastName" />
</OutputList>
<MemoryFractions Input="0" Output="0.227712" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="2" ActualRows="736" Batches="0" ActualExecutionMode="Row" ActualElapsedms="14" ActualCPUms="14" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="0" OutputMemoryGrant="1336" UsedMemoryGrant="512" />
<RunTimeCountersPerThread Thread="5" ActualRows="736" Batches="0" ActualExecutionMode="Row" ActualElapsedms="16" ActualCPUms="16" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="0" OutputMemoryGrant="1336" UsedMemoryGrant="512" />
<RunTimeCountersPerThread Thread="8" ActualRows="736" Batches="0" ActualExecutionMode="Row" ActualElapsedms="15" ActualCPUms="14" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="0" OutputMemoryGrant="1336" UsedMemoryGrant="520" />
<RunTimeCountersPerThread Thread="1" ActualRows="627" Batches="0" ActualExecutionMode="Row" ActualElapsedms="18" ActualCPUms="18" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="0" OutputMemoryGrant="1336" UsedMemoryGrant="456" />
<RunTimeCountersPerThread Thread="4" ActualRows="736" Batches="0" ActualExecutionMode="Row" ActualElapsedms="16" ActualCPUms="16" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="0" OutputMemoryGrant="1336" UsedMemoryGrant="512" />
<RunTimeCountersPerThread Thread="7" ActualRows="552" Batches="0" ActualExecutionMode="Row" ActualElapsedms="16" ActualCPUms="16" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="0" OutputMemoryGrant="1336" UsedMemoryGrant="400" />
<RunTimeCountersPerThread Thread="6" ActualRows="552" Batches="0" ActualExecutionMode="Row" ActualElapsedms="13" ActualCPUms="12" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="0" OutputMemoryGrant="1336" UsedMemoryGrant="400" />
<RunTimeCountersPerThread Thread="3" ActualRows="554" Batches="0" ActualExecutionMode="Row" ActualElapsedms="15" ActualCPUms="15" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="0" OutputMemoryGrant="1336" UsedMemoryGrant="400" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="0" ActualExecutions="0" InputMemoryGrant="0" OutputMemoryGrant="1336" UsedMemoryGrant="0" />
</RunTimeInformation>
<NestedLoops Optimized="1" WithUnorderedPrefetch="1">
<OuterReferences>
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="CreatorID" />
<ColumnReference Column="Expr1013" />
</OuterReferences>
<RelOp NodeId="10" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="5228.03" EstimateIO="0" EstimateCPU="0.00273215" AvgRowSize="992" EstimatedTotalSubtreeCost="17.0887" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="StreamID" />
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="ItemID" />
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="CanDelete" />
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="CanDownload" />
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="CanUpload" />
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="CanView" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="Name" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="Type" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="CreationDate" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="ExpirationDate" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="CreatorID" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="FileName" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="FilePath" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="FileSizeBytes" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="Hash" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="FileCount" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="ProgenyEditDate" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="ClientModifiedDate" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="ClientCreatedDate" />
</OutputList>
<MemoryFractions Input="0" Output="0.0447143" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="8" ActualRows="736" Batches="0" ActualExecutionMode="Row" ActualElapsedms="5" ActualCPUms="4" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="0" OutputMemoryGrant="672" UsedMemoryGrant="96" />
<RunTimeCountersPerThread Thread="5" ActualRows="736" Batches="0" ActualExecutionMode="Row" ActualElapsedms="6" ActualCPUms="6" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="0" OutputMemoryGrant="672" UsedMemoryGrant="96" />
<RunTimeCountersPerThread Thread="7" ActualRows="552" Batches="0" ActualExecutionMode="Row" ActualElapsedms="5" ActualCPUms="5" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="0" OutputMemoryGrant="672" UsedMemoryGrant="72" />
<RunTimeCountersPerThread Thread="6" ActualRows="552" Batches="0" ActualExecutionMode="Row" ActualElapsedms="6" ActualCPUms="5" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="0" OutputMemoryGrant="672" UsedMemoryGrant="72" />
<RunTimeCountersPerThread Thread="2" ActualRows="736" Batches="0" ActualExecutionMode="Row" ActualElapsedms="4" ActualCPUms="4" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="0" OutputMemoryGrant="672" UsedMemoryGrant="96" />
<RunTimeCountersPerThread Thread="4" ActualRows="736" Batches="0" ActualExecutionMode="Row" ActualElapsedms="7" ActualCPUms="7" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="0" OutputMemoryGrant="672" UsedMemoryGrant="96" />
<RunTimeCountersPerThread Thread="3" ActualRows="554" Batches="0" ActualExecutionMode="Row" ActualElapsedms="9" ActualCPUms="9" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="0" OutputMemoryGrant="672" UsedMemoryGrant="72" />
<RunTimeCountersPerThread Thread="1" ActualRows="627" Batches="0" ActualExecutionMode="Row" ActualElapsedms="9" ActualCPUms="9" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="0" OutputMemoryGrant="672" UsedMemoryGrant="88" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="0" ActualExecutions="0" InputMemoryGrant="0" OutputMemoryGrant="672" UsedMemoryGrant="0" />
</RunTimeInformation>
<NestedLoops Optimized="1" WithUnorderedPrefetch="1">
<OuterReferences>
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="ItemID" />
<ColumnReference Column="Expr1012" />
</OuterReferences>
<RelOp NodeId="13" PhysicalOp="Table Scan" LogicalOp="Table Scan" EstimateRows="5229" EstimateIO="0.0454257" EstimateCPU="0.000728937" AvgRowSize="86" EstimatedTotalSubtreeCost="0.0461547" TableCardinality="5230" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="StreamID" />
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="ItemID" />
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="CanDelete" />
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="CanDownload" />
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="CanUpload" />
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="CanView" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="7" ActualRows="552" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="6" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="552" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="5" ActualRows="736" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="8" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="736" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="8" ActualRows="736" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="8" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="736" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="6" ActualRows="552" Batches="0" ActualExecutionMode="Row" ActualElapsedms="1" ActualCPUms="0" ActualScans="1" ActualLogicalReads="6" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="552" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="736" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="8" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="736" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="554" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="7" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="555" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="736" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="8" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="736" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="627" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="7" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="627" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<TableScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="StreamID" />
</DefinedValue>
<DefinedValue>
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="ItemID" />
</DefinedValue>
<DefinedValue>
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="CanDelete" />
</DefinedValue>
<DefinedValue>
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="CanDownload" />
</DefinedValue>
<DefinedValue>
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="CanUpload" />
</DefinedValue>
<DefinedValue>
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="CanView" />
</DefinedValue>
</DefinedValues>
<Object Database="[tempdb]" Schema="[dbo]" Table="[#CurrentItemsWithPerms]" Alias="[t]" Storage="RowStore" />
<Predicate>
<ScalarOperator ScalarString="#CurrentItemsWithPerms.[PermissionsFound] as [t].[PermissionsFound]=(1) AND #CurrentItemsWithPerms.[ItemID] as [t].[ItemID]&lt;&gt;[@ParentID]">
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="PermissionsFound" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(1)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="NE">
<ScalarOperator>
<Identifier>
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="ItemID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Column="@ParentID" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Predicate>
</TableScan>
</RelOp>
<RelOp NodeId="14" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="914" EstimatedTotalSubtreeCost="17.0392" TableCardinality="8.57023e+008" Parallel="1" EstimateRebinds="5228" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="Name" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="Type" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="CreationDate" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="ExpirationDate" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="CreatorID" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="FileName" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="FilePath" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="FileSizeBytes" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="Hash" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="FileCount" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="ProgenyEditDate" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="ClientModifiedDate" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="ClientCreatedDate" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="8" ActualRows="736" Batches="0" ActualExecutionMode="Row" ActualElapsedms="4" ActualCPUms="4" ActualScans="0" ActualLogicalReads="3460" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="736" ActualEndOfScans="0" ActualExecutions="736" />
<RunTimeCountersPerThread Thread="5" ActualRows="736" Batches="0" ActualExecutionMode="Row" ActualElapsedms="5" ActualCPUms="5" ActualScans="0" ActualLogicalReads="3460" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="736" ActualEndOfScans="0" ActualExecutions="736" />
<RunTimeCountersPerThread Thread="7" ActualRows="552" Batches="0" ActualExecutionMode="Row" ActualElapsedms="3" ActualCPUms="3" ActualScans="0" ActualLogicalReads="2588" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="552" ActualEndOfScans="0" ActualExecutions="552" />
<RunTimeCountersPerThread Thread="6" ActualRows="552" Batches="0" ActualExecutionMode="Row" ActualElapsedms="4" ActualCPUms="4" ActualScans="0" ActualLogicalReads="2588" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="552" ActualEndOfScans="0" ActualExecutions="552" />
<RunTimeCountersPerThread Thread="2" ActualRows="736" Batches="0" ActualExecutionMode="Row" ActualElapsedms="3" ActualCPUms="3" ActualScans="0" ActualLogicalReads="3460" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="736" ActualEndOfScans="0" ActualExecutions="736" />
<RunTimeCountersPerThread Thread="4" ActualRows="736" Batches="0" ActualExecutionMode="Row" ActualElapsedms="6" ActualCPUms="6" ActualScans="0" ActualLogicalReads="3460" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="736" ActualEndOfScans="0" ActualExecutions="736" />
<RunTimeCountersPerThread Thread="3" ActualRows="554" Batches="0" ActualExecutionMode="Row" ActualElapsedms="8" ActualCPUms="8" ActualScans="0" ActualLogicalReads="2598" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="554" ActualEndOfScans="0" ActualExecutions="554" />
<RunTimeCountersPerThread Thread="1" ActualRows="627" Batches="0" ActualExecutionMode="Row" ActualElapsedms="7" ActualCPUms="7" ActualScans="0" ActualLogicalReads="2943" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="627" ActualEndOfScans="0" ActualExecutions="627" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="Name" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="Type" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="CreationDate" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="ExpirationDate" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="CreatorID" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="FileName" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="FilePath" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="FileSizeBytes" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="Hash" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="FileCount" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="ProgenyEditDate" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="ClientModifiedDate" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="ClientCreatedDate" />
</DefinedValue>
</DefinedValues>
<Object Database="[sfbks]" Schema="[dbo]" Table="[Items]" Index="[PK_Items]" Alias="[i]" IndexKind="Clustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="ID" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="#CurrentItemsWithPerms.[ItemID] as [t].[ItemID]">
<Identifier>
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="ItemID" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp NodeId="15" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="525" EstimatedTotalSubtreeCost="14.3566" TableCardinality="3.93399e+006" Parallel="1" EstimateRebinds="5224.89" EstimateRewinds="2.13338" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Users]" Alias="[uc]" Column="FirstName" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Users]" Alias="[uc]" Column="LastName" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="2" ActualRows="736" Batches="0" ActualExecutionMode="Row" ActualElapsedms="4" ActualCPUms="4" ActualScans="736" ActualLogicalReads="2944" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="736" ActualEndOfScans="0" ActualExecutions="736" />
<RunTimeCountersPerThread Thread="5" ActualRows="736" Batches="0" ActualExecutionMode="Row" ActualElapsedms="6" ActualCPUms="6" ActualScans="736" ActualLogicalReads="2944" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="736" ActualEndOfScans="0" ActualExecutions="736" />
<RunTimeCountersPerThread Thread="8" ActualRows="736" Batches="0" ActualExecutionMode="Row" ActualElapsedms="3" ActualCPUms="3" ActualScans="736" ActualLogicalReads="2944" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="736" ActualEndOfScans="0" ActualExecutions="736" />
<RunTimeCountersPerThread Thread="1" ActualRows="627" Batches="0" ActualExecutionMode="Row" ActualElapsedms="6" ActualCPUms="6" ActualScans="627" ActualLogicalReads="2508" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="627" ActualEndOfScans="0" ActualExecutions="627" />
<RunTimeCountersPerThread Thread="4" ActualRows="736" Batches="0" ActualExecutionMode="Row" ActualElapsedms="5" ActualCPUms="5" ActualScans="736" ActualLogicalReads="2944" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="736" ActualEndOfScans="0" ActualExecutions="736" />
<RunTimeCountersPerThread Thread="7" ActualRows="552" Batches="0" ActualExecutionMode="Row" ActualElapsedms="4" ActualCPUms="4" ActualScans="552" ActualLogicalReads="2208" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="552" ActualEndOfScans="0" ActualExecutions="552" />
<RunTimeCountersPerThread Thread="6" ActualRows="552" Batches="0" ActualExecutionMode="Row" ActualElapsedms="3" ActualCPUms="3" ActualScans="552" ActualLogicalReads="2208" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="552" ActualEndOfScans="0" ActualExecutions="552" />
<RunTimeCountersPerThread Thread="3" ActualRows="554" Batches="0" ActualExecutionMode="Row" ActualElapsedms="5" ActualCPUms="5" ActualScans="554" ActualLogicalReads="2216" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="554" ActualEndOfScans="0" ActualExecutions="554" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Users]" Alias="[uc]" Column="FirstName" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Users]" Alias="[uc]" Column="LastName" />
</DefinedValue>
</DefinedValues>
<Object Database="[sfbks]" Schema="[dbo]" Table="[Users]" Index="[IX_Users_ID_AccountID]" Alias="[uc]" IndexKind="NonClustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Users]" Alias="[uc]" Column="ID" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[sfbks].[dbo].[Items].[CreatorID] as [i].[CreatorID]">
<Identifier>
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="CreatorID" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
</Hash>
</RelOp>
</Parallelism>
</RelOp>
</Sort>
</RelOp>
<RelOp NodeId="17" PhysicalOp="Table Spool" LogicalOp="Lazy Spool" EstimateRows="1.00105" EstimateIO="0.01" EstimateCPU="0.00010048" AvgRowSize="591" EstimatedTotalSubtreeCost="1.10827" Parallel="1" EstimateRebinds="4" EstimateRewinds="10406.6" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Users]" Alias="[ul]" Column="FirstName" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Users]" Alias="[ul]" Column="LastName" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[EmailAddresses]" Alias="[ea]" Column="Email" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="8" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="0" ActualRewinds="0" ActualEndOfScans="0" ActualExecutions="0" />
<RunTimeCountersPerThread Thread="6" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="5228" ActualEndOfScans="5229" ActualExecutions="5229" />
<RunTimeCountersPerThread Thread="7" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="0" ActualRewinds="0" ActualEndOfScans="0" ActualExecutions="0" />
<RunTimeCountersPerThread Thread="5" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="0" ActualRewinds="0" ActualEndOfScans="0" ActualExecutions="0" />
<RunTimeCountersPerThread Thread="4" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="0" ActualRewinds="0" ActualEndOfScans="0" ActualExecutions="0" />
<RunTimeCountersPerThread Thread="2" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="0" ActualRewinds="0" ActualEndOfScans="0" ActualExecutions="0" />
<RunTimeCountersPerThread Thread="3" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="0" ActualRewinds="0" ActualEndOfScans="0" ActualExecutions="0" />
<RunTimeCountersPerThread Thread="1" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="0" ActualRewinds="0" ActualEndOfScans="0" ActualExecutions="0" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="0" ActualRewinds="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Spool>
<RelOp NodeId="18" PhysicalOp="Nested Loops" LogicalOp="Left Outer Join" EstimateRows="1.00105" EstimateIO="0" EstimateCPU="4.18e-006" AvgRowSize="591" EstimatedTotalSubtreeCost="0.0152341" Parallel="1" EstimateRebinds="4" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Users]" Alias="[ul]" Column="FirstName" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Users]" Alias="[ul]" Column="LastName" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[EmailAddresses]" Alias="[ea]" Column="Email" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="8" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="0" ActualExecutions="0" />
<RunTimeCountersPerThread Thread="6" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="7" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="0" ActualExecutions="0" />
<RunTimeCountersPerThread Thread="5" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="0" ActualExecutions="0" />
<RunTimeCountersPerThread Thread="4" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="0" ActualExecutions="0" />
<RunTimeCountersPerThread Thread="2" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="0" ActualExecutions="0" />
<RunTimeCountersPerThread Thread="3" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="0" ActualExecutions="0" />
<RunTimeCountersPerThread Thread="1" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="0" ActualExecutions="0" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<NestedLoops Optimized="0">
<OuterReferences>
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Users]" Alias="[ul]" Column="ID" />
</OuterReferences>
<RelOp NodeId="19" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="559" EstimatedTotalSubtreeCost="0.0039155" TableCardinality="3.93399e+006" Parallel="1" EstimateRebinds="4" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Users]" Alias="[ul]" Column="ID" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Users]" Alias="[ul]" Column="FirstName" />
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Users]" Alias="[ul]" Column="LastName" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="8" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="0" ActualExecutions="0" />
<RunTimeCountersPerThread Thread="6" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="7" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="0" ActualExecutions="0" />
<RunTimeCountersPerThread Thread="5" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="0" ActualExecutions="0" />
<RunTimeCountersPerThread Thread="4" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="0" ActualExecutions="0" />
<RunTimeCountersPerThread Thread="3" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="0" ActualExecutions="0" />
<RunTimeCountersPerThread Thread="2" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="0" ActualExecutions="0" />
<RunTimeCountersPerThread Thread="1" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="0" ActualExecutions="0" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Users]" Alias="[ul]" Column="ID" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Users]" Alias="[ul]" Column="FirstName" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Users]" Alias="[ul]" Column="LastName" />
</DefinedValue>
</DefinedValues>
<Object Database="[sfbks]" Schema="[dbo]" Table="[Users]" Index="[IX_Users_ID_AccountID]" Alias="[ul]" IndexKind="NonClustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Users]" Alias="[ul]" Column="ID" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[sfbks].[dbo].[StreamLock].[LockOwnerID] as [sl].[LockOwnerID]">
<Identifier>
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="LockOwnerID" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
<RelOp NodeId="20" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.000158101" AvgRowSize="76" EstimatedTotalSubtreeCost="0.0112953" TableCardinality="3.93684e+006" Parallel="1" EstimateRebinds="4" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[EmailAddresses]" Alias="[ea]" Column="Email" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="8" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="0" ActualExecutions="0" />
<RunTimeCountersPerThread Thread="6" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="0" ActualExecutions="0" />
<RunTimeCountersPerThread Thread="7" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="0" ActualExecutions="0" />
<RunTimeCountersPerThread Thread="5" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="0" ActualExecutions="0" />
<RunTimeCountersPerThread Thread="4" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="0" ActualExecutions="0" />
<RunTimeCountersPerThread Thread="2" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="0" ActualExecutions="0" />
<RunTimeCountersPerThread Thread="3" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="0" ActualExecutions="0" />
<RunTimeCountersPerThread Thread="1" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="0" ActualExecutions="0" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[EmailAddresses]" Alias="[ea]" Column="Email" />
</DefinedValue>
</DefinedValues>
<Object Database="[sfbks]" Schema="[dbo]" Table="[EmailAddresses]" Index="[IX_EmailAddresses_UserID_Email_IsPrimary]" Alias="[ea]" IndexKind="NonClustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[EmailAddresses]" Alias="[ea]" Column="UserID" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[sfbks].[dbo].[Users].[ID] as [ul].[ID]">
<Identifier>
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Users]" Alias="[ul]" Column="ID" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
<Predicate>
<ScalarOperator ScalarString="[sfbks].[dbo].[EmailAddresses].[IsPrimary] as [ea].[IsPrimary]=(1)">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[EmailAddresses]" Alias="[ea]" Column="IsPrimary" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(1)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
</Spool>
</RelOp>
</NestedLoops>
</RelOp>
</Parallelism>
</RelOp>
<ParameterList>
<ColumnReference Column="@ParentID" ParameterCompiledValue="'fo453f9d-5d73-4cb8-94e5-1aa7a210e600'" ParameterRuntimeValue="'fo453f9d-5d73-4cb8-94e5-1aa7a210e600'" />
</ParameterList>
</QueryPlan>
</StmtSimple>
</Statements>
</Batch>
</BatchSequence>
</ShowPlanXML>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment