Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?xml version="1.0" encoding="utf-16"?>
- <ShowPlanXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="1.1" Build="10.50.1617.0" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
- <BatchSequence>
- <Batch>
- <Statements>
- <StmtSimple StatementCompId="6" StatementEstRows="43.6737" StatementId="1" StatementOptmLevel="FULL" StatementSubTreeCost="24.6149" StatementText="SELECT * FROM (
 SELECT TOP (@EndRow)
 CompanyName, Email, UserId, Handle,
 ServicePoint1, ServicePoint2, ServicePoint3,
 ServicePoint4, ServicePoint5, ServicePoint6,
 Building, Street, City, Region, Postcode, Latitude, Longitude, 
 Activity, ActivityID, IsFromPaidBusinessDB, Recommendations,
 ROW_NUMBER() OVER (ORDER BY Recommendations DESC, CompanyName ) AS num
 
 FROM
 vw_AddressesWithEverything
 
 WHERE
 ( -- filter for all queries --
 (DatePaidUpTo >= @CurrentTime)
 OR (
 (IsFromPaidBusinessDB = 1) 
 AND (DatePaidUpTo IS NULL)
 )
 ) 
 AND ( -- filter if user fills in 'searchfor' box --
 (@SearchFor IS NULL)
 OR (CompanyName like '%' + @SearchFor + '%') 
 OR (Handle like '%' + @SearchFor + '%')
 OR (Activity like '%' + @SearchFor + '%')
 )
 AND (
 (
 (@SearchInLat is null)
 OR (@SearchInLng is null)
 )
 OR ( 
 ((Latitude - @SearchInLat) BETWEEN -0.5 AND 0.5)
 AND ((Longitude - @SearchInLng) BETWEEN -0.5 AND 0.5)
 )
 ) 
 AND ( -- filter by activity --
 (@SearchActivity IS NULL)
 OR (@SearchActivity = ActivityID)
 )
 
 ORDER BY 
 Recommendations DESC,
 CompanyName 
 ) As a
 WHERE num > @StartRow

 OPTION (RECOMPILE)

" StatementType="SELECT" QueryHash="0xB2AA21CCF0551F3F" QueryPlanHash="0x0C84B2390D54E3C4">
- <StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" />
- <QueryPlan DegreeOfParallelism="0" MemoryGrant="29232" CachedPlanSize="240" CompileTime="100" CompileCPU="100" CompileMemory="3776">
- <RelOp AvgRowSize="1452" EstimateCPU="6.98779E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="43.6737" LogicalOp="Filter" NodeId="0" Parallel="false" PhysicalOp="Filter" EstimatedTotalSubtreeCost="24.6149">
- <OutputList>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Building" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Postcode" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="City" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Region" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Street" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Latitude" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Longitude" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="UserId" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="Email" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="CompanyName" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ActivityID" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint1" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint2" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint3" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint4" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint5" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint6" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="IsFromPaidBusinessDB" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[aspnet_Users]" Column="UserName" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Activities]" Column="Activity" />
- <ColumnReference Column="Expr1022" />
- <ColumnReference Column="Expr1023" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="180" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <Filter StartupExpression="false">
- <RelOp AvgRowSize="1452" EstimateCPU="1.45579E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="145.579" LogicalOp="Top" NodeId="1" Parallel="false" PhysicalOp="Top" EstimatedTotalSubtreeCost="24.6148">
- <OutputList>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Building" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Postcode" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="City" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Region" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Street" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Latitude" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Longitude" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="UserId" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="Email" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="CompanyName" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ActivityID" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint1" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint2" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint3" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint4" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint5" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint6" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="IsFromPaidBusinessDB" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[aspnet_Users]" Column="UserName" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Activities]" Column="Activity" />
- <ColumnReference Column="Expr1022" />
- <ColumnReference Column="Expr1023" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="210" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <Top RowCount="false" IsPercent="false" WithTies="false">
- <TopExpression>
- <ScalarOperator ScalarString="CONVERT_IMPLICIT(bigint,[@EndRow],0)">
- <Identifier>
- <ColumnReference Column="ConstExpr1041">
- <ScalarOperator>
- <Convert DataType="bigint" Style="0" Implicit="true">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@EndRow" />
- </Identifier>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </ColumnReference>
- </Identifier>
- </ScalarOperator>
- </TopExpression>
- <RelOp AvgRowSize="1452" EstimateCPU="1.16463E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="145.579" LogicalOp="Compute Scalar" NodeId="2" Parallel="false" PhysicalOp="Sequence Project" EstimatedTotalSubtreeCost="24.6148">
- <OutputList>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Building" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Postcode" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="City" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Region" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Street" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Latitude" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Longitude" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="UserId" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="Email" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="CompanyName" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ActivityID" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint1" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint2" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint3" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint4" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint5" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint6" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="IsFromPaidBusinessDB" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[aspnet_Users]" Column="UserName" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Activities]" Column="Activity" />
- <ColumnReference Column="Expr1022" />
- <ColumnReference Column="Expr1023" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="210" ActualEndOfScans="0" ActualExecutions="1" />
- </RunTimeInformation>
- <SequenceProject>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1023" />
- <ScalarOperator ScalarString="row_number">
- <Sequence FunctionName="row_number" />
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="1452" EstimateCPU="2.91158E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="145.579" LogicalOp="Segment" NodeId="3" Parallel="false" PhysicalOp="Segment" EstimatedTotalSubtreeCost="24.6148">
- <OutputList>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Building" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Postcode" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="City" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Region" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Street" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Latitude" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Longitude" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="UserId" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="Email" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="CompanyName" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ActivityID" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint1" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint2" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint3" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint4" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint5" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint6" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="IsFromPaidBusinessDB" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[aspnet_Users]" Column="UserName" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Activities]" Column="Activity" />
- <ColumnReference Column="Expr1022" />
- <ColumnReference Column="Segment1049" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="210" ActualEndOfScans="0" ActualExecutions="1" />
- </RunTimeInformation>
- <Segment>
- <GroupBy />
- <SegmentColumn>
- <ColumnReference Column="Segment1049" />
- </SegmentColumn>
- <RelOp AvgRowSize="1444" EstimateCPU="0.00173333" EstimateIO="0.0112613" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="145.579" LogicalOp="Sort" NodeId="4" Parallel="false" PhysicalOp="Sort" EstimatedTotalSubtreeCost="24.6148">
- <OutputList>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Building" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Postcode" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="City" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Region" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Street" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Latitude" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Longitude" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="UserId" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="Email" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="CompanyName" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ActivityID" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint1" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint2" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint3" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint4" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint5" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint6" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="IsFromPaidBusinessDB" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[aspnet_Users]" Column="UserName" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Activities]" Column="Activity" />
- <ColumnReference Column="Expr1022" />
- </OutputList>
- <MemoryFractions Input="0.0176355" Output="1" />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRebinds="1" ActualRewinds="0" ActualRows="210" ActualEndOfScans="0" ActualExecutions="1" />
- </RunTimeInformation>
- <Sort Distinct="false">
- <OrderBy>
- <OrderByColumn Ascending="false">
- <ColumnReference Column="Expr1022" />
- </OrderByColumn>
- <OrderByColumn Ascending="true">
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="CompanyName" />
- </OrderByColumn>
- </OrderBy>
- <RelOp AvgRowSize="1444" EstimateCPU="0.00561876" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="145.579" LogicalOp="Right Outer Join" NodeId="5" Parallel="false" PhysicalOp="Merge Join" EstimatedTotalSubtreeCost="24.6018">
- <OutputList>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Building" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Postcode" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="City" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Region" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Street" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Latitude" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Longitude" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="UserId" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="Email" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="CompanyName" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ActivityID" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint1" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint2" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint3" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint4" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint5" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint6" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="IsFromPaidBusinessDB" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[aspnet_Users]" Column="UserName" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Activities]" Column="Activity" />
- <ColumnReference Column="Expr1022" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="1879" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <Merge ManyToMany="false">
- <InnerSideJoinColumns>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="UserId" />
- </InnerSideJoinColumns>
- <OuterSideJoinColumns>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Recommendations]" Column="RecommendedUserId" />
- </OuterSideJoinColumns>
- <Residual>
- <ScalarOperator ScalarString="[testdb].[dbo].[Addresses].[UserId]=[testdb].[dbo].[Recommendations].[RecommendedUserId]">
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="UserId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Recommendations]" Column="RecommendedUserId" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Residual>
- <RelOp AvgRowSize="27" EstimateCPU="3.47E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Compute Scalar" NodeId="6" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.0277073">
- <OutputList>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Recommendations]" Column="RecommendedUserId" />
- <ColumnReference Column="Expr1022" />
- </OutputList>
- <ComputeScalar>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1022" />
- <ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[Expr1046],0)">
- <Convert DataType="int" Style="0" Implicit="true">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Expr1046" />
- </Identifier>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="27" EstimateCPU="3.47E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Aggregate" NodeId="7" Parallel="false" PhysicalOp="Stream Aggregate" EstimatedTotalSubtreeCost="0.0277073">
- <OutputList>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Recommendations]" Column="RecommendedUserId" />
- <ColumnReference Column="Expr1046" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="44" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <StreamAggregate>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1046" />
- <ScalarOperator ScalarString="Count(*)">
- <Aggregate AggType="countstar" Distinct="false" />
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <GroupBy>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Recommendations]" Column="RecommendedUserId" />
- </GroupBy>
- <RelOp AvgRowSize="23" EstimateCPU="0.000618684" EstimateIO="0.0112613" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="57" LogicalOp="Sort" NodeId="8" Parallel="false" PhysicalOp="Sort" EstimatedTotalSubtreeCost="0.0276726">
- <OutputList>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Recommendations]" Column="RecommendedUserId" />
- </OutputList>
- <MemoryFractions Input="0.5" Output="0.00130634" />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRebinds="1" ActualRewinds="0" ActualRows="49" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <Sort Distinct="false">
- <OrderBy>
- <OrderByColumn Ascending="true">
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Recommendations]" Column="RecommendedUserId" />
- </OrderByColumn>
- </OrderBy>
- <RelOp AvgRowSize="23" EstimateCPU="0.00023826" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="57" LogicalOp="Inner Join" NodeId="9" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0157926">
- <OutputList>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Recommendations]" Column="RecommendedUserId" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="49" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <NestedLoops Optimized="true" WithUnorderedPrefetch="true">
- <OuterReferences>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Recommendations]" Column="RecommenderUserId" />
- <ColumnReference Column="Expr1045" />
- </OuterReferences>
- <RelOp AvgRowSize="39" EstimateCPU="0.0002197" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="57" LogicalOp="Clustered Index Scan" NodeId="12" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0033447" TableCardinality="57">
- <OutputList>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Recommendations]" Column="RecommendedUserId" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Recommendations]" Column="RecommenderUserId" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="57" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <IndexScan Ordered="false" ForcedIndex="false" NoExpandHint="false">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Recommendations]" Column="RecommendedUserId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Recommendations]" Column="RecommenderUserId" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[testdb]" Schema="[dbo]" Table="[Recommendations]" Index="[PK_Recommendations]" IndexKind="Clustered" />
- </IndexScan>
- </RelOp>
- <RelOp AvgRowSize="16" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="56" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="13" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0121367" TableCardinality="161188">
- <OutputList />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="49" ActualEndOfScans="8" ActualExecutions="57" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
- <DefinedValues />
- <Object Database="[testdb]" Schema="[dbo]" Table="[Users]" Index="[PK_user_Details]" TableReferenceId="2" IndexKind="Clustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="UserId" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[testdb].[dbo].[Recommendations].[RecommenderUserId]">
- <Identifier>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Recommendations]" Column="RecommenderUserId" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- <Predicate>
- <ScalarOperator ScalarString="[testdb].[dbo].[Users].[IsActive]=(1) AND ([testdb].[dbo].[Users].[IsFromPaidBusinessDB]=(1) OR [testdb].[dbo].[Users].[DatePaidUpTo]>getdate())">
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="IsActive" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(1)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Logical Operation="OR">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="IsFromPaidBusinessDB" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(1)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="GT">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="DatePaidUpTo" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="ConstExpr1024">
- <ScalarOperator>
- <Intrinsic FunctionName="getdate" />
- </ScalarOperator>
- </ColumnReference>
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Predicate>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- </Sort>
- </RelOp>
- </StreamAggregate>
- </RelOp>
- </ComputeScalar>
- </RelOp>
- <RelOp AvgRowSize="1456" EstimateCPU="0.00173334" EstimateIO="0.0112613" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="145.579" LogicalOp="Sort" NodeId="19" Parallel="false" PhysicalOp="Sort" EstimatedTotalSubtreeCost="24.5685">
- <OutputList>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="UserId" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Building" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Postcode" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="City" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Region" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Street" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Latitude" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Longitude" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="Email" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="CompanyName" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ActivityID" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint1" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint2" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint3" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint4" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint5" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint6" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="IsFromPaidBusinessDB" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[aspnet_Users]" Column="UserName" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Activities]" Column="Activity" />
- </OutputList>
- <MemoryFractions Input="0.0176355" Output="0.981058" />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRebinds="1" ActualRewinds="0" ActualRows="1879" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <Sort Distinct="false">
- <OrderBy>
- <OrderByColumn Ascending="true">
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="UserId" />
- </OrderByColumn>
- </OrderBy>
- <RelOp AvgRowSize="1456" EstimateCPU="0.0309342" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="145.579" LogicalOp="Inner Join" NodeId="20" Parallel="false" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="24.5555">
- <OutputList>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="UserId" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Building" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Postcode" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="City" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Region" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Street" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Latitude" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Longitude" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="UserId" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="Email" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="CompanyName" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ActivityID" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint1" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint2" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint3" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint4" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint5" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint6" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="IsFromPaidBusinessDB" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[aspnet_Users]" Column="UserName" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Activities]" Column="Activity" />
- </OutputList>
- <MemoryFractions Input="0" Output="0" />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="1879" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <Hash>
- <DefinedValues />
- <HashKeysBuild>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Country]" Column="Iso" />
- </HashKeysBuild>
- <HashKeysProbe>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="CountryISO" />
- </HashKeysProbe>
- <ProbeResidual>
- <ScalarOperator ScalarString="[testdb].[dbo].[Addresses].[CountryISO]=[testdb].[dbo].[Country].[Iso]">
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="CountryISO" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Country]" Column="Iso" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </ProbeResidual>
- <RelOp AvgRowSize="15" EstimateCPU="0.0004221" EstimateIO="0.00460648" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="241" LogicalOp="Table Scan" NodeId="21" Parallel="false" PhysicalOp="Table Scan" EstimatedTotalSubtreeCost="0.00502858" TableCardinality="241">
- <OutputList>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Country]" Column="Iso" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="241" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <TableScan Ordered="false" ForcedIndex="false" NoExpandHint="false">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Country]" Column="Iso" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[testdb]" Schema="[dbo]" Table="[Country]" IndexKind="Heap" />
- </TableScan>
- </RelOp>
- <RelOp AvgRowSize="1462" EstimateCPU="0.00126632" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="302.947" LogicalOp="Inner Join" NodeId="22" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="24.5185">
- <OutputList>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="UserId" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Building" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="CountryISO" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Postcode" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="City" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Region" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Street" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Latitude" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Longitude" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="UserId" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="Email" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="CompanyName" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ActivityID" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint1" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint2" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint3" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint4" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint5" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint6" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="IsFromPaidBusinessDB" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[aspnet_Users]" Column="UserName" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Activities]" Column="Activity" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="1879" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <NestedLoops Optimized="true" WithUnorderedPrefetch="true">
- <OuterReferences>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="AddressId" />
- <ColumnReference Column="Expr1048" />
- </OuterReferences>
- <RelOp AvgRowSize="583" EstimateCPU="0.00126539" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="302.947" LogicalOp="Inner Join" NodeId="25" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="23.5495">
- <OutputList>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="UserId" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="AddressId" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="UserId" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="Email" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="CompanyName" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ActivityID" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint1" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint2" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint3" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint4" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint5" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint6" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="IsFromPaidBusinessDB" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[aspnet_Users]" Column="UserName" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Activities]" Column="Activity" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="1879" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <NestedLoops Optimized="true" WithUnorderedPrefetch="true">
- <OuterReferences>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[aspnet_Users]" Column="UserId" />
- <ColumnReference Column="Expr1047" />
- </OuterReferences>
- <RelOp AvgRowSize="567" EstimateCPU="0.819913" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="302.726" LogicalOp="Inner Join" NodeId="28" Parallel="false" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="22.6889">
- <OutputList>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="UserId" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="Email" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="CompanyName" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ActivityID" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint1" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint2" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint3" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint4" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint5" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint6" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="IsFromPaidBusinessDB" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[aspnet_Users]" Column="UserId" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[aspnet_Users]" Column="UserName" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Activities]" Column="Activity" />
- </OutputList>
- <MemoryFractions Input="0.130876" Output="0.124428" />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="1879" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <Hash>
- <DefinedValues />
- <HashKeysBuild>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Activities]" Column="ActivityID" />
- </HashKeysBuild>
- <HashKeysProbe>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ActivityID" />
- </HashKeysProbe>
- <ProbeResidual>
- <ScalarOperator ScalarString="[testdb].[dbo].[Users].[ActivityID]=[testdb].[dbo].[Activities].[ActivityID] AND ([@SearchFor] IS NULL OR [testdb].[dbo].[Users].[CompanyName] like (N'%'+[@SearchFor])+N'%' OR [testdb].[dbo].[aspnet_Users].[UserName] like (N'%'+[@SearchFor])+N'%' OR [testdb].[dbo].[Activities].[Activity] like (N'%'+[@SearchFor])+N'%')">
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ActivityID" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Activities]" Column="ActivityID" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Logical Operation="OR">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="ConstExpr1025">
- <ScalarOperator>
- <Compare CompareOp="IS">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@SearchFor" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </ColumnReference>
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Intrinsic FunctionName="like">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="CompanyName" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="ConstExpr1026">
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Const ConstValue="N'%'" />
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@SearchFor" />
- </Identifier>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'%'" />
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- </ColumnReference>
- </Identifier>
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Intrinsic FunctionName="like">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[aspnet_Users]" Column="UserName" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="ConstExpr1030">
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Const ConstValue="N'%'" />
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@SearchFor" />
- </Identifier>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'%'" />
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- </ColumnReference>
- </Identifier>
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Intrinsic FunctionName="like">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Activities]" Column="Activity" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="ConstExpr1034">
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Const ConstValue="N'%'" />
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@SearchFor" />
- </Identifier>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'%'" />
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- </ColumnReference>
- </Identifier>
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </ProbeResidual>
- <RelOp AvgRowSize="60" EstimateCPU="0.0026078" EstimateIO="0.0194213" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="2228" LogicalOp="Clustered Index Scan" NodeId="29" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0220291" TableCardinality="2228">
- <OutputList>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Activities]" Column="ActivityID" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Activities]" Column="Activity" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="2228" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <IndexScan Ordered="false" ForcedIndex="false" NoExpandHint="false">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Activities]" Column="ActivityID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Activities]" Column="Activity" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[testdb]" Schema="[dbo]" Table="[Activities]" Index="[PK_Activities]" IndexKind="Clustered" />
- </IndexScan>
- </RelOp>
- <RelOp AvgRowSize="520" EstimateCPU="0.59765" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="106034" LogicalOp="Inner Join" NodeId="30" Parallel="false" PhysicalOp="Merge Join" EstimatedTotalSubtreeCost="21.8469">
- <OutputList>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="UserId" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="Email" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="CompanyName" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ActivityID" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint1" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint2" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint3" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint4" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint5" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint6" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="IsFromPaidBusinessDB" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[aspnet_Users]" Column="UserId" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[aspnet_Users]" Column="UserName" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="161151" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <Merge ManyToMany="false">
- <InnerSideJoinColumns>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[aspnet_Users]" Column="UserId" />
- </InnerSideJoinColumns>
- <OuterSideJoinColumns>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="UserId" />
- </OuterSideJoinColumns>
- <Residual>
- <ScalarOperator ScalarString="[testdb].[dbo].[Users].[UserId]=[testdb].[dbo].[aspnet_Users].[UserId]">
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="UserId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[aspnet_Users]" Column="UserId" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Residual>
- <RelOp AvgRowSize="477" EstimateCPU="0.177464" EstimateIO="5.78312" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="114966" LogicalOp="Clustered Index Scan" NodeId="31" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="5.96059" TableCardinality="161188">
- <OutputList>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="UserId" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="Email" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="CompanyName" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ActivityID" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint1" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint2" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint3" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint4" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint5" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint6" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="IsFromPaidBusinessDB" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="161151" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="UserId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="Email" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="CompanyName" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ActivityID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint1" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint2" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint3" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint4" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint5" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ServicePoint6" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="IsFromPaidBusinessDB" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[testdb]" Schema="[dbo]" Table="[Users]" Index="[PK_user_Details]" TableReferenceId="1" IndexKind="Clustered" />
- <Predicate>
- <ScalarOperator ScalarString="[testdb].[dbo].[Users].[IsActive]=(1) AND [testdb].[dbo].[Users].[IsPro]=(1) AND ([@SearchActivity] IS NULL OR [@SearchActivity]=[testdb].[dbo].[Users].[ActivityID]) AND ([testdb].[dbo].[Users].[DatePaidUpTo]>=[@CurrentTime] OR [testdb].[dbo].[Users].[IsFromPaidBusinessDB]=(1) AND [testdb].[dbo].[Users].[DatePaidUpTo] IS NULL)">
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="IsActive" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(1)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="IsPro" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(1)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Logical Operation="OR">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="ConstExpr1040">
- <ScalarOperator>
- <Compare CompareOp="IS">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@SearchActivity" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </ColumnReference>
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@SearchActivity" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="ActivityID" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- <ScalarOperator>
- <Logical Operation="OR">
- <ScalarOperator>
- <Compare CompareOp="GE">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="DatePaidUpTo" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@CurrentTime" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="IsFromPaidBusinessDB" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(1)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="IS">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Users]" Column="DatePaidUpTo" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Predicate>
- </IndexScan>
- </RelOp>
- <RelOp AvgRowSize="60" EstimateCPU="12.8607" EstimateIO="0.0112613" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="161913" LogicalOp="Sort" NodeId="32" Parallel="false" PhysicalOp="Sort" EstimatedTotalSubtreeCost="14.8889">
- <OutputList>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[aspnet_Users]" Column="UserId" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[aspnet_Users]" Column="UserName" />
- </OutputList>
- <MemoryFractions Input="0.808295" Output="0.808295" />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRebinds="1" ActualRewinds="0" ActualRows="161913" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <Sort Distinct="false">
- <OrderBy>
- <OrderByColumn Ascending="true">
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[aspnet_Users]" Column="UserId" />
- </OrderByColumn>
- </OrderBy>
- <RelOp AvgRowSize="60" EstimateCPU="0.178261" EstimateIO="1.83868" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="161913" LogicalOp="Clustered Index Scan" NodeId="33" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="2.01694" TableCardinality="161913">
- <OutputList>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[aspnet_Users]" Column="UserId" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[aspnet_Users]" Column="UserName" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="161913" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <IndexScan Ordered="false" ForcedIndex="false" NoExpandHint="false">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[aspnet_Users]" Column="UserId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[aspnet_Users]" Column="UserName" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[testdb]" Schema="[dbo]" Table="[aspnet_Users]" Index="[aspnet_Users_Index]" IndexKind="Clustered" />
- </IndexScan>
- </RelOp>
- </Sort>
- </RelOp>
- </Merge>
- </RelOp>
- </Hash>
- </RelOp>
- <RelOp AvgRowSize="39" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="301.725" EstimateRewinds="0.000633753" EstimateRows="1" LogicalOp="Index Seek" NodeId="36" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.859289" TableCardinality="161168">
- <OutputList>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="UserId" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="AddressId" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="1879" ActualEndOfScans="1879" ActualExecutions="1879" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="UserId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="AddressId" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Index="[idx_UserID]" IndexKind="NonClustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="UserId" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[testdb].[dbo].[aspnet_Users].[UserId]">
- <Identifier>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[aspnet_Users]" Column="UserId" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- <RelOp AvgRowSize="901" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="301.947" EstimateRewinds="0" EstimateRows="290.865" LogicalOp="Clustered Index Seek" NodeId="38" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.967787" TableCardinality="161168">
- <OutputList>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Building" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="CountryISO" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Postcode" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="City" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Region" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Street" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Latitude" />
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Longitude" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="1879" ActualEndOfScans="0" ActualExecutions="1879" />
- </RunTimeInformation>
- <IndexScan Lookup="true" Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Building" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="CountryISO" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Postcode" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="City" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Region" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Street" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Latitude" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Longitude" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Index="[PK_Addresses]" TableReferenceId="-1" IndexKind="Clustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="AddressId" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[testdb].[dbo].[Addresses].[AddressId]">
- <Identifier>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="AddressId" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- <Predicate>
- <ScalarOperator ScalarString="[testdb].[dbo].[Addresses].[Latitude] IS NOT NULL AND [testdb].[dbo].[Addresses].[Longitude] IS NOT NULL AND ([@SearchInLat] IS NULL OR [@SearchInLng] IS NULL OR ([testdb].[dbo].[Addresses].[Latitude]-[@SearchInLat])>=(-0.5) AND ([testdb].[dbo].[Addresses].[Latitude]-[@SearchInLat])<=(0.5) AND ([testdb].[dbo].[Addresses].[Longitude]-[@SearchInLng])>=(-0.5) AND ([testdb].[dbo].[Addresses].[Longitude]-[@SearchInLng])<=(0.5))">
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="IS NOT">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Latitude" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="IS NOT">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Longitude" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Logical Operation="OR">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="ConstExpr1038">
- <ScalarOperator>
- <Compare CompareOp="IS">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@SearchInLat" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </ColumnReference>
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="ConstExpr1039">
- <ScalarOperator>
- <Compare CompareOp="IS">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@SearchInLng" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </ColumnReference>
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="GE">
- <ScalarOperator>
- <Arithmetic Operation="SUB">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Latitude" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@SearchInLat" />
- </Identifier>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(-0.5)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="LE">
- <ScalarOperator>
- <Arithmetic Operation="SUB">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Latitude" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@SearchInLat" />
- </Identifier>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(0.5)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="GE">
- <ScalarOperator>
- <Arithmetic Operation="SUB">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Longitude" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@SearchInLng" />
- </Identifier>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(-0.5)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="LE">
- <ScalarOperator>
- <Arithmetic Operation="SUB">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[testdb]" Schema="[dbo]" Table="[Addresses]" Column="Longitude" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@SearchInLng" />
- </Identifier>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(0.5)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Predicate>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- </Hash>
- </RelOp>
- </Sort>
- </RelOp>
- </Merge>
- </RelOp>
- </Sort>
- </RelOp>
- </Segment>
- </RelOp>
- </SequenceProject>
- </RelOp>
- </Top>
- </RelOp>
- <Predicate>
- <ScalarOperator ScalarString="[Expr1023]>CONVERT_IMPLICIT(bigint,[@StartRow],0)">
- <Compare CompareOp="GT">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Expr1023" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="ConstExpr1042">
- <ScalarOperator>
- <Convert DataType="bigint" Style="0" Implicit="true">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@StartRow" />
- </Identifier>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </ColumnReference>
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Predicate>
- </Filter>
- </RelOp>
- <ParameterList>
- <ColumnReference Column="@StartRow" ParameterCompiledValue="(30)" ParameterRuntimeValue="(30)" />
- <ColumnReference Column="@EndRow" ParameterCompiledValue="(210)" ParameterRuntimeValue="(210)" />
- <ColumnReference Column="@SearchActivity" ParameterCompiledValue="NULL" ParameterRuntimeValue="NULL" />
- <ColumnReference Column="@SearchInLng" ParameterCompiledValue="NULL" ParameterRuntimeValue="NULL" />
- <ColumnReference Column="@SearchInLat" ParameterCompiledValue="NULL" ParameterRuntimeValue="NULL" />
- <ColumnReference Column="@SearchFor" ParameterCompiledValue="N'accountant'" ParameterRuntimeValue="N'accountant'" />
- <ColumnReference Column="@CurrentTime" ParameterCompiledValue="'2012-01-23 12:34:35.797'" ParameterRuntimeValue="'2012-01-23 12:34:35.797'" />
- </ParameterList>
- </QueryPlan>
- </StmtSimple>
- </Statements>
- </Batch>
- </BatchSequence>
- </ShowPlanXML>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement