Created
February 13, 2020 15:09
-
-
Save gilbonbaggins/6fff5249e0d45b14f59c09ebe9adc290 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 WITH (NOLOCK)
			ON i.ID = t.ItemID
		INNER JOIN dbo.Users uc WITH (NOLOCK)
			ON uc.ID = i.CreatorID
		LEFT OUTER JOIN dbo.StreamLock sl WITH (NOLOCK)
			ON sl.StreamID = t.StreamID
		LEFT OUTER JOIN dbo.Users ul WITH (NOLOCK)
			ON ul.ID = sl.LockOwnerID
		LEFT OUTER JOIN dbo.EmailAddresses ea WITH (NOLOCK)
			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" StatementId="9" StatementCompId="35" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="32.0287" StatementEstRows="5228.91" StatementOptmLevel="FULL" QueryHash="0x1113A39568F061C" QueryPlanHash="0x2DDE0C9F29A69775" 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="1" MemoryGrant="3552" CachedPlanSize="136" CompileTime="43" CompileCPU="43" CompileMemory="1312"> | |
| <MemoryGrantInfo SerialRequiredMemory="1536" SerialDesiredMemory="3552" RequiredMemory="1536" DesiredMemory="3552" RequestedMemory="3552" GrantWaitTime="0" GrantedMemory="3552" MaxUsedMemory="1296" MaxQueryMemory="43601904" /> | |
| <OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="759561" EstimatedPagesCached="1519123" EstimatedAvailableDegreeOfParallelism="8" MaxCompileMemory="163826456" /> | |
| <TraceFlags IsCompileTime="1"> | |
| <TraceFlag Value="1117" Scope="Global" /> | |
| <TraceFlag Value="1118" Scope="Global" /> | |
| <TraceFlag Value="1800" Scope="Global" /> | |
| <TraceFlag Value="2371" 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" /> | |
| </TraceFlags> | |
| <QueryTimeStats ElapsedTime="623" CpuTime="118" /> | |
| <RelOp NodeId="0" PhysicalOp="Hash Match" LogicalOp="Right Outer Join" EstimateRows="5228.91" EstimateIO="0" EstimateCPU="0.0889354" AvgRowSize="2176" EstimatedTotalSubtreeCost="32.0287" 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="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="Name" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="Type" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="CreationDate" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="ExpirationDate" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="CreatorID" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="FileName" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="FilePath" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="FileSizeBytes" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="Hash" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="FileCount" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="ProgenyEditDate" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="ClientModifiedDate" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="ClientCreatedDate" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Users]" Alias="[uc]" Column="FirstName" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Users]" Alias="[uc]" Column="LastName" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="LockID" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="LockOwnerID" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="StreamLockTypeID" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="ExpirationDate" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Users]" Alias="[ul]" Column="FirstName" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Users]" Alias="[ul]" Column="LastName" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[EmailAddresses]" Alias="[ea]" Column="Email" /> | |
| </OutputList> | |
| <MemoryFractions Input="0.357143" Output="0.357143" /> | |
| <RunTimeInformation> | |
| <RunTimeCountersPerThread Thread="0" ActualRows="5229" ActualElapsedms="94" ActualCPUms="94" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="1744" OutputMemoryGrant="1744" UsedMemoryGrant="640" /> | |
| </RunTimeInformation> | |
| <Hash> | |
| <DefinedValues /> | |
| <HashKeysBuild> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="StreamID" /> | |
| </HashKeysBuild> | |
| <HashKeysProbe> | |
| <ColumnReference Table="#CurrentItemsWithPerms" Alias="[t]" Column="StreamID" /> | |
| </HashKeysProbe> | |
| <ProbeResidual> | |
| <ScalarOperator ScalarString="[redacted].[dbo].[StreamLock].[StreamID] as [sl].[StreamID]=#CurrentItemsWithPerms.[StreamID] as [t].[StreamID]"> | |
| <Compare CompareOp="EQ"> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[redacted]" 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="66.1391" EstimateIO="0" EstimateCPU="0.000276461" AvgRowSize="714" EstimatedTotalSubtreeCost="0.411508" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"> | |
| <OutputList> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="LockID" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="StreamID" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="LockOwnerID" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="StreamLockTypeID" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="ExpirationDate" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Users]" Alias="[ul]" Column="FirstName" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Users]" Alias="[ul]" Column="LastName" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[EmailAddresses]" Alias="[ea]" Column="Email" /> | |
| </OutputList> | |
| <RunTimeInformation> | |
| <RunTimeCountersPerThread Thread="0" ActualRows="66" ActualElapsedms="1" ActualCPUms="1" ActualEndOfScans="1" ActualExecutions="1" /> | |
| </RunTimeInformation> | |
| <NestedLoops Optimized="0"> | |
| <OuterReferences> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="LockOwnerID" /> | |
| </OuterReferences> | |
| <RelOp NodeId="2" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="66" EstimateIO="0.0149769" EstimateCPU="0.0002296" AvgRowSize="128" EstimatedTotalSubtreeCost="0.0152065" TableCardinality="66" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"> | |
| <OutputList> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="LockID" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="StreamID" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="LockOwnerID" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="StreamLockTypeID" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="ExpirationDate" /> | |
| </OutputList> | |
| <RunTimeInformation> | |
| <RunTimeCountersPerThread Thread="0" ActualRows="66" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="19" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="66" ActualEndOfScans="1" ActualExecutions="1" /> | |
| </RunTimeInformation> | |
| <IndexScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"> | |
| <DefinedValues> | |
| <DefinedValue> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="LockID" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="StreamID" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="LockOwnerID" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="StreamLockTypeID" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="ExpirationDate" /> | |
| </DefinedValue> | |
| </DefinedValues> | |
| <Object Database="[redacted]" Schema="[dbo]" Table="[StreamLock]" Index="[PK_StreamLock]" Alias="[sl]" IndexKind="Clustered" Storage="RowStore" /> | |
| </IndexScan> | |
| </RelOp> | |
| <RelOp NodeId="3" PhysicalOp="Nested Loops" LogicalOp="Left Outer Join" EstimateRows="1.00211" EstimateIO="0" EstimateCPU="4.18e-006" AvgRowSize="591" EstimatedTotalSubtreeCost="0.396025" Parallel="0" EstimateRebinds="64.7972" EstimateRewinds="0.20284" EstimatedExecutionMode="Row"> | |
| <OutputList> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Users]" Alias="[ul]" Column="FirstName" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Users]" Alias="[ul]" Column="LastName" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[EmailAddresses]" Alias="[ea]" Column="Email" /> | |
| </OutputList> | |
| <RunTimeInformation> | |
| <RunTimeCountersPerThread Thread="0" ActualRows="66" ActualElapsedms="1" ActualCPUms="1" ActualEndOfScans="66" ActualExecutions="66" /> | |
| </RunTimeInformation> | |
| <NestedLoops Optimized="0"> | |
| <OuterReferences> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Users]" Alias="[ul]" Column="ID" /> | |
| </OuterReferences> | |
| <RelOp NodeId="4" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="559" EstimatedTotalSubtreeCost="0.197859" TableCardinality="3.94039e+006" Parallel="0" EstimateRebinds="64.7972" EstimateRewinds="0.20284" EstimatedExecutionMode="Row"> | |
| <OutputList> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Users]" Alias="[ul]" Column="ID" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Users]" Alias="[ul]" Column="FirstName" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Users]" Alias="[ul]" Column="LastName" /> | |
| </OutputList> | |
| <RunTimeInformation> | |
| <RunTimeCountersPerThread Thread="0" ActualRows="66" ActualElapsedms="0" ActualCPUms="0" ActualScans="66" ActualLogicalReads="265" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="66" ActualEndOfScans="66" ActualExecutions="66" /> | |
| </RunTimeInformation> | |
| <IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"> | |
| <DefinedValues> | |
| <DefinedValue> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Users]" Alias="[ul]" Column="ID" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Users]" Alias="[ul]" Column="FirstName" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Users]" Alias="[ul]" Column="LastName" /> | |
| </DefinedValue> | |
| </DefinedValues> | |
| <Object Database="[redacted]" Schema="[dbo]" Table="[Users]" Index="[IX_Users_ID_AccountID]" Alias="[ul]" IndexKind="NonClustered" Storage="RowStore" /> | |
| <SeekPredicates> | |
| <SeekPredicateNew> | |
| <SeekKeys> | |
| <Prefix ScanType="EQ"> | |
| <RangeColumns> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Users]" Alias="[ul]" Column="ID" /> | |
| </RangeColumns> | |
| <RangeExpressions> | |
| <ScalarOperator ScalarString="[redacted].[dbo].[StreamLock].[LockOwnerID] as [sl].[LockOwnerID]"> | |
| <Identifier> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[StreamLock]" Alias="[sl]" Column="LockOwnerID" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </RangeExpressions> | |
| </Prefix> | |
| </SeekKeys> | |
| </SeekPredicateNew> | |
| </SeekPredicates> | |
| </IndexScan> | |
| </RelOp> | |
| <RelOp NodeId="5" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="76" EstimatedTotalSubtreeCost="0.197859" TableCardinality="3.94326e+006" Parallel="0" EstimateRebinds="64.7972" EstimateRewinds="0.20284" EstimatedExecutionMode="Row"> | |
| <OutputList> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[EmailAddresses]" Alias="[ea]" Column="Email" /> | |
| </OutputList> | |
| <RunTimeInformation> | |
| <RunTimeCountersPerThread Thread="0" ActualRows="66" ActualElapsedms="0" ActualCPUms="0" ActualScans="66" ActualLogicalReads="333" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="66" ActualEndOfScans="66" ActualExecutions="66" /> | |
| </RunTimeInformation> | |
| <IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"> | |
| <DefinedValues> | |
| <DefinedValue> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[EmailAddresses]" Alias="[ea]" Column="Email" /> | |
| </DefinedValue> | |
| </DefinedValues> | |
| <Object Database="[redacted]" 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="[redacted]" Schema="[dbo]" Table="[EmailAddresses]" Alias="[ea]" Column="UserID" /> | |
| </RangeColumns> | |
| <RangeExpressions> | |
| <ScalarOperator ScalarString="[redacted].[dbo].[Users].[ID] as [ul].[ID]"> | |
| <Identifier> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Users]" Alias="[ul]" Column="ID" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </RangeExpressions> | |
| </Prefix> | |
| </SeekKeys> | |
| </SeekPredicateNew> | |
| </SeekPredicates> | |
| <Predicate> | |
| <ScalarOperator ScalarString="[redacted].[dbo].[EmailAddresses].[IsPrimary] as [ea].[IsPrimary]=(1)"> | |
| <Compare CompareOp="EQ"> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[EmailAddresses]" Alias="[ea]" Column="IsPrimary" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Const ConstValue="(1)" /> | |
| </ScalarOperator> | |
| </Compare> | |
| </ScalarOperator> | |
| </Predicate> | |
| </IndexScan> | |
| </RelOp> | |
| </NestedLoops> | |
| </RelOp> | |
| </NestedLoops> | |
| </RelOp> | |
| <RelOp NodeId="6" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="5227.75" EstimateIO="0" EstimateCPU="0.0218531" AvgRowSize="1508" EstimatedTotalSubtreeCost="31.5283" 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="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="Name" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="Type" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="CreationDate" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="ExpirationDate" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="CreatorID" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="FileName" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="FilePath" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="FileSizeBytes" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="Hash" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="FileCount" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="ProgenyEditDate" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="ClientModifiedDate" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="ClientCreatedDate" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Users]" Alias="[uc]" Column="FirstName" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Users]" Alias="[uc]" Column="LastName" /> | |
| </OutputList> | |
| <RunTimeInformation> | |
| <RunTimeCountersPerThread Thread="0" ActualRows="5229" ActualElapsedms="89" ActualCPUms="89" ActualEndOfScans="1" ActualExecutions="1" /> | |
| </RunTimeInformation> | |
| <NestedLoops Optimized="0" WithUnorderedPrefetch="1"> | |
| <OuterReferences> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="CreatorID" /> | |
| <ColumnReference Column="Expr1013" /> | |
| </OuterReferences> | |
| <RelOp NodeId="8" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="5228.03" EstimateIO="0" EstimateCPU="0.0218572" AvgRowSize="992" EstimatedTotalSubtreeCost="17.1166" 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="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="Name" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="Type" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="CreationDate" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="ExpirationDate" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="CreatorID" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="FileName" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="FilePath" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="FileSizeBytes" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="Hash" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="FileCount" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="ProgenyEditDate" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="ClientModifiedDate" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="ClientCreatedDate" /> | |
| </OutputList> | |
| <MemoryFractions Input="0" Output="0.642857" /> | |
| <RunTimeInformation> | |
| <RunTimeCountersPerThread Thread="0" ActualRows="5229" ActualElapsedms="58" ActualCPUms="58" 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="Expr1012" /> | |
| </OuterReferences> | |
| <RelOp NodeId="11" 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="1" ActualCPUms="1" 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="12" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="914" EstimatedTotalSubtreeCost="17.0389" TableCardinality="8.59501e+008" Parallel="0" EstimateRebinds="5228" EstimateRewinds="0" EstimatedExecutionMode="Row"> | |
| <OutputList> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="Name" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="Type" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="CreationDate" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="ExpirationDate" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="CreatorID" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="FileName" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="FilePath" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="FileSizeBytes" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="Hash" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="FileCount" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="ProgenyEditDate" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="ClientModifiedDate" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="ClientCreatedDate" /> | |
| </OutputList> | |
| <RunTimeInformation> | |
| <RunTimeCountersPerThread Thread="0" ActualRows="5229" ActualElapsedms="42" ActualCPUms="42" 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="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="Name" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="Type" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="CreationDate" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="ExpirationDate" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="CreatorID" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="FileName" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="FilePath" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="FileSizeBytes" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="Hash" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="FileCount" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="ProgenyEditDate" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="ClientModifiedDate" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Items]" Alias="[i]" Column="ClientCreatedDate" /> | |
| </DefinedValue> | |
| </DefinedValues> | |
| <Object Database="[redacted]" Schema="[dbo]" Table="[Items]" Index="[PK_Items]" Alias="[i]" IndexKind="Clustered" Storage="RowStore" /> | |
| <SeekPredicates> | |
| <SeekPredicateNew> | |
| <SeekKeys> | |
| <Prefix ScanType="EQ"> | |
| <RangeColumns> | |
| <ColumnReference Database="[redacted]" 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="13" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="525" EstimatedTotalSubtreeCost="14.3898" TableCardinality="3.94039e+006" Parallel="0" EstimateRebinds="5224.95" EstimateRewinds="2.07538" EstimatedExecutionMode="Row"> | |
| <OutputList> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Users]" Alias="[uc]" Column="FirstName" /> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Users]" Alias="[uc]" Column="LastName" /> | |
| </OutputList> | |
| <RunTimeInformation> | |
| <RunTimeCountersPerThread Thread="0" ActualRows="5229" ActualElapsedms="27" ActualCPUms="27" 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="[redacted]" Schema="[dbo]" Table="[Users]" Alias="[uc]" Column="FirstName" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Users]" Alias="[uc]" Column="LastName" /> | |
| </DefinedValue> | |
| </DefinedValues> | |
| <Object Database="[redacted]" Schema="[dbo]" Table="[Users]" Index="[IX_Users_ID_AccountID]" Alias="[uc]" IndexKind="NonClustered" Storage="RowStore" /> | |
| <SeekPredicates> | |
| <SeekPredicateNew> | |
| <SeekKeys> | |
| <Prefix ScanType="EQ"> | |
| <RangeColumns> | |
| <ColumnReference Database="[redacted]" Schema="[dbo]" Table="[Users]" Alias="[uc]" Column="ID" /> | |
| </RangeColumns> | |
| <RangeExpressions> | |
| <ScalarOperator ScalarString="[redacted].[dbo].[Items].[CreatorID] as [i].[CreatorID]"> | |
| <Identifier> | |
| <ColumnReference Database="[redacted]" 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