Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?xml version="1.0" encoding="utf-16"?>
- <ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.2" Build="11.0.3128.0">
- <BatchSequence>
- <Batch>
- <Statements>
- <StmtSimple StatementText="with results as(
SELECT
	 P.[patient_guid]
 ,P.[client_guid]
 ,P.[patient_account_id]
 ,C.[database_guid]
 ,P.[patient_name] 
 ,P.[rabies_tag_number]
 ,P.[rabies_serial_number]
 ,P.[rabies_brand_name]
 ,P.[species] 
 ,P.[breed] 
 ,P.[coat_color]
 ,P.[sex]
 ,P.[birthdate]
 ,P.[latest_visit]
 ,P.[first_visit]
 ,P.[maturity_code]
 ,P.[medical_alert]
 ,P.[chronic_ailment]
 ,P.[continuous_medication]
 ,P.[weight]
 ,P.[doctor_preference]
 ,P.[tattoo_number]
 ,P.[avid_chip_number]
 ,P.[comment]
 ,P.[special_instructions]
 ,P.[health_plan_name]
 ,P.[deleted]
 ,P.[has_lab_results]
	 ,P.[trainer_id]
	 ,P.[stable_id]
 ,C.[first_name]
 ,C.[last_name]
	 ,P.[active]
	 ,P.[deceased_date]
	 
 ,row_number() over (order by patient_name) as rownumber
	 ,row_number() over (order by patient_name DESC) as totalRows
 FROM [patients] P
 
 inner join clients C on P.client_guid = C.client_guid
 where C.database_guid = @DatabaseGuid and P.patient_name like '%'+@SearchText+'%')
 
 select patient_guid, client_guid, patient_account_id, database_guid, patient_name, rabies_tag_number, rabies_serial_number, rabies_brand_name, species, 
		 breed, coat_color, sex, birthdate, latest_visit, first_visit, maturity_code, medical_alert, chronic_ailment, continuous_medication, weight, 
		 doctor_preference, tattoo_number, avid_chip_number, comment, special_instructions, health_plan_name, deleted, has_lab_results, first_name, last_name, trainer_id, stable_id, active, deceased_date,
		 totalRows + rownumber - 1 as total from results where rownumber >= @PageSize * @PageNumber + 1 and rownumber <= @PageSize * @PageNumber + 1+ @PageSize - 1
		 ORDER BY patient_name ASC" StatementId="1" StatementCompId="6" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="183.584" StatementEstRows="9" StatementOptmLevel="FULL" QueryHash="0xA63F0396E69EE21D" QueryPlanHash="0x86A14A42D3808345">
- <StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="false" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false" />
- <QueryPlan DegreeOfParallelism="1" MemoryGrant="42360" CachedPlanSize="160" CompileTime="36" CompileCPU="36" CompileMemory="1192">
- <MemoryGrantInfo SerialRequiredMemory="1024" SerialDesiredMemory="42360" RequiredMemory="1024" DesiredMemory="42360" RequestedMemory="42360" GrantWaitTime="0" GrantedMemory="42360" MaxUsedMemory="624" />
- <OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="209690" EstimatedPagesCached="52422" EstimatedAvailableDegreeOfParallelism="2" />
- <RelOp NodeId="0" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="9" EstimateIO="0.0112613" EstimateCPU="0.000145042" AvgRowSize="536" EstimatedTotalSubtreeCost="183.584" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
- <OutputList>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="patient_guid" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="client_guid" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="patient_account_id" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="patient_name" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="rabies_tag_number" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="rabies_serial_number" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="rabies_brand_name" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="species" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="breed" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="coat_color" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="sex" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="birthdate" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="latest_visit" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="first_visit" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="maturity_code" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="medical_alert" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="chronic_ailment" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="continuous_medication" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="weight" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="doctor_preference" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="tattoo_number" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="avid_chip_number" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="comment" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="special_instructions" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="health_plan_name" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="deleted" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="has_lab_results" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="stable_id" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="trainer_id" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="deceased_date" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="active" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[clients]" Alias="[C]" Column="database_guid" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[clients]" Alias="[C]" Column="first_name" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[clients]" Alias="[C]" Column="last_name" />
- <ColumnReference Column="Expr1006" />
- </OutputList>
- <MemoryFractions Input="0.00246002" Output="1" />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="50" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <Sort Distinct="0">
- <OrderBy>
- <OrderByColumn Ascending="1">
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="patient_name" />
- </OrderByColumn>
- </OrderBy>
- <RelOp NodeId="1" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="9" EstimateIO="0" EstimateCPU="9e-007" AvgRowSize="536" EstimatedTotalSubtreeCost="183.573" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
- <OutputList>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="patient_guid" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="client_guid" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="patient_account_id" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="patient_name" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="rabies_tag_number" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="rabies_serial_number" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="rabies_brand_name" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="species" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="breed" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="coat_color" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="sex" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="birthdate" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="latest_visit" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="first_visit" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="maturity_code" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="medical_alert" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="chronic_ailment" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="continuous_medication" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="weight" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="doctor_preference" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="tattoo_number" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="avid_chip_number" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="comment" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="special_instructions" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="health_plan_name" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="deleted" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="has_lab_results" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="stable_id" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="trainer_id" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="deceased_date" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="active" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[clients]" Alias="[C]" Column="database_guid" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[clients]" Alias="[C]" Column="first_name" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[clients]" Alias="[C]" Column="last_name" />
- <ColumnReference Column="Expr1006" />
- </OutputList>
- <ComputeScalar>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1006" />
- <ScalarOperator ScalarString="[Expr1005]+[Expr1004]-(1)">
- <Arithmetic Operation="SUB">
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Expr1005" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Expr1004" />
- </Identifier>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(1)" />
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp NodeId="2" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="9" EstimateIO="0" EstimateCPU="8.8e-005" AvgRowSize="544" EstimatedTotalSubtreeCost="183.573" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
- <OutputList>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="patient_guid" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="client_guid" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="patient_account_id" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="patient_name" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="rabies_tag_number" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="rabies_serial_number" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="rabies_brand_name" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="species" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="breed" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="coat_color" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="sex" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="birthdate" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="latest_visit" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="first_visit" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="maturity_code" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="medical_alert" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="chronic_ailment" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="continuous_medication" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="weight" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="doctor_preference" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="tattoo_number" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="avid_chip_number" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="comment" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="special_instructions" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="health_plan_name" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="deleted" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="has_lab_results" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="stable_id" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="trainer_id" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="deceased_date" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="active" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[clients]" Alias="[C]" Column="database_guid" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[clients]" Alias="[C]" Column="first_name" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[clients]" Alias="[C]" Column="last_name" />
- <ColumnReference Column="Expr1004" />
- <ColumnReference Column="Expr1005" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="50" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <Filter StartupExpression="0">
- <RelOp NodeId="3" PhysicalOp="Top" LogicalOp="Top" EstimateRows="100" EstimateIO="0" EstimateCPU="1e-005" AvgRowSize="544" EstimatedTotalSubtreeCost="183.572" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
- <OutputList>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="patient_guid" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="client_guid" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="patient_account_id" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="patient_name" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="rabies_tag_number" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="rabies_serial_number" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="rabies_brand_name" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="species" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="breed" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="coat_color" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="sex" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="birthdate" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="latest_visit" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="first_visit" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="maturity_code" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="medical_alert" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="chronic_ailment" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="continuous_medication" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="weight" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="doctor_preference" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="tattoo_number" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="avid_chip_number" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="comment" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="special_instructions" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="health_plan_name" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="deleted" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="has_lab_results" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="stable_id" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="trainer_id" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="deceased_date" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="active" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[clients]" Alias="[C]" Column="database_guid" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[clients]" Alias="[C]" Column="first_name" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[clients]" Alias="[C]" Column="last_name" />
- <ColumnReference Column="Expr1004" />
- <ColumnReference Column="Expr1005" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="50" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <Top RowCount="0" IsPercent="0" WithTies="0">
- <TopExpression>
- <ScalarOperator ScalarString="CASE WHEN CONVERT_IMPLICIT(bigint,[@PageSize]*[@PageNumber]+(1)+[@PageSize]-(1),0) IS NULL OR CONVERT_IMPLICIT(bigint,[@PageSize]*[@PageNumber]+(1)+[@PageSize]-(1),0)<(0) THEN (0) ELSE CONVERT_IMPLICIT(bigint,[@PageSize]*[@PageNumber]+(1)+[@PageSize]-(1),0) END">
- <IF>
- <Condition>
- <ScalarOperator>
- <Logical Operation="OR">
- <ScalarOperator>
- <Compare CompareOp="IS">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="ConstExpr1012">
- <ScalarOperator>
- <Convert DataType="bigint" Style="0" Implicit="1">
- <ScalarOperator>
- <Arithmetic Operation="SUB">
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Arithmetic Operation="MULT">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@PageSize" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@PageNumber" />
- </Identifier>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(1)" />
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@PageSize" />
- </Identifier>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(1)" />
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </ColumnReference>
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="LT">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="ConstExpr1012">
- <ScalarOperator>
- <Convert DataType="bigint" Style="0" Implicit="1">
- <ScalarOperator>
- <Arithmetic Operation="SUB">
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Arithmetic Operation="MULT">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@PageSize" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@PageNumber" />
- </Identifier>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(1)" />
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@PageSize" />
- </Identifier>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(1)" />
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </ColumnReference>
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(0)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Condition>
- <Then>
- <ScalarOperator>
- <Const ConstValue="(0)" />
- </ScalarOperator>
- </Then>
- <Else>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="ConstExpr1012">
- <ScalarOperator>
- <Convert DataType="bigint" Style="0" Implicit="1">
- <ScalarOperator>
- <Arithmetic Operation="SUB">
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Arithmetic Operation="MULT">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@PageSize" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@PageNumber" />
- </Identifier>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(1)" />
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@PageSize" />
- </Identifier>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(1)" />
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </ColumnReference>
- </Identifier>
- </ScalarOperator>
- </Else>
- </IF>
- </ScalarOperator>
- </TopExpression>
- <RelOp NodeId="4" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="100" EstimateIO="0.0112613" EstimateCPU="1.18161" AvgRowSize="544" EstimatedTotalSubtreeCost="183.572" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
- <OutputList>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="patient_guid" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="client_guid" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="patient_account_id" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="patient_name" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="rabies_tag_number" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="rabies_serial_number" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="rabies_brand_name" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="species" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="breed" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="coat_color" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="sex" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="birthdate" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="latest_visit" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="first_visit" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="maturity_code" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="medical_alert" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="chronic_ailment" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="continuous_medication" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="weight" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="doctor_preference" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="tattoo_number" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="avid_chip_number" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="comment" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="special_instructions" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="health_plan_name" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="deleted" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="has_lab_results" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="stable_id" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="trainer_id" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="deceased_date" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="active" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[clients]" Alias="[C]" Column="database_guid" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[clients]" Alias="[C]" Column="first_name" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[clients]" Alias="[C]" Column="last_name" />
- <ColumnReference Column="Expr1004" />
- <ColumnReference Column="Expr1005" />
- </OutputList>
- <MemoryFractions Input="0.503258" Output="0.99754" />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="50" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="0" ActualExecutions="1" />
- </RunTimeInformation>
- <Sort Distinct="0">
- <OrderBy>
- <OrderByColumn Ascending="1">
- <ColumnReference Column="Expr1004" />
- </OrderByColumn>
- </OrderBy>
- <RelOp NodeId="5" PhysicalOp="Sequence Project" LogicalOp="Compute Scalar" EstimateRows="18190.4" EstimateIO="0" EstimateCPU="0.00145523" AvgRowSize="544" EstimatedTotalSubtreeCost="182.38" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
- <OutputList>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="patient_guid" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="client_guid" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="patient_account_id" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="patient_name" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="rabies_tag_number" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="rabies_serial_number" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="rabies_brand_name" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="species" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="breed" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="coat_color" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="sex" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="birthdate" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="latest_visit" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="first_visit" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="maturity_code" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="medical_alert" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="chronic_ailment" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="continuous_medication" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="weight" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="doctor_preference" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="tattoo_number" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="avid_chip_number" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="comment" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="special_instructions" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="health_plan_name" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="deleted" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="has_lab_results" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="stable_id" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="trainer_id" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="deceased_date" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="active" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[clients]" Alias="[C]" Column="database_guid" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[clients]" Alias="[C]" Column="first_name" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[clients]" Alias="[C]" Column="last_name" />
- <ColumnReference Column="Expr1004" />
- <ColumnReference Column="Expr1005" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="75" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <SequenceProject>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1005" />
- <ScalarOperator ScalarString="row_number">
- <Sequence FunctionName="row_number" />
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp NodeId="6" PhysicalOp="Segment" LogicalOp="Segment" EstimateRows="18190.4" EstimateIO="0" EstimateCPU="0.000363807" AvgRowSize="544" EstimatedTotalSubtreeCost="182.378" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
- <OutputList>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="patient_guid" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="client_guid" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="patient_account_id" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="patient_name" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="rabies_tag_number" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="rabies_serial_number" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="rabies_brand_name" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="species" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="breed" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="coat_color" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="sex" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="birthdate" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="latest_visit" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="first_visit" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="maturity_code" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="medical_alert" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="chronic_ailment" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="continuous_medication" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="weight" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="doctor_preference" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="tattoo_number" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="avid_chip_number" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="comment" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="special_instructions" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="health_plan_name" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="deleted" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="has_lab_results" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="stable_id" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="trainer_id" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="deceased_date" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="active" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[clients]" Alias="[C]" Column="database_guid" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[clients]" Alias="[C]" Column="first_name" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[clients]" Alias="[C]" Column="last_name" />
- <ColumnReference Column="Expr1004" />
- <ColumnReference Column="Segment1017" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="75" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <Segment>
- <GroupBy />
- <SegmentColumn>
- <ColumnReference Column="Segment1017" />
- </SegmentColumn>
- <RelOp NodeId="7" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="18190.4" EstimateIO="0.0112613" EstimateCPU="1.18161" AvgRowSize="536" EstimatedTotalSubtreeCost="182.378" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
- <OutputList>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="patient_guid" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="client_guid" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="patient_account_id" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="patient_name" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="rabies_tag_number" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="rabies_serial_number" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="rabies_brand_name" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="species" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="breed" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="coat_color" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="sex" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="birthdate" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="latest_visit" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="first_visit" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="maturity_code" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="medical_alert" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="chronic_ailment" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="continuous_medication" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="weight" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="doctor_preference" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="tattoo_number" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="avid_chip_number" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="comment" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="special_instructions" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="health_plan_name" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="deleted" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="has_lab_results" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="stable_id" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="trainer_id" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="deceased_date" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="active" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[clients]" Alias="[C]" Column="database_guid" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[clients]" Alias="[C]" Column="first_name" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[clients]" Alias="[C]" Column="last_name" />
- <ColumnReference Column="Expr1004" />
- </OutputList>
- <MemoryFractions Input="0.309851" Output="0.496742" />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="75" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <Sort Distinct="0">
- <OrderBy>
- <OrderByColumn Ascending="0">
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="patient_name" />
- </OrderByColumn>
- </OrderBy>
- <RelOp NodeId="8" PhysicalOp="Sequence Project" LogicalOp="Compute Scalar" EstimateRows="18190.4" EstimateIO="0" EstimateCPU="0.00145523" AvgRowSize="536" EstimatedTotalSubtreeCost="181.185" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
- <OutputList>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="patient_guid" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="client_guid" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="patient_account_id" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="patient_name" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="rabies_tag_number" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="rabies_serial_number" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="rabies_brand_name" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="species" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="breed" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="coat_color" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="sex" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="birthdate" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="latest_visit" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="first_visit" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="maturity_code" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="medical_alert" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="chronic_ailment" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="continuous_medication" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="weight" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="doctor_preference" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="tattoo_number" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="avid_chip_number" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="comment" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="special_instructions" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="health_plan_name" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="deleted" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="has_lab_results" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="stable_id" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="trainer_id" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="deceased_date" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="active" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[clients]" Alias="[C]" Column="database_guid" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[clients]" Alias="[C]" Column="first_name" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[clients]" Alias="[C]" Column="last_name" />
- <ColumnReference Column="Expr1004" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="75" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <SequenceProject>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1004" />
- <ScalarOperator ScalarString="row_number">
- <Sequence FunctionName="row_number" />
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp NodeId="9" PhysicalOp="Segment" LogicalOp="Segment" EstimateRows="18190.4" EstimateIO="0" EstimateCPU="0.000363807" AvgRowSize="536" EstimatedTotalSubtreeCost="181.183" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
- <OutputList>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="patient_guid" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="client_guid" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="patient_account_id" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="patient_name" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="rabies_tag_number" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="rabies_serial_number" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="rabies_brand_name" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="species" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="breed" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="coat_color" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="sex" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="birthdate" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="latest_visit" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="first_visit" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="maturity_code" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="medical_alert" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="chronic_ailment" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="continuous_medication" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="weight" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="doctor_preference" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="tattoo_number" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="avid_chip_number" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="comment" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="special_instructions" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="health_plan_name" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="deleted" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="has_lab_results" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="stable_id" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="trainer_id" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="deceased_date" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="active" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[clients]" Alias="[C]" Column="database_guid" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[clients]" Alias="[C]" Column="first_name" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[clients]" Alias="[C]" Column="last_name" />
- <ColumnReference Column="Segment1016" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="75" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <Segment>
- <GroupBy />
- <SegmentColumn>
- <ColumnReference Column="Segment1016" />
- </SegmentColumn>
- <RelOp NodeId="10" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="18190.4" EstimateIO="0.0112613" EstimateCPU="1.18161" AvgRowSize="528" EstimatedTotalSubtreeCost="181.183" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
- <OutputList>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="patient_guid" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="client_guid" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="patient_account_id" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="patient_name" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="rabies_tag_number" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="rabies_serial_number" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="rabies_brand_name" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="species" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="breed" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="coat_color" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="sex" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="birthdate" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="latest_visit" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="first_visit" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="maturity_code" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="medical_alert" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="chronic_ailment" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="continuous_medication" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="weight" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="doctor_preference" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="tattoo_number" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="avid_chip_number" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="comment" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="special_instructions" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="health_plan_name" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="deleted" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="has_lab_results" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="stable_id" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="trainer_id" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="deceased_date" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="active" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[clients]" Alias="[C]" Column="database_guid" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[clients]" Alias="[C]" Column="first_name" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[clients]" Alias="[C]" Column="last_name" />
- </OutputList>
- <MemoryFractions Input="0.822796" Output="0.690149" />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="75" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <Sort Distinct="0">
- <OrderBy>
- <OrderByColumn Ascending="1">
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="patient_name" />
- </OrderByColumn>
- </OrderBy>
- <RelOp NodeId="11" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="41115.6" EstimateIO="0" EstimateCPU="0.171863" AvgRowSize="528" EstimatedTotalSubtreeCost="179.954" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
- <OutputList>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="patient_guid" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="client_guid" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="patient_account_id" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="patient_name" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="rabies_tag_number" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="rabies_serial_number" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="rabies_brand_name" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="species" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="breed" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="coat_color" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="sex" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="birthdate" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="latest_visit" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="first_visit" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="maturity_code" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="medical_alert" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="chronic_ailment" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="continuous_medication" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="weight" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="doctor_preference" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="tattoo_number" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="avid_chip_number" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="comment" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="special_instructions" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="health_plan_name" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="deleted" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="has_lab_results" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="stable_id" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="trainer_id" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="deceased_date" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="active" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[clients]" Alias="[C]" Column="database_guid" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[clients]" Alias="[C]" Column="first_name" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[clients]" Alias="[C]" Column="last_name" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="75" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <NestedLoops Optimized="1" WithUnorderedPrefetch="1">
- <OuterReferences>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="patient_guid" />
- <ColumnReference Column="Expr1015" />
- </OuterReferences>
- <RelOp NodeId="14" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="41115.6" EstimateIO="0" EstimateCPU="0.171863" AvgRowSize="73" EstimatedTotalSubtreeCost="49.1721" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
- <OutputList>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="patient_guid" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="client_guid" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[clients]" Alias="[C]" Column="database_guid" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[clients]" Alias="[C]" Column="first_name" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[clients]" Alias="[C]" Column="last_name" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="5141" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <NestedLoops Optimized="0" WithUnorderedPrefetch="1">
- <OuterReferences>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[clients]" Alias="[C]" Column="client_guid" />
- <ColumnReference Column="Expr1014" />
- </OuterReferences>
- <RelOp NodeId="16" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="16648.7" EstimateIO="0.0892064" EstimateCPU="0.0184706" AvgRowSize="57" EstimatedTotalSubtreeCost="0.107677" TableCardinality="5.07786e+006" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
- <OutputList>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[clients]" Alias="[C]" Column="client_guid" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[clients]" Alias="[C]" Column="database_guid" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[clients]" Alias="[C]" Column="first_name" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[clients]" Alias="[C]" Column="last_name" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="1464" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[clients]" Alias="[C]" Column="client_guid" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[clients]" Alias="[C]" Column="database_guid" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[clients]" Alias="[C]" Column="first_name" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[clients]" Alias="[C]" Column="last_name" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[MobileServices]" Schema="[dbo]" Table="[clients]" Index="[_dta_index_clients_17_1035150733__K2_K1_5_6]" Alias="[C]" IndexKind="NonClustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[clients]" Alias="[C]" Column="database_guid" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[@DatabaseGuid]">
- <Identifier>
- <ColumnReference Column="@DatabaseGuid" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- <RelOp NodeId="17" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="2.4696" EstimateIO="0.003125" EstimateCPU="0.000159717" AvgRowSize="39" EstimatedTotalSubtreeCost="48.8926" TableCardinality="1.05638e+007" Parallel="0" EstimateRebinds="16647.7" EstimateRewinds="0" EstimatedExecutionMode="Row">
- <OutputList>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="patient_guid" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="client_guid" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="5141" ActualEndOfScans="1464" ActualExecutions="1464" />
- </RunTimeInformation>
- <IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="patient_guid" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="client_guid" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Index="[ix_patients_client_guid_includes]" Alias="[P]" IndexKind="NonClustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="client_guid" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[MobileServices].[dbo].[clients].[client_guid] as [C].[client_guid]">
- <Identifier>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[clients]" Alias="[C]" Column="client_guid" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- <RelOp NodeId="19" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="18190.4" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="488" EstimatedTotalSubtreeCost="130.61" TableCardinality="1.05638e+007" Parallel="0" EstimateRebinds="41114.6" EstimateRewinds="0" EstimatedExecutionMode="Row">
- <OutputList>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="patient_account_id" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="patient_name" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="rabies_tag_number" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="rabies_serial_number" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="rabies_brand_name" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="species" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="breed" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="coat_color" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="sex" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="birthdate" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="latest_visit" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="first_visit" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="maturity_code" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="medical_alert" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="chronic_ailment" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="continuous_medication" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="weight" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="doctor_preference" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="tattoo_number" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="avid_chip_number" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="comment" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="special_instructions" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="health_plan_name" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="deleted" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="has_lab_results" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="stable_id" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="trainer_id" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="deceased_date" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="active" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="75" ActualEndOfScans="5066" ActualExecutions="5141" />
- </RunTimeInformation>
- <IndexScan Lookup="1" Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="patient_account_id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="patient_name" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="rabies_tag_number" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="rabies_serial_number" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="rabies_brand_name" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="species" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="breed" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="coat_color" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="sex" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="birthdate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="latest_visit" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="first_visit" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="maturity_code" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="medical_alert" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="chronic_ailment" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="continuous_medication" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="weight" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="doctor_preference" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="tattoo_number" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="avid_chip_number" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="comment" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="special_instructions" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="health_plan_name" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="deleted" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="has_lab_results" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="stable_id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="trainer_id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="deceased_date" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="active" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Index="[PK_patients]" Alias="[P]" TableReferenceId="-1" IndexKind="Clustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="patient_guid" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[MobileServices].[dbo].[patients].[patient_guid] as [P].[patient_guid]">
- <Identifier>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="patient_guid" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- <Predicate>
- <ScalarOperator ScalarString="[MobileServices].[dbo].[patients].[patient_name] as [P].[patient_name] like '%'+[@SearchText]+'%'">
- <Intrinsic FunctionName="like">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="patient_name" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="ConstExpr1007">
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Const ConstValue="'%'" />
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@SearchText" />
- </Identifier>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="'%'" />
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- </ColumnReference>
- </Identifier>
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Predicate>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- </Sort>
- </RelOp>
- </Segment>
- </RelOp>
- </SequenceProject>
- </RelOp>
- </Sort>
- </RelOp>
- </Segment>
- </RelOp>
- </SequenceProject>
- </RelOp>
- </Sort>
- </RelOp>
- </Top>
- </RelOp>
- <Predicate>
- <ScalarOperator ScalarString="[Expr1004]>=CONVERT_IMPLICIT(bigint,[@PageSize]*[@PageNumber]+(1),0) AND [Expr1004]<=CONVERT_IMPLICIT(bigint,[@PageSize]*[@PageNumber]+(1)+[@PageSize]-(1),0)">
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="GE">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Expr1004" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="ConstExpr1011">
- <ScalarOperator>
- <Convert DataType="bigint" Style="0" Implicit="1">
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Arithmetic Operation="MULT">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@PageSize" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@PageNumber" />
- </Identifier>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(1)" />
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </ColumnReference>
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="LE">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Expr1004" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="ConstExpr1012">
- <ScalarOperator>
- <Convert DataType="bigint" Style="0" Implicit="1">
- <ScalarOperator>
- <Arithmetic Operation="SUB">
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Arithmetic Operation="MULT">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@PageSize" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@PageNumber" />
- </Identifier>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(1)" />
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@PageSize" />
- </Identifier>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(1)" />
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </ColumnReference>
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Predicate>
- </Filter>
- </RelOp>
- </ComputeScalar>
- </RelOp>
- </Sort>
- </RelOp>
- <ParameterList>
- <ColumnReference Column="@PageNumber" ParameterRuntimeValue="(0)" />
- <ColumnReference Column="@PageSize" ParameterRuntimeValue="(50)" />
- <ColumnReference Column="@SearchText" ParameterRuntimeValue="'jo'" />
- <ColumnReference Column="@DatabaseGuid" ParameterRuntimeValue="{guid'CE7BB6B9-FD26-4467-A73C-B094DB25B22A'}" />
- </ParameterList>
- </QueryPlan>
- </StmtSimple>
- </Statements>
- </Batch>
- </BatchSequence>
- </ShowPlanXML>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement