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.2500.0" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
- <BatchSequence>
- <Batch>
- <Statements>
- <StmtSimple StatementCompId="1" StatementEstRows="20" StatementId="1" StatementOptmLevel="FULL" StatementSubTreeCost="9.42273" StatementText="select * from (
 select top 20 * from (
 select top 20 
 ( --Start Count
 select count(*) from dJobs
 left join dClients on cltClientID = jobClientId 
 left join dJobStatus ON jbsID = jobJobStatus 

 where ((jobSupervisor= -1.00000000 or jobCoordinator= -1.00000000 ) OR 1=1 ) 

 and 
 (
 (jobjobStatus=0 OR (0=0 AND 0=0)) 
 AND (jbsType=0 OR (0=0 AND 0=0)) 
 AND (jobPriority=0 OR (0=0 AND 0=0)) 
 AND (jobEventID=0 OR (0=0 AND 0=0))
 AND (jobSiteCode='' OR (''='' AND ''=''))
 AND (jobjobStatus IN (
 select jbsid from djobstatusgroupmapping where jsgid = 0
 ) 
 OR (0=0 AND 0=0))
 AND jobDateCreated BETWEEN '2004-06-10' AND '2014-06-10' AND jobBookedDate BETWEEN '1901-01-01 00:00:00' AND '2024-06-10 23:59:00' 
 and
 (('ABCDEFG12345'<>'' 
 AND
 ( 
 (1 = 1 AND 
 (
 jobWorkOrderNo like '%ABCDEFG12345%' OR
 jobSiteName like '%ABCDEFG12345%' OR
 jobSiteLocationBuilding like '%ABCDEFG12345%' OR
 jobSiteAddress like '%ABCDEFG12345%' OR
 jobSiteSuburb like '%ABCDEFG12345%' OR
 jobSitePostcode like '%ABCDEFG12345%' OR
 jobWorkToDo like '%ABCDEFG12345%' OR
 jobSiteClient like '%ABCDEFG12345%' OR
 jobSiteContact like '%ABCDEFG12345%' OR
 jobSiteContactPhone like '%ABCDEFG12345%' OR
 jobSiteContactPhone2 like '%ABCDEFG12345%'
 )
 ) 
 OR 
 (1 = 1 AND 
 (
 cltClientName like '%ABCDEFG12345%' OR
 cltDivision like '%ABCDEFG12345%' OR
 cltAddress1 like '%ABCDEFG12345%' OR
 cltAddress2 like '%ABCDEFG12345%' OR
 rtrim(cltAddress1)+' '+rtrim(cltAddress2) like '%ABCDEFG12345%' OR
 cltSuburb like '%ABCDEFG12345%' OR
 cltPostCode like '%ABCDEFG12345%' OR
 cltState like '%ABCDEFG12345%' OR
 cltTelephone like '%ABCDEFG12345%' OR
 cltContact like '%ABCDEFG12345%' OR
 cltMobile like '%ABCDEFG12345%' OR
 cltEmail like '%ABCDEFG12345%'
 )
 ) 
 )
 ) 
 OR 'ABCDEFG12345'='') 
 ) --End Count
 ) as vRecCount, 
 jobID,
 jobWorkOrderNo,
 jobSequence, 
 jobSiteClient,
 jobSiteStreetNumber,
 jobSiteAddress,
 jobSiteSuburb,
 jobSiteState,
 jobSitePostcode, 
 jobDateofLoss,
 jobDateofLossTime,
 jobDateCreated,
 jobTargetDate,
 jobClientID, 
 jobPriority,
 jobJobStatus,
 jobEventID,
 regFullname,
 case 
 when (not jobSupervisor= -1.00000000 ) and jobCoordinator= -1.00000000 then 1 else 
 case when (jobSupervisor= -1.00000000 ) and (jobCoordinator=0) then 2 else 
 case when (jobSupervisor= -1.00000000 ) and (not jobCoordinator= -1.00000000 ) then 3 else 0
 end end end as 'Coordinator',
 jobSupervisor,
 jobBookedDate,
 " StatementType="SELECT" QueryHash="0x17B6113F9CBC68BB" QueryPlanHash="0x7B78942081E925E1">
- <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="4" MemoryGrant="4160" CachedPlanSize="232" CompileTime="533" CompileCPU="131" CompileMemory="4728">
- <RelOp AvgRowSize="376" EstimateCPU="0.00023522" EstimateIO="0.0112613" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="20" LogicalOp="Sort" NodeId="0" Parallel="false" PhysicalOp="Sort" EstimatedTotalSubtreeCost="9.42273">
- <OutputList>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobID" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobWorkOrderNo" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobDateofLoss" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobDateofLossTime" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobClientID" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobDateCreated" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobPriority" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteStreetNumber" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteAddress" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteSuburb" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteState" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSitePostcode" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteClient" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteContact" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteContactPhone2" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobTargetDate" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobJobStatus" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSupervisor" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobEventID" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSequence" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobLat" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobLong" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobBookedDate" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobBooked" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobClaimAssistRequest" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobPCM" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dUsers]" Column="regFullName" />
- <ColumnReference Column="Expr1027" />
- <ColumnReference Column="Expr1028" />
- </OutputList>
- <MemoryFractions Input="0.8" Output="1" />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRebinds="1" ActualRewinds="0" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <Sort Distinct="false">
- <OrderBy>
- <OrderByColumn Ascending="false">
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobID" />
- </OrderByColumn>
- </OrderBy>
- <RelOp AvgRowSize="376" EstimateCPU="2E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="20" LogicalOp="Compute Scalar" NodeId="1" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="9.41123">
- <OutputList>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobID" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobWorkOrderNo" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobDateofLoss" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobDateofLossTime" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobClientID" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobDateCreated" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobPriority" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteStreetNumber" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteAddress" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteSuburb" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteState" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSitePostcode" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteClient" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteContact" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteContactPhone2" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobTargetDate" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobJobStatus" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSupervisor" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobEventID" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSequence" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobLat" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobLong" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobBookedDate" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobBooked" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobClaimAssistRequest" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobPCM" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dUsers]" Column="regFullName" />
- <ColumnReference Column="Expr1027" />
- <ColumnReference Column="Expr1028" />
- </OutputList>
- <ComputeScalar>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1027" />
- <ScalarOperator ScalarString="[Expr1025]">
- <Identifier>
- <ColumnReference Column="Expr1025" />
- </Identifier>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="376" EstimateCPU="0.00023522" EstimateIO="0.0112613" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="20" LogicalOp="TopN Sort" NodeId="2" Parallel="false" PhysicalOp="Sort" EstimatedTotalSubtreeCost="9.41123">
- <OutputList>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobID" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobWorkOrderNo" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobDateofLoss" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobDateofLossTime" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobClientID" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobDateCreated" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobPriority" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteStreetNumber" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteAddress" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteSuburb" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteState" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSitePostcode" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteClient" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteContact" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteContactPhone2" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobTargetDate" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobJobStatus" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSupervisor" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobEventID" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSequence" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobLat" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobLong" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobBookedDate" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobBooked" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobClaimAssistRequest" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobPCM" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dUsers]" Column="regFullName" />
- <ColumnReference Column="Expr1025" />
- <ColumnReference Column="Expr1028" />
- </OutputList>
- <MemoryFractions Input="1" Output="0.2" />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRebinds="1" ActualRewinds="0" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <TopSort Distinct="false" Rows="20">
- <OrderBy>
- <OrderByColumn Ascending="true">
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobID" />
- </OrderByColumn>
- </OrderBy>
- <RelOp AvgRowSize="376" EstimateCPU="2E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="20" LogicalOp="Top" NodeId="3" Parallel="false" PhysicalOp="Top" EstimatedTotalSubtreeCost="9.39973">
- <OutputList>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobID" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobWorkOrderNo" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobDateofLoss" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobDateofLossTime" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobClientID" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobDateCreated" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobPriority" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteStreetNumber" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteAddress" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteSuburb" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteState" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSitePostcode" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteClient" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteContact" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteContactPhone2" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobTargetDate" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobJobStatus" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSupervisor" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobEventID" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSequence" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobLat" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobLong" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobBookedDate" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobBooked" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobClaimAssistRequest" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobPCM" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dUsers]" Column="regFullName" />
- <ColumnReference Column="Expr1025" />
- <ColumnReference Column="Expr1028" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <Top RowCount="false" IsPercent="false" WithTies="false">
- <TopExpression>
- <ScalarOperator ScalarString="(20)">
- <Const ConstValue="(20)" />
- </ScalarOperator>
- </TopExpression>
- <RelOp AvgRowSize="376" EstimateCPU="0.0893377" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="20" LogicalOp="Inner Join" NodeId="4" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="9.39973">
- <OutputList>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobID" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobWorkOrderNo" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobDateofLoss" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobDateofLossTime" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobClientID" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobDateCreated" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobPriority" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteStreetNumber" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteAddress" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteSuburb" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteState" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSitePostcode" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteClient" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteContact" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteContactPhone2" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobTargetDate" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobJobStatus" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSupervisor" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobEventID" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSequence" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobLat" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobLong" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobBookedDate" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobBooked" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobClaimAssistRequest" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobPCM" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dUsers]" Column="regFullName" />
- <ColumnReference Column="Expr1025" />
- <ColumnReference Column="Expr1028" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <NestedLoops Optimized="false">
- <RelOp AvgRowSize="11" EstimateCPU="1E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Compute Scalar" NodeId="6" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="9.27953">
- <OutputList>
- <ColumnReference Column="Expr1025" />
- </OutputList>
- <ComputeScalar>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1025" />
- <ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[globalagg1033],0)">
- <Convert DataType="int" Style="0" Implicit="true">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="globalagg1033" />
- </Identifier>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="15" EstimateCPU="1.7E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Aggregate" NodeId="7" Parallel="false" PhysicalOp="Stream Aggregate" EstimatedTotalSubtreeCost="9.27953">
- <OutputList>
- <ColumnReference Column="globalagg1033" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="0" ActualExecutions="1" />
- </RunTimeInformation>
- <StreamAggregate>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="globalagg1033" />
- <ScalarOperator ScalarString="SUM([partialagg1032])">
- <Aggregate AggType="SUM" Distinct="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="partialagg1032" />
- </Identifier>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="15" EstimateCPU="0.0285021" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="2" LogicalOp="Gather Streams" NodeId="8" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="9.27953">
- <OutputList>
- <ColumnReference Column="partialagg1032" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <Parallelism>
- <RelOp AvgRowSize="15" EstimateCPU="0.00573712" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="2" LogicalOp="Aggregate" NodeId="9" Parallel="true" PhysicalOp="Stream Aggregate" EstimatedTotalSubtreeCost="9.25103">
- <OutputList>
- <ColumnReference Column="partialagg1032" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="4" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="2" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="1" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="3" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <StreamAggregate>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="partialagg1032" />
- <ScalarOperator ScalarString="Count(*)">
- <Aggregate AggType="countstar" Distinct="false" />
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="9" EstimateCPU="0.417531" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="19122.1" LogicalOp="Filter" NodeId="10" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="9.24529">
- <OutputList />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="4" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="2" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="1" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="3" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <Filter StartupExpression="false">
- <RelOp AvgRowSize="762" EstimateCPU="0.00254903" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="50980.6" LogicalOp="Compute Scalar" NodeId="11" Parallel="true" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="8.82776">
- <OutputList>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobWorkOrderNo" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteName" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteLocationBuilding" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteAddress" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteSuburb" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSitePostcode" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobWorkToDo" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteClient" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteContact" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteContactPhone" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteContactPhone2" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltClientName" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltDivision" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltAddress1" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltAddress2" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltSuburb" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltPostcode" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltState" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltTelephone" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltContact" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltMobile" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltEmail" />
- <ColumnReference Column="Expr1031" />
- </OutputList>
- <ComputeScalar>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1031" />
- <ScalarOperator ScalarString="(rtrim([ExampleApp20140408].[dbo].[dClients].[cltAddress1])+N' ')+rtrim([ExampleApp20140408].[dbo].[dClients].[cltAddress2])">
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Intrinsic FunctionName="rtrim">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltAddress1" />
- </Identifier>
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N' '" />
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- <ScalarOperator>
- <Intrinsic FunctionName="rtrim">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltAddress2" />
- </Identifier>
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="559" EstimateCPU="0.222556" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="50980.6" LogicalOp="Right Outer Join" NodeId="12" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="8.82521">
- <OutputList>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobWorkOrderNo" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteName" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteLocationBuilding" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteAddress" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteSuburb" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSitePostcode" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobWorkToDo" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteClient" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteContact" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteContactPhone" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteContactPhone2" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltClientName" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltDivision" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltAddress1" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltAddress2" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltSuburb" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltPostcode" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltState" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltTelephone" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltContact" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltMobile" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltEmail" />
- </OutputList>
- <MemoryFractions Input="0" Output="0" />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="4" ActualRows="10449" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="2" ActualRows="9197" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="1" ActualRows="16032" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="3" ActualRows="15375" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <Hash>
- <DefinedValues />
- <HashKeysBuild>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltClientID" />
- </HashKeysBuild>
- <HashKeysProbe>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobClientID" />
- </HashKeysProbe>
- <RelOp AvgRowSize="305" EstimateCPU="0.0302308" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="63" LogicalOp="Distribute Streams" NodeId="13" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="0.0409895">
- <OutputList>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltClientID" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltClientName" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltDivision" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltAddress1" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltAddress2" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltSuburb" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltPostcode" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltState" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltTelephone" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltContact" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltMobile" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltEmail" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="4" ActualRows="63" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="2" ActualRows="63" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="1" ActualRows="63" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="3" ActualRows="63" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <Parallelism PartitioningType="Broadcast">
- <RelOp AvgRowSize="305" EstimateCPU="0.0002263" EstimateIO="0.0105324" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="63" LogicalOp="Table Scan" NodeId="14" Parallel="false" PhysicalOp="Table Scan" EstimatedTotalSubtreeCost="0.0107587" TableCardinality="63">
- <OutputList>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltClientID" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltClientName" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltDivision" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltAddress1" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltAddress2" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltSuburb" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltPostcode" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltState" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltTelephone" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltContact" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltMobile" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltEmail" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="1" ActualRows="63" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <TableScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltClientID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltClientName" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltDivision" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltAddress1" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltAddress2" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltSuburb" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltPostcode" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltState" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltTelephone" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltContact" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltMobile" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltEmail" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" TableReferenceId="2" IndexKind="Heap" />
- </TableScan>
- </RelOp>
- </Parallelism>
- </RelOp>
- <RelOp AvgRowSize="287" EstimateCPU="0.0281604" EstimateIO="8.49572" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="50980.6" LogicalOp="Clustered Index Scan" NodeId="15" Parallel="true" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="8.52388" TableCardinality="51058">
- <OutputList>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobWorkOrderNo" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobClientID" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteName" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteLocationBuilding" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteAddress" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteSuburb" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSitePostcode" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobWorkToDo" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteClient" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteContact" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteContactPhone" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteContactPhone2" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="4" ActualRows="10449" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="2" ActualRows="9197" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="1" ActualRows="16032" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="3" ActualRows="15375" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <IndexScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobWorkOrderNo" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobClientID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteName" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteLocationBuilding" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteAddress" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteSuburb" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSitePostcode" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobWorkToDo" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteClient" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteContact" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteContactPhone" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteContactPhone2" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Index="[_dta_index_dJobs_c_10_1453248232__K1D]" TableReferenceId="2" IndexKind="Clustered" />
- <Predicate>
- <ScalarOperator ScalarString="[ExampleApp20140408].[dbo].[dJobs].[jobDateCreated]>='2004-06-10 00:00:00.000' AND [ExampleApp20140408].[dbo].[dJobs].[jobDateCreated]<='2014-06-10 00:00:00.000' AND [ExampleApp20140408].[dbo].[dJobs].[jobBookedDate]>='1901-01-01 00:00:00.000' AND [ExampleApp20140408].[dbo].[dJobs].[jobBookedDate]<='2024-06-10 23:59:00.000'">
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="GE">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobDateCreated" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="'2004-06-10 00:00:00.000'" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="LE">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobDateCreated" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="'2014-06-10 00:00:00.000'" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="GE">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobBookedDate" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="'1901-01-01 00:00:00.000'" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="LE">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobBookedDate" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="'2024-06-10 23:59:00.000'" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Predicate>
- </IndexScan>
- </RelOp>
- </Hash>
- </RelOp>
- </ComputeScalar>
- </RelOp>
- <Predicate>
- <ScalarOperator ScalarString="[ExampleApp20140408].[dbo].[dJobs].[jobWorkOrderNo] like N'%ABCDEFG12345%' OR [ExampleApp20140408].[dbo].[dJobs].[jobSiteName] like N'%ABCDEFG12345%' OR [ExampleApp20140408].[dbo].[dJobs].[jobSiteLocationBuilding] like N'%ABCDEFG12345%' OR [ExampleApp20140408].[dbo].[dJobs].[jobSiteAddress] like N'%ABCDEFG12345%' OR [ExampleApp20140408].[dbo].[dJobs].[jobSiteSuburb] like N'%ABCDEFG12345%' OR [ExampleApp20140408].[dbo].[dJobs].[jobSitePostcode] like '%ABCDEFG12345%' OR [ExampleApp20140408].[dbo].[dJobs].[jobWorkToDo] like N'%ABCDEFG12345%' OR [ExampleApp20140408].[dbo].[dJobs].[jobSiteClient] like N'%ABCDEFG12345%' OR [ExampleApp20140408].[dbo].[dJobs].[jobSiteContact] like N'%ABCDEFG12345%' OR [ExampleApp20140408].[dbo].[dJobs].[jobSiteContactPhone] like N'%ABCDEFG12345%' OR [ExampleApp20140408].[dbo].[dJobs].[jobSiteContactPhone2] like N'%ABCDEFG12345%' OR [ExampleApp20140408].[dbo].[dClients].[cltClientName] like N'%ABCDEFG12345%' OR [ExampleApp20140408].[dbo].[dClients].[cltDivision] like N'%ABCDEFG12345%' OR [ExampleApp20140408].[dbo].[dClients].[cltAddress1] like N'%ABCDEFG12345%' OR [ExampleApp20140408].[dbo].[dClients].[cltAddress2] like N'%ABCDEFG12345%' OR [Expr1031] like N'%ABCDEFG12345%' OR [ExampleApp20140408].[dbo].[dClients].[cltSuburb] like N'%ABCDEFG12345%' OR [ExampleApp20140408].[dbo].[dClients].[cltPostcode] like N'%ABCDEFG12345%' OR [ExampleApp20140408].[dbo].[dClients].[cltState] like '%ABCDEFG12345%' OR [ExampleApp20140408].[dbo].[dClients].[cltTelephone] like '%ABCDEFG12345%' OR [ExampleApp20140408].[dbo].[dClients].[cltContact] like N'%ABCDEFG12345%' OR [ExampleApp20140408].[dbo].[dClients].[cltMobile] like '%ABCDEFG12345%' OR [ExampleApp20140408].[dbo].[dClients].[cltEmail] like '%ABCDEFG12345%'">
- <Logical Operation="OR">
- <ScalarOperator>
- <Intrinsic FunctionName="like">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobWorkOrderNo" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'%ABCDEFG12345%'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Intrinsic FunctionName="like">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteName" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'%ABCDEFG12345%'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Intrinsic FunctionName="like">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteLocationBuilding" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'%ABCDEFG12345%'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Intrinsic FunctionName="like">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteAddress" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'%ABCDEFG12345%'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Intrinsic FunctionName="like">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteSuburb" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'%ABCDEFG12345%'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Intrinsic FunctionName="like">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSitePostcode" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="'%ABCDEFG12345%'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Intrinsic FunctionName="like">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobWorkToDo" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'%ABCDEFG12345%'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Intrinsic FunctionName="like">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteClient" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'%ABCDEFG12345%'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Intrinsic FunctionName="like">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteContact" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'%ABCDEFG12345%'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Intrinsic FunctionName="like">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteContactPhone" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'%ABCDEFG12345%'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Intrinsic FunctionName="like">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteContactPhone2" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'%ABCDEFG12345%'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Intrinsic FunctionName="like">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltClientName" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'%ABCDEFG12345%'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Intrinsic FunctionName="like">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltDivision" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'%ABCDEFG12345%'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Intrinsic FunctionName="like">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltAddress1" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'%ABCDEFG12345%'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Intrinsic FunctionName="like">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltAddress2" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'%ABCDEFG12345%'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Intrinsic FunctionName="like">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Expr1031" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'%ABCDEFG12345%'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Intrinsic FunctionName="like">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltSuburb" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'%ABCDEFG12345%'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Intrinsic FunctionName="like">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltPostcode" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'%ABCDEFG12345%'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Intrinsic FunctionName="like">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltState" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="'%ABCDEFG12345%'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Intrinsic FunctionName="like">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltTelephone" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="'%ABCDEFG12345%'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Intrinsic FunctionName="like">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltContact" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'%ABCDEFG12345%'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Intrinsic FunctionName="like">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltMobile" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="'%ABCDEFG12345%'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Intrinsic FunctionName="like">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltEmail" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="'%ABCDEFG12345%'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Predicate>
- </Filter>
- </RelOp>
- </StreamAggregate>
- </RelOp>
- </Parallelism>
- </RelOp>
- </StreamAggregate>
- </RelOp>
- </ComputeScalar>
- </RelOp>
- <RelOp AvgRowSize="372" EstimateCPU="0.0290231" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="20" LogicalOp="Gather Streams" NodeId="29" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="0.120117">
- <OutputList>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobID" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobWorkOrderNo" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobDateofLoss" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobDateofLossTime" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobClientID" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobDateCreated" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobPriority" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteStreetNumber" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteAddress" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteSuburb" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteState" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSitePostcode" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteClient" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteContact" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteContactPhone2" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobTargetDate" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobJobStatus" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSupervisor" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobEventID" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSequence" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobLat" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobLong" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobBookedDate" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobBooked" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobClaimAssistRequest" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobPCM" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dUsers]" Column="regFullName" />
- <ColumnReference Column="Expr1028" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <Parallelism>
- <OrderBy>
- <OrderByColumn Ascending="false">
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobID" />
- </OrderByColumn>
- </OrderBy>
- <RelOp AvgRowSize="372" EstimateCPU="0.0446688" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="20" LogicalOp="Left Outer Join" NodeId="30" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0910942">
- <OutputList>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobID" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobWorkOrderNo" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobDateofLoss" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobDateofLossTime" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobClientID" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobDateCreated" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobPriority" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteStreetNumber" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteAddress" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteSuburb" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteState" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSitePostcode" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteClient" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteContact" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteContactPhone2" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobTargetDate" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobJobStatus" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSupervisor" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobEventID" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSequence" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobLat" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobLong" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobBookedDate" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobBooked" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobClaimAssistRequest" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobPCM" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dUsers]" Column="regFullName" />
- <ColumnReference Column="Expr1028" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="2" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="1" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="4" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="3" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <NestedLoops Optimized="false" WithOrderedPrefetch="true">
- <OuterReferences>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobCoOrdinator" />
- <ColumnReference Column="Expr1036" />
- </OuterReferences>
- <RelOp AvgRowSize="273" EstimateCPU="0.435374" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="20" LogicalOp="Filter" NodeId="32" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="0.0361739">
- <OutputList>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobID" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobWorkOrderNo" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobDateofLoss" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobDateofLossTime" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobClientID" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobDateCreated" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobPriority" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteStreetNumber" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteAddress" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteSuburb" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteState" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSitePostcode" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteClient" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteContact" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteContactPhone2" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobTargetDate" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobJobStatus" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSupervisor" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobEventID" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSequence" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobLat" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobLong" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobCoOrdinator" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobBookedDate" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobBooked" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobClaimAssistRequest" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobPCM" />
- <ColumnReference Column="Expr1028" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="2" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="4" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="1" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="3" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <Filter StartupExpression="false">
- <RelOp AvgRowSize="980" EstimateCPU="0.00254903" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="47.7064" LogicalOp="Compute Scalar" NodeId="33" Parallel="true" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.0357665">
- <OutputList>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobID" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobWorkOrderNo" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobDateofLoss" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobDateofLossTime" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobClientID" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobDateCreated" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobPriority" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteName" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteLocationBuilding" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteStreetNumber" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteAddress" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteSuburb" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteState" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSitePostcode" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobWorkToDo" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteClient" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteContact" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteContactPhone" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteContactPhone2" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobTargetDate" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobJobStatus" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSupervisor" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobEventID" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSequence" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobLat" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobLong" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobCoOrdinator" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobBookedDate" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobBooked" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobClaimAssistRequest" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobPCM" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltClientName" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltDivision" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltAddress1" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltAddress2" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltSuburb" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltPostcode" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltState" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltTelephone" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltContact" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltMobile" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltEmail" />
- <ColumnReference Column="Expr1028" />
- <ColumnReference Column="Expr1029" />
- <ColumnReference Column="Expr1030" />
- </OutputList>
- <ComputeScalar>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1030" />
- <ScalarOperator ScalarString="(rtrim([ExampleApp20140408].[dbo].[dClients].[cltAddress1])+N' ')+rtrim([ExampleApp20140408].[dbo].[dClients].[cltAddress2])">
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Intrinsic FunctionName="rtrim">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltAddress1" />
- </Identifier>
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N' '" />
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- <ScalarOperator>
- <Intrinsic FunctionName="rtrim">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltAddress2" />
- </Identifier>
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="777" EstimateCPU="6.71262" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="47.7064" LogicalOp="Left Outer Join" NodeId="34" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0357641">
- <OutputList>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobID" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobWorkOrderNo" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobDateofLoss" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobDateofLossTime" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobClientID" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobDateCreated" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobPriority" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteName" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteLocationBuilding" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteStreetNumber" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteAddress" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteSuburb" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteState" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSitePostcode" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobWorkToDo" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteClient" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteContact" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteContactPhone" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteContactPhone2" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobTargetDate" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobJobStatus" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSupervisor" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobEventID" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSequence" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobLat" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobLong" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobCoOrdinator" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobBookedDate" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobBooked" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobClaimAssistRequest" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobPCM" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltClientName" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltDivision" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltAddress1" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltAddress2" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltSuburb" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltPostcode" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltState" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltTelephone" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltContact" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltMobile" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltEmail" />
- <ColumnReference Column="Expr1028" />
- <ColumnReference Column="Expr1029" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="4" ActualRows="12731" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="1" ActualRows="13556" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="3" ActualRows="12141" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="2" ActualRows="12625" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <NestedLoops Optimized="false">
- <Predicate>
- <ScalarOperator ScalarString="[ExampleApp20140408].[dbo].[dClients].[cltClientID]=[ExampleApp20140408].[dbo].[dJobs].[jobClientID]">
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltClientID" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobClientID" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Predicate>
- <RelOp AvgRowSize="485" EstimateCPU="0.00254903" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="47.7064" LogicalOp="Compute Scalar" NodeId="35" Parallel="true" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.0110485">
- <OutputList>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobID" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobWorkOrderNo" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobDateofLoss" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobDateofLossTime" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobClientID" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobDateCreated" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobPriority" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteName" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteLocationBuilding" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteStreetNumber" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteAddress" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteSuburb" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteState" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSitePostcode" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobWorkToDo" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteClient" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteContact" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteContactPhone" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteContactPhone2" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobTargetDate" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobJobStatus" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSupervisor" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobEventID" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSequence" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobLat" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobLong" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobCoOrdinator" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobBookedDate" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobBooked" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobClaimAssistRequest" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobPCM" />
- <ColumnReference Column="Expr1028" />
- <ColumnReference Column="Expr1029" />
- </OutputList>
- <ComputeScalar>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1028" />
- <ScalarOperator ScalarString="CASE WHEN [ExampleApp20140408].[dbo].[dJobs].[jobSupervisor]<>(-1.00000000) AND [ExampleApp20140408].[dbo].[dJobs].[jobCoOrdinator]=(-1.00000000) THEN (1) ELSE CASE WHEN [ExampleApp20140408].[dbo].[dJobs].[jobSupervisor]=(-1.00000000) AND [ExampleApp20140408].[dbo].[dJobs].[jobCoOrdinator]=(0) THEN (2) ELSE CASE WHEN [ExampleApp20140408].[dbo].[dJobs].[jobSupervisor]=(-1.00000000) AND [ExampleApp20140408].[dbo].[dJobs].[jobCoOrdinator]<>(-1.00000000) THEN (3) ELSE (0) END END END">
- <IF>
- <Condition>
- <ScalarOperator>
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="NE">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSupervisor" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(-1.00000000)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobCoOrdinator" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(-1.00000000)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Condition>
- <Then>
- <ScalarOperator>
- <Const ConstValue="(1)" />
- </ScalarOperator>
- </Then>
- <Else>
- <ScalarOperator>
- <IF>
- <Condition>
- <ScalarOperator>
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSupervisor" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(-1.00000000)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobCoOrdinator" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(0)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Condition>
- <Then>
- <ScalarOperator>
- <Const ConstValue="(2)" />
- </ScalarOperator>
- </Then>
- <Else>
- <ScalarOperator>
- <IF>
- <Condition>
- <ScalarOperator>
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSupervisor" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(-1.00000000)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="NE">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobCoOrdinator" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(-1.00000000)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Condition>
- <Then>
- <ScalarOperator>
- <Const ConstValue="(3)" />
- </ScalarOperator>
- </Then>
- <Else>
- <ScalarOperator>
- <Const ConstValue="(0)" />
- </ScalarOperator>
- </Else>
- </IF>
- </ScalarOperator>
- </Else>
- </IF>
- </ScalarOperator>
- </Else>
- </IF>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1029" />
- <ScalarOperator ScalarString="CONVERT_IMPLICIT(nvarchar(11),rtrim([ExampleApp20140408].[dbo].[dJobs].[jobSiteStreetNumber])+' ',0)+rtrim([ExampleApp20140408].[dbo].[dJobs].[jobSiteAddress])">
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Convert DataType="nvarchar" Length="22" Style="0" Implicit="true">
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Intrinsic FunctionName="rtrim">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteStreetNumber" />
- </Identifier>
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="' '" />
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- <ScalarOperator>
- <Intrinsic FunctionName="rtrim">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteAddress" />
- </Identifier>
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="367" EstimateCPU="0.0281604" EstimateIO="8.49572" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="47.7064" LogicalOp="Clustered Index Scan" NodeId="36" Parallel="true" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0110108" TableCardinality="51058">
- <OutputList>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobID" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobWorkOrderNo" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobDateofLoss" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobDateofLossTime" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobClientID" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobDateCreated" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobPriority" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteName" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteLocationBuilding" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteStreetNumber" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteAddress" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteSuburb" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteState" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSitePostcode" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobWorkToDo" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteClient" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteContact" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteContactPhone" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteContactPhone2" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobTargetDate" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobJobStatus" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSupervisor" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobEventID" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSequence" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobLat" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobLong" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobCoOrdinator" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobBookedDate" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobBooked" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobClaimAssistRequest" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobPCM" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="4" ActualRows="12731" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="1" ActualRows="13556" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="3" ActualRows="12141" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="2" ActualRows="12625" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobWorkOrderNo" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobDateofLoss" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobDateofLossTime" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobClientID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobDateCreated" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobPriority" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteName" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteLocationBuilding" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteStreetNumber" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteAddress" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteSuburb" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteState" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSitePostcode" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobWorkToDo" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteClient" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteContact" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteContactPhone" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteContactPhone2" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobTargetDate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobJobStatus" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSupervisor" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobEventID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSequence" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobLat" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobLong" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobCoOrdinator" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobBookedDate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobBooked" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobClaimAssistRequest" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobPCM" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Index="[_dta_index_dJobs_c_10_1453248232__K1D]" TableReferenceId="1" IndexKind="Clustered" />
- <Predicate>
- <ScalarOperator ScalarString="[ExampleApp20140408].[dbo].[dJobs].[jobDateCreated]>='2004-06-10 00:00:00.000' AND [ExampleApp20140408].[dbo].[dJobs].[jobDateCreated]<='2014-06-10 00:00:00.000' AND [ExampleApp20140408].[dbo].[dJobs].[jobBookedDate]>='1901-01-01 00:00:00.000' AND [ExampleApp20140408].[dbo].[dJobs].[jobBookedDate]<='2024-06-10 23:59:00.000'">
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="GE">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobDateCreated" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="'2004-06-10 00:00:00.000'" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="LE">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobDateCreated" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="'2014-06-10 00:00:00.000'" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="GE">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobBookedDate" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="'1901-01-01 00:00:00.000'" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="LE">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobBookedDate" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="'2024-06-10 23:59:00.000'" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Predicate>
- </IndexScan>
- </RelOp>
- </ComputeScalar>
- </RelOp>
- <RelOp AvgRowSize="305" EstimateCPU="0.0001478" EstimateIO="0.0106109" EstimateRebinds="0" EstimateRewinds="47.7058" EstimateRows="63" LogicalOp="Table Scan" NodeId="42" Parallel="true" PhysicalOp="Table Scan" EstimatedTotalSubtreeCost="0.0178096" TableCardinality="63">
- <OutputList>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltClientID" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltClientName" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltDivision" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltAddress1" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltAddress2" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltSuburb" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltPostcode" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltState" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltTelephone" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltContact" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltMobile" />
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltEmail" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="4" ActualRows="802053" ActualEndOfScans="12731" ActualExecutions="12731" />
- <RunTimeCountersPerThread Thread="1" ActualRows="854028" ActualEndOfScans="13556" ActualExecutions="13556" />
- <RunTimeCountersPerThread Thread="3" ActualRows="764883" ActualEndOfScans="12141" ActualExecutions="12141" />
- <RunTimeCountersPerThread Thread="2" ActualRows="795375" ActualEndOfScans="12625" ActualExecutions="12625" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <TableScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltClientID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltClientName" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltDivision" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltAddress1" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltAddress2" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltSuburb" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltPostcode" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltState" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltTelephone" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltContact" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltMobile" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltEmail" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" TableReferenceId="1" IndexKind="Heap" />
- </TableScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- </ComputeScalar>
- </RelOp>
- <Predicate>
- <ScalarOperator ScalarString="[ExampleApp20140408].[dbo].[dJobs].[jobWorkOrderNo] like N'%ABCDEFG12345%' OR [ExampleApp20140408].[dbo].[dJobs].[jobSiteName] like N'%ABCDEFG12345%' OR [ExampleApp20140408].[dbo].[dJobs].[jobSiteLocationBuilding] like N'%ABCDEFG12345%' OR [ExampleApp20140408].[dbo].[dJobs].[jobSiteAddress] like N'%ABCDEFG12345%' OR [Expr1029] like N'%ABCDEFG12345%' OR [ExampleApp20140408].[dbo].[dJobs].[jobSiteSuburb] like N'%ABCDEFG12345%' OR [ExampleApp20140408].[dbo].[dJobs].[jobSitePostcode] like '%ABCDEFG12345%' OR [ExampleApp20140408].[dbo].[dJobs].[jobWorkToDo] like N'%ABCDEFG12345%' OR [ExampleApp20140408].[dbo].[dJobs].[jobSiteClient] like N'%ABCDEFG12345%' OR [ExampleApp20140408].[dbo].[dJobs].[jobSiteContact] like N'%ABCDEFG12345%' OR [ExampleApp20140408].[dbo].[dJobs].[jobSiteContactPhone] like N'%ABCDEFG12345%' OR [ExampleApp20140408].[dbo].[dJobs].[jobSiteContactPhone2] like N'%ABCDEFG12345%' OR [ExampleApp20140408].[dbo].[dClients].[cltClientName] like N'%ABCDEFG12345%' OR [ExampleApp20140408].[dbo].[dClients].[cltDivision] like N'%ABCDEFG12345%' OR [ExampleApp20140408].[dbo].[dClients].[cltAddress1] like N'%ABCDEFG12345%' OR [ExampleApp20140408].[dbo].[dClients].[cltAddress2] like N'%ABCDEFG12345%' OR [Expr1030] like N'%ABCDEFG12345%' OR [ExampleApp20140408].[dbo].[dClients].[cltSuburb] like N'%ABCDEFG12345%' OR [ExampleApp20140408].[dbo].[dClients].[cltPostcode] like N'%ABCDEFG12345%' OR [ExampleApp20140408].[dbo].[dClients].[cltState] like '%ABCDEFG12345%' OR [ExampleApp20140408].[dbo].[dClients].[cltTelephone] like '%ABCDEFG12345%' OR [ExampleApp20140408].[dbo].[dClients].[cltContact] like N'%ABCDEFG12345%' OR [ExampleApp20140408].[dbo].[dClients].[cltMobile] like '%ABCDEFG12345%' OR [ExampleApp20140408].[dbo].[dClients].[cltEmail] like '%ABCDEFG12345%'">
- <Logical Operation="OR">
- <ScalarOperator>
- <Intrinsic FunctionName="like">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobWorkOrderNo" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'%ABCDEFG12345%'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Intrinsic FunctionName="like">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteName" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'%ABCDEFG12345%'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Intrinsic FunctionName="like">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteLocationBuilding" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'%ABCDEFG12345%'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Intrinsic FunctionName="like">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteAddress" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'%ABCDEFG12345%'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Intrinsic FunctionName="like">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Expr1029" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'%ABCDEFG12345%'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Intrinsic FunctionName="like">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteSuburb" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'%ABCDEFG12345%'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Intrinsic FunctionName="like">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSitePostcode" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="'%ABCDEFG12345%'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Intrinsic FunctionName="like">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobWorkToDo" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'%ABCDEFG12345%'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Intrinsic FunctionName="like">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteClient" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'%ABCDEFG12345%'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Intrinsic FunctionName="like">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteContact" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'%ABCDEFG12345%'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Intrinsic FunctionName="like">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteContactPhone" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'%ABCDEFG12345%'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Intrinsic FunctionName="like">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobSiteContactPhone2" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'%ABCDEFG12345%'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Intrinsic FunctionName="like">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltClientName" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'%ABCDEFG12345%'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Intrinsic FunctionName="like">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltDivision" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'%ABCDEFG12345%'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Intrinsic FunctionName="like">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltAddress1" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'%ABCDEFG12345%'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Intrinsic FunctionName="like">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltAddress2" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'%ABCDEFG12345%'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Intrinsic FunctionName="like">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Expr1030" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'%ABCDEFG12345%'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Intrinsic FunctionName="like">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltSuburb" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'%ABCDEFG12345%'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Intrinsic FunctionName="like">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltPostcode" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'%ABCDEFG12345%'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Intrinsic FunctionName="like">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltState" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="'%ABCDEFG12345%'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Intrinsic FunctionName="like">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltTelephone" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="'%ABCDEFG12345%'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Intrinsic FunctionName="like">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltContact" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'%ABCDEFG12345%'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Intrinsic FunctionName="like">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltMobile" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="'%ABCDEFG12345%'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Intrinsic FunctionName="like">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dClients]" Column="cltEmail" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="'%ABCDEFG12345%'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Predicate>
- </Filter>
- </RelOp>
- <RelOp AvgRowSize="112" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="19.0674" EstimateRewinds="0.932032" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="48" Parallel="true" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0548788" TableCardinality="4772">
- <OutputList>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dUsers]" Column="regFullName" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="2" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- <RunTimeCountersPerThread Thread="1" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- <RunTimeCountersPerThread Thread="4" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- <RunTimeCountersPerThread Thread="3" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dUsers]" Column="regFullName" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dUsers]" Index="[dRegisteredUsers_id]" IndexKind="Clustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dUsers]" Column="regUserID" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[ExampleApp20140408].[dbo].[dJobs].[jobCoOrdinator]">
- <Identifier>
- <ColumnReference Database="[ExampleApp20140408]" Schema="[dbo]" Table="[dJobs]" Column="jobCoOrdinator" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- </Parallelism>
- </RelOp>
- </NestedLoops>
- </RelOp>
- </Top>
- </RelOp>
- </TopSort>
- </RelOp>
- </ComputeScalar>
- </RelOp>
- </Sort>
- </RelOp>
- </QueryPlan>
- </StmtSimple>
- </Statements>
- </Batch>
- </BatchSequence>
- </ShowPlanXML>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement