Created
February 12, 2020 20:51
-
-
Save gilbonbaggins/08bef4d75ea0730532fe9e5dc95b67b4 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?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 
 t.CanDelete 
 , t.CanDownload 
 , t.CanUpload 
 , t.CanView 
 , i.ClientCreatedDate 
 , i.ClientModifiedDate 
 , i.CreationDate 
 , uc.FirstName AS CreatorFirstName 
 , i.CreatorID 
 , uc.LastName AS CreatorLastName 
 , i.ExpirationDate 
 , i.FileCount 
 , i.FileName 
 , i.FilePath 
 , i.FileSizeBytes 
 , i.Hash 
 , t.ItemID AS ID 
 , sl.ExpirationDate AS LockExpirationDate 
 , sl.LockID 
 , ea.Email AS LockOwnerEmailAddress 
 , ul.FirstName AS LockOwnerFirstName 
 , sl.LockOwnerID 
 , ul.LastName AS LockOwnerLastName 
 , sl.StreamLockTypeID AS LockTypeID 
 , i.Name 
 , i.ProgenyEditDate 
 , t.StreamID 
 , i.[Type] 
 FROM #CurrentItemsWithPerms t 
 INNER JOIN dbo.Items i 
 ON i.ID = t.ItemID 
 INNER JOIN dbo.Users uc 
 ON uc.ID = i.CreatorID 
 LEFT OUTER JOIN dbo.StreamLock sl 
 ON sl.StreamID = t.StreamID 
 LEFT OUTER JOIN dbo.Users ul 
 ON ul.ID = sl.LockOwnerID 
 LEFT OUTER JOIN dbo.EmailAddresses ea 
 ON ea.UserID = ul.ID 
 AND ea.IsPrimary = 1 
 WHERE 
 t.ItemID <> @ParentID -- Exclude the Parent from the results (it was only needed for permissions) 
 AND t.PermissionsFound = 1 OPTION (QUERYTRACEON 9481)" StatementId="9" StatementCompId="36" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="19.3194" StatementEstRows="5229" StatementOptmLevel="FULL" QueryHash="0xEE94020C0A99C71F" QueryPlanHash="0x3CFB9327C19436C8" CardinalityEstimationModelVersion="70"> | |
<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="1" MemoryGrant="10520" CachedPlanSize="160" CompileTime="49" CompileCPU="49" CompileMemory="1872"> | |
<MemoryGrantInfo SerialRequiredMemory="2048" SerialDesiredMemory="10520" RequiredMemory="2048" DesiredMemory="10520" RequestedMemory="10520" GrantWaitTime="0" GrantedMemory="10520" MaxUsedMemory="5008" MaxQueryMemory="22649896" /> | |
<OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="759558" EstimatedPagesCached="759558" EstimatedAvailableDegreeOfParallelism="8" MaxCompileMemory="87706568" /> | |
<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="9481" Scope="Session" /> | |
</TraceFlags> | |
<TraceFlags IsCompileTime="0"> | |
<TraceFlag Value="1117" Scope="Global" /> | |
<TraceFlag Value="1118" Scope="Global" /> | |
<TraceFlag Value="1800" Scope="Global" /> | |
<TraceFlag Value="2371" Scope="Global" /> | |
</TraceFlags> | |
<QueryTimeStats ElapsedTime="123" CpuTime="123" /> | |
<RelOp NodeId="0" PhysicalOp="Hash Match" LogicalOp="Right Outer Join" EstimateRows="5229" EstimateIO="0" EstimateCPU="0.0799126" AvgRowSize="2143" EstimatedTotalSubtreeCost="19.3194" Parallel="0" 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> | |
<MemoryFractions Input="0.0679887" Output="0.0679887" /> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="5229" ActualElapsedms="99" ActualCPUms="99" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="1600" OutputMemoryGrant="1600" UsedMemoryGrant="640" /> | |
</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="1" PhysicalOp="Nested Loops" LogicalOp="Left Outer Join" EstimateRows="47.0541" EstimateIO="0" EstimateCPU="0.00018392" AvgRowSize="681" EstimatedTotalSubtreeCost="0.0253636" 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" /> | |
<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="44" ActualElapsedms="2" ActualCPUms="2" ActualEndOfScans="1" ActualExecutions="1" /> | |
</RunTimeInformation> | |
<NestedLoops Optimized="0" WithUnorderedPrefetch="1"> | |
<OuterReferences> | |
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Users]" Alias="[ul]" Column="ID" /> | |
<ColumnReference Column="Expr1013" /> | |
</OuterReferences> | |
<RelOp NodeId="3" PhysicalOp="Nested Loops" LogicalOp="Left Outer Join" EstimateRows="44" EstimateIO="0" EstimateCPU="0.00018392" AvgRowSize="686" EstimatedTotalSubtreeCost="0.0150772" 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" /> | |
<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> | |
<MemoryFractions Input="0" Output="0.932011" /> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="44" ActualElapsedms="1" ActualCPUms="1" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="0" OutputMemoryGrant="8408" UsedMemoryGrant="0" /> | |
</RunTimeInformation> | |
<NestedLoops Optimized="1" WithUnorderedPrefetch="1"> | |
<OuterReferences> | |
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="LockOwnerID" /> | |
<ColumnReference Column="Expr1012" /> | |
</OuterReferences> | |
<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> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="44" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="5" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="44" ActualEndOfScans="1" ActualExecutions="1" /> | |
</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> | |
<RelOp NodeId="7" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="563" EstimatedTotalSubtreeCost="0.0100814" TableCardinality="3.93399e+006" Parallel="0" EstimateRebinds="27.5" EstimateRewinds="15.5" 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="0" ActualRows="44" ActualElapsedms="1" ActualCPUms="1" ActualScans="44" ActualLogicalReads="178" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="44" ActualEndOfScans="0" ActualExecutions="44" /> | |
</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> | |
</NestedLoops> | |
</RelOp> | |
<RelOp NodeId="8" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="43" EstimatedTotalSubtreeCost="0.0100814" TableCardinality="3.93684e+006" Parallel="0" EstimateRebinds="27.5" EstimateRewinds="15.5" EstimatedExecutionMode="Row"> | |
<OutputList> | |
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[EmailAddresses]" Alias="[ea]" Column="Email" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="44" ActualElapsedms="1" ActualCPUms="1" ActualScans="44" ActualLogicalReads="220" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="44" ActualEndOfScans="44" ActualExecutions="44" /> | |
</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> | |
<RelOp NodeId="9" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="5229" EstimateIO="0" EstimateCPU="0.0218572" AvgRowSize="1508" EstimatedTotalSubtreeCost="19.2141" Parallel="0" 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.779037" /> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="5229" ActualElapsedms="95" ActualCPUms="95" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="0" OutputMemoryGrant="7112" UsedMemoryGrant="3712" /> | |
</RunTimeInformation> | |
<NestedLoops Optimized="1" WithUnorderedPrefetch="1"> | |
<OuterReferences> | |
<ColumnReference Database="[sfbks]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="CreatorID" /> | |
<ColumnReference Column="Expr1015" /> | |
</OuterReferences> | |
<RelOp NodeId="12" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="5229" EstimateIO="0" EstimateCPU="0.0218572" AvgRowSize="992" EstimatedTotalSubtreeCost="17.2415" Parallel="0" 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.152975" /> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="5229" ActualElapsedms="49" ActualCPUms="49" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="0" OutputMemoryGrant="1800" UsedMemoryGrant="656" /> | |
</RunTimeInformation> | |
<NestedLoops Optimized="1" WithUnorderedPrefetch="1"> | |
<OuterReferences> | |
<ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="ItemID" /> | |
<ColumnReference Column="Expr1014" /> | |
</OuterReferences> | |
<RelOp NodeId="15" PhysicalOp="Table Scan" LogicalOp="Table Scan" EstimateRows="5229" EstimateIO="0.0453472" EstimateCPU="0.00591" AvgRowSize="86" EstimatedTotalSubtreeCost="0.0512572" TableCardinality="5230" Parallel="0" 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="0" ActualRows="5229" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="58" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="5230" ActualEndOfScans="1" ActualExecutions="1" /> | |
</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]<>[@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="16" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="914" EstimatedTotalSubtreeCost="17.1638" TableCardinality="8.57023e+008" Parallel="0" 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="0" ActualRows="5229" ActualElapsedms="40" ActualCPUms="40" ActualScans="0" ActualLogicalReads="24805" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="5229" ActualEndOfScans="0" ActualExecutions="5229" /> | |
</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="17" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="525" EstimatedTotalSubtreeCost="1.95072" TableCardinality="3.93399e+006" Parallel="0" EstimateRebinds="3576.47" EstimateRewinds="1651.53" 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="0" ActualRows="5229" ActualElapsedms="26" ActualCPUms="26" ActualScans="5229" ActualLogicalReads="20916" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="5229" ActualEndOfScans="0" ActualExecutions="5229" /> | |
</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> | |
<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