SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

-- problem set-up: schema & data
--- schema
CREATE TABLE Clients (
  Id INT IDENTITY PRIMARY KEY,
  Name VARCHAR(32) NOT NULL
);

CREATE TABLE Users (
  Id INT,
  Username VARCHAR(32) NOT NULL,
  Type VARCHAR(8) NOT NULL CHECK (Type IN ('Admin', 'User')),
  Client INT NOT NULL,
  PRIMARY KEY (Username),
  UNIQUE (id),
  FOREIGN KEY (Client) REFERENCES Clients (Id)
);

CREATE TABLE Leads (
  Id INT IDENTITY PRIMARY KEY,
  Name VARCHAR(64),
  Company VARCHAR(64),
  Profession VARCHAR(64),
  CreatedBy VARCHAR(32) NOT NULL,
  FOREIGN KEY (CreatedBy) REFERENCES Users (Username)
);
--- data

SET IDENTITY_INSERT Clients ON;

INSERT INTO Clients (Id, Name)
  VALUES
(1, 'IDM'),
(2, 'FooCo')
;

SET IDENTITY_INSERT Clients OFF;

INSERT INTO Users (Id, Username, Type, Client)
  VALUES
(1, 'Sathar', 'Admin', 1),
(2, 'bafh', 'Admin', 1),
(3, 'fred', 'User', 1),
(4, 'bloggs', 'User', 1),
(5, 'jadmin', 'Admin', 2),
(6, 'juser', 'User', 2)
;


INSERT INTO Leads (Name, Company, Profession, CreatedBy)
  VALUES
('A. Person', 'team lead', 'A Co', 'Sathar'),
('A. Parrot', 'team mascot', 'B Co', 'Sathar'),

('Alice Adams', 'analyst', 'C Co', 'juser'),
('"Bob" Dobbs', 'Drilling Equipment Salesman', 'D Co', 'juser'),
('Carol Kent', 'consultant', 'E Co', 'juser'),

('John Q. Employee', 'employee', 'F Co', 'fred'),
('Jane Q. Employee', 'employee', 'G Co', 'fred'),

('Bob Howard', 'Detached Special Secretary', 'Capital Laundry Services', 'jadmin')
;
16 rows affected

SET STATISTICS XML ON;

SELECT Leads.*
  FROM Leads
    JOIN Users AS creator
      ON Leads.CreatedBy = creator.Username
    JOIN Users AS viewer
      ON    viewer.Id = creator.Id
         OR (    viewer.type = 'Admin'
             AND viewer.Client = creator.Client)
  WHERE viewer.Username = 'Sathar'
;


Id
Name
Company
Profession
CreatedBy


1
A. Person
team lead
A Co
Sathar

2
A. Parrot
team mascot
B Co
Sathar

6
John Q. Employee
employee
F Co
fred

7
Jane Q. Employee
employee
G Co
fred




Microsoft SQL Server 2005 XML Showplan


<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.539" Build="15.0.4053.23"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT Leads.*&#xa;  FROM Leads&#xa;    JOIN Users AS creator&#xa;      ON Leads.CreatedBy = creator.Username&#xa;    JOIN Users AS viewer&#xa;      ON    viewer.Id = creator.Id&#xa;         OR (    viewer.type = &apos;Admin&apos;&#xa;             AND viewer.Client = creator.Client)&#xa;  WHERE viewer.Username = &apos;Sathar&apos;" StatementId="1" StatementCompId="2" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="0.0277236" StatementEstRows="2" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x1CC330B906D8CAE6" QueryPlanHash="0xDB52167C348B5B8F" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="150"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"></StatementSetOptions><QueryPlan DegreeOfParallelism="0" MemoryGrant="1056" NonParallelPlanReason="NoParallelPlansInDesktopOrExpressEdition" CachedPlanSize="56" CompileTime="0" CompileCPU="0" CompileMemory="304"><MemoryGrantInfo SerialRequiredMemory="1024" SerialDesiredMemory="1056" RequiredMemory="1024" DesiredMemory="1056" RequestedMemory="1056" GrantWaitTime="0" MaxQueryMemory="867424" GrantedMemory="1056" MaxUsedMemory="248"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="838808" EstimatedPagesCached="52425" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="1681840"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2022-07-17T09:51:34.16" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000005_29572725]" Table="[Leads]" Schema="[dbo]" Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]"></StatisticsInfo><StatisticsInfo LastUpdate="2022-07-17T09:51:34.16" ModificationCount="0" SamplingPercent="100" Statistics="[UQ__Users__3214EC0624EF0CDB]" Table="[Users]" Schema="[dbo]" Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]"></StatisticsInfo><StatisticsInfo LastUpdate="2022-07-17T09:51:34.16" ModificationCount="0" SamplingPercent="100" Statistics="[PK__Users__536C85E5D659FC07]" Table="[Users]" Schema="[dbo]" Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]"></StatisticsInfo></OptimizerStatsUsage><TraceFlags IsCompileTime="1"><TraceFlag Value="460" Scope="Global"></TraceFlag><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><TraceFlags IsCompileTime="0"><TraceFlag Value="460" Scope="Global"></TraceFlag><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><QueryTimeStats ElapsedTime="0" CpuTime="0"></QueryTimeStats><RelOp NodeId="0" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="2" EstimateIO="0" EstimateCPU="0.0178265" AvgRowSize="122" EstimatedTotalSubtreeCost="0.0277236" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Leads]" Column="Id"></ColumnReference><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Leads]" Column="Name"></ColumnReference><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Leads]" Column="Company"></ColumnReference><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Leads]" Column="Profession"></ColumnReference><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Leads]" Column="CreatedBy"></ColumnReference></OutputList><MemoryFractions Input="1" Output="1"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="4" 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" InputMemoryGrant="1056" OutputMemoryGrant="1056" UsedMemoryGrant="248"></RunTimeCountersPerThread></RunTimeInformation><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Users]" Alias="[creator]" Column="Username"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Leads]" Column="CreatedBy"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[fiddle_47b07942eec347b09215d5b4b3f2fe8e].[dbo].[Users].[Username] as [creator].[Username]=[fiddle_47b07942eec347b09215d5b4b3f2fe8e].[dbo].[Leads].[CreatedBy]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Users]" Alias="[creator]" Column="Username"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Leads]" Column="CreatedBy"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="1" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" EstimateCPU="2.508e-05" AvgRowSize="16" EstimatedTotalSubtreeCost="0.00660338" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Users]" Alias="[creator]" Column="Username"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="4" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><Predicate><ScalarOperator ScalarString="[fiddle_47b07942eec347b09215d5b4b3f2fe8e].[dbo].[Users].[Id] as [viewer].[Id]=[fiddle_47b07942eec347b09215d5b4b3f2fe8e].[dbo].[Users].[Id] as [creator].[Id] OR [fiddle_47b07942eec347b09215d5b4b3f2fe8e].[dbo].[Users].[Type] as [viewer].[Type]=&apos;Admin&apos; AND [fiddle_47b07942eec347b09215d5b4b3f2fe8e].[dbo].[Users].[Client] as [viewer].[Client]=[fiddle_47b07942eec347b09215d5b4b3f2fe8e].[dbo].[Users].[Client] as [creator].[Client]"><Logical Operation="OR"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Users]" Alias="[viewer]" Column="Id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Users]" Alias="[creator]" Column="Id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Users]" Alias="[viewer]" Column="Type"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Admin&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Users]" Alias="[viewer]" Column="Client"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Users]" Alias="[creator]" Column="Client"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Logical></ScalarOperator></Predicate><RelOp NodeId="2" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimatedRowsRead="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="23" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="6" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Users]" Alias="[viewer]" Column="Id"></ColumnReference><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Users]" Alias="[viewer]" Column="Type"></ColumnReference><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Users]" Alias="[viewer]" Column="Client"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="2" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="1" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Users]" Alias="[viewer]" Column="Id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Users]" Alias="[viewer]" Column="Type"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Users]" Alias="[viewer]" Column="Client"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Users]" Index="[PK__Users__536C85E5D659FC07]" Alias="[viewer]" IndexKind="Clustered" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Users]" Alias="[viewer]" Column="Username"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="&apos;Sathar&apos;"><Const ConstValue="&apos;Sathar&apos;"></Const></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp><RelOp NodeId="3" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="6" EstimatedRowsRead="6" EstimateIO="0.003125" EstimateCPU="0.0001636" AvgRowSize="24" EstimatedTotalSubtreeCost="0.0032886" TableCardinality="6" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Users]" Alias="[creator]" Column="Id"></ColumnReference><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Users]" Alias="[creator]" Column="Username"></ColumnReference><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Users]" Alias="[creator]" Column="Client"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="6" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="2" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="6" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Users]" Alias="[creator]" Column="Id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Users]" Alias="[creator]" Column="Username"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Users]" Alias="[creator]" Column="Client"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Users]" Index="[PK__Users__536C85E5D659FC07]" Alias="[creator]" IndexKind="Clustered" Storage="RowStore"></Object></IndexScan></RelOp></NestedLoops></RelOp><RelOp NodeId="4" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="8" EstimatedRowsRead="8" EstimateIO="0.003125" EstimateCPU="0.0001658" AvgRowSize="122" EstimatedTotalSubtreeCost="0.0032908" TableCardinality="8" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Leads]" Column="Id"></ColumnReference><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Leads]" Column="Name"></ColumnReference><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Leads]" Column="Company"></ColumnReference><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Leads]" Column="Profession"></ColumnReference><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Leads]" Column="CreatedBy"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="8" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="2" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="8" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Leads]" Column="Id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Leads]" Column="Name"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Leads]" Column="Company"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Leads]" Column="Profession"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Leads]" Column="CreatedBy"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Leads]" Index="[PK__Leads__3214EC07625FD96F]" IndexKind="Clustered" Storage="RowStore"></Object></IndexScan></RelOp></Hash></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>


SET STATISTICS XML ON;

SELECT Leads.*
  FROM Leads
    JOIN Users AS creator
      ON Leads.CreatedBy = creator.Username
    JOIN Users AS viewer
      ON    viewer.Id = creator.id
         OR (    viewer.type = 'Admin'
             AND viewer.Client = creator.Client)
  WHERE viewer.Username = 'fred'
;


Id
Name
Company
Profession
CreatedBy


6
John Q. Employee
employee
F Co
fred

7
Jane Q. Employee
employee
G Co
fred




Microsoft SQL Server 2005 XML Showplan


<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.539" Build="15.0.4053.23"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT Leads.*&#xa;  FROM Leads&#xa;    JOIN Users AS creator&#xa;      ON Leads.CreatedBy = creator.Username&#xa;    JOIN Users AS viewer&#xa;      ON    viewer.Id = creator.id&#xa;         OR (    viewer.type = &apos;Admin&apos;&#xa;             AND viewer.Client = creator.Client)&#xa;  WHERE viewer.Username = &apos;fred&apos;" StatementId="1" StatementCompId="2" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="0.0277236" StatementEstRows="2" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x1CC330B906D8CAE6" QueryPlanHash="0xDB52167C348B5B8F" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="150"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"></StatementSetOptions><QueryPlan DegreeOfParallelism="0" MemoryGrant="1056" NonParallelPlanReason="NoParallelPlansInDesktopOrExpressEdition" CachedPlanSize="56" CompileTime="15" CompileCPU="15" CompileMemory="304"><MemoryGrantInfo SerialRequiredMemory="1024" SerialDesiredMemory="1056" RequiredMemory="1024" DesiredMemory="1056" RequestedMemory="1056" GrantWaitTime="0" MaxQueryMemory="867424" GrantedMemory="1056" MaxUsedMemory="104"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="838808" EstimatedPagesCached="52425" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="1681840"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2022-07-17T09:51:34.16" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000005_29572725]" Table="[Leads]" Schema="[dbo]" Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]"></StatisticsInfo><StatisticsInfo LastUpdate="2022-07-17T09:51:34.16" ModificationCount="0" SamplingPercent="100" Statistics="[UQ__Users__3214EC0624EF0CDB]" Table="[Users]" Schema="[dbo]" Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]"></StatisticsInfo><StatisticsInfo LastUpdate="2022-07-17T09:51:34.16" ModificationCount="0" SamplingPercent="100" Statistics="[PK__Users__536C85E5D659FC07]" Table="[Users]" Schema="[dbo]" Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]"></StatisticsInfo></OptimizerStatsUsage><TraceFlags IsCompileTime="1"><TraceFlag Value="460" Scope="Global"></TraceFlag><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><TraceFlags IsCompileTime="0"><TraceFlag Value="460" Scope="Global"></TraceFlag><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><QueryTimeStats ElapsedTime="0" CpuTime="0"></QueryTimeStats><RelOp NodeId="0" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="2" EstimateIO="0" EstimateCPU="0.0178265" AvgRowSize="122" EstimatedTotalSubtreeCost="0.0277236" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Leads]" Column="Id"></ColumnReference><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Leads]" Column="Name"></ColumnReference><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Leads]" Column="Company"></ColumnReference><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Leads]" Column="Profession"></ColumnReference><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Leads]" Column="CreatedBy"></ColumnReference></OutputList><MemoryFractions Input="1" Output="1"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" 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" InputMemoryGrant="1056" OutputMemoryGrant="1056" UsedMemoryGrant="104"></RunTimeCountersPerThread></RunTimeInformation><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Users]" Alias="[creator]" Column="Username"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Leads]" Column="CreatedBy"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[fiddle_47b07942eec347b09215d5b4b3f2fe8e].[dbo].[Users].[Username] as [creator].[Username]=[fiddle_47b07942eec347b09215d5b4b3f2fe8e].[dbo].[Leads].[CreatedBy]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Users]" Alias="[creator]" Column="Username"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Leads]" Column="CreatedBy"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="1" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" EstimateCPU="2.508e-05" AvgRowSize="16" EstimatedTotalSubtreeCost="0.00660338" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Users]" Alias="[creator]" Column="Username"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><Predicate><ScalarOperator ScalarString="[fiddle_47b07942eec347b09215d5b4b3f2fe8e].[dbo].[Users].[Id] as [viewer].[Id]=[fiddle_47b07942eec347b09215d5b4b3f2fe8e].[dbo].[Users].[Id] as [creator].[Id] OR [fiddle_47b07942eec347b09215d5b4b3f2fe8e].[dbo].[Users].[Type] as [viewer].[Type]=&apos;Admin&apos; AND [fiddle_47b07942eec347b09215d5b4b3f2fe8e].[dbo].[Users].[Client] as [viewer].[Client]=[fiddle_47b07942eec347b09215d5b4b3f2fe8e].[dbo].[Users].[Client] as [creator].[Client]"><Logical Operation="OR"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Users]" Alias="[viewer]" Column="Id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Users]" Alias="[creator]" Column="Id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Users]" Alias="[viewer]" Column="Type"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;Admin&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Users]" Alias="[viewer]" Column="Client"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Users]" Alias="[creator]" Column="Client"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Logical></ScalarOperator></Predicate><RelOp NodeId="2" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimatedRowsRead="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="23" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="6" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Users]" Alias="[viewer]" Column="Id"></ColumnReference><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Users]" Alias="[viewer]" Column="Type"></ColumnReference><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Users]" Alias="[viewer]" Column="Client"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="2" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="1" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Users]" Alias="[viewer]" Column="Id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Users]" Alias="[viewer]" Column="Type"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Users]" Alias="[viewer]" Column="Client"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Users]" Index="[PK__Users__536C85E5D659FC07]" Alias="[viewer]" IndexKind="Clustered" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Users]" Alias="[viewer]" Column="Username"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="&apos;fred&apos;"><Const ConstValue="&apos;fred&apos;"></Const></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp><RelOp NodeId="3" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="6" EstimatedRowsRead="6" EstimateIO="0.003125" EstimateCPU="0.0001636" AvgRowSize="24" EstimatedTotalSubtreeCost="0.0032886" TableCardinality="6" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Users]" Alias="[creator]" Column="Id"></ColumnReference><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Users]" Alias="[creator]" Column="Username"></ColumnReference><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Users]" Alias="[creator]" Column="Client"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="6" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="2" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="6" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Users]" Alias="[creator]" Column="Id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Users]" Alias="[creator]" Column="Username"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Users]" Alias="[creator]" Column="Client"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Users]" Index="[PK__Users__536C85E5D659FC07]" Alias="[creator]" IndexKind="Clustered" Storage="RowStore"></Object></IndexScan></RelOp></NestedLoops></RelOp><RelOp NodeId="4" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="8" EstimatedRowsRead="8" EstimateIO="0.003125" EstimateCPU="0.0001658" AvgRowSize="122" EstimatedTotalSubtreeCost="0.0032908" TableCardinality="8" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Leads]" Column="Id"></ColumnReference><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Leads]" Column="Name"></ColumnReference><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Leads]" Column="Company"></ColumnReference><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Leads]" Column="Profession"></ColumnReference><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Leads]" Column="CreatedBy"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="8" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="2" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="8" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Leads]" Column="Id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Leads]" Column="Name"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Leads]" Column="Company"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Leads]" Column="Profession"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Leads]" Column="CreatedBy"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_47b07942eec347b09215d5b4b3f2fe8e]" Schema="[dbo]" Table="[Leads]" Index="[PK__Leads__3214EC07625FD96F]" IndexKind="Clustered" Storage="RowStore"></Object></IndexScan></RelOp></Hash></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>

Id	Name	Company	Profession	CreatedBy
1	A. Person	team lead	A Co	Sathar
2	A. Parrot	team mascot	B Co	Sathar
6	John Q. Employee	employee	F Co	fred
7	Jane Q. Employee	employee	G Co	fred