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]
 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 results.*, (select count(*) from results) as total
from results
ORDER BY patient_name ASC, patient_guid
OFFSET (@PageSize * @PageNumber) ROWS
FETCH NEXT @PageSize ROWS ONLY;" StatementId="1" StatementCompId="5" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="9.94398" StatementEstRows="100" StatementOptmLevel="FULL" QueryHash="0x4AA85494980142FA" QueryPlanHash="0x3456BA44F9F10ED">
- <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="9304" CachedPlanSize="152" CompileTime="67" CompileCPU="67" CompileMemory="1752">
- <MemoryGrantInfo SerialRequiredMemory="1024" SerialDesiredMemory="9304" RequiredMemory="1024" DesiredMemory="9304" RequestedMemory="9304" GrantWaitTime="0" GrantedMemory="9304" MaxUsedMemory="1088" />
- <OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="209690" EstimatedPagesCached="52422" EstimatedAvailableDegreeOfParallelism="2" />
- <RelOp NodeId="0" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="100" EstimateIO="0" EstimateCPU="1e-005" AvgRowSize="532" EstimatedTotalSubtreeCost="9.94398" 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="Expr1010" />
- </OutputList>
- <ComputeScalar>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1010" />
- <ScalarOperator ScalarString="[Expr1008]">
- <Identifier>
- <ColumnReference Column="Expr1008" />
- </Identifier>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp NodeId="1" PhysicalOp="Top" LogicalOp="Top" EstimateRows="100" EstimateIO="0" EstimateCPU="1e-005" AvgRowSize="532" EstimatedTotalSubtreeCost="9.94397" 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="Expr1008" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="50" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <Top RowCount="0" IsPercent="0" WithTies="0">
- <OffsetExpression>
- <ScalarOperator ScalarString="CONVERT_IMPLICIT(bigint,[@PageSize]*[@PageNumber],0)">
- <Identifier>
- <ColumnReference Column="ConstExpr1020">
- <ScalarOperator>
- <Convert DataType="bigint" Style="0" Implicit="1">
- <ScalarOperator>
- <Arithmetic Operation="MULT">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@PageSize" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@PageNumber" />
- </Identifier>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </ColumnReference>
- </Identifier>
- </ScalarOperator>
- </OffsetExpression>
- <TopExpression>
- <ScalarOperator ScalarString="CONVERT_IMPLICIT(bigint,[@PageSize],0)">
- <Identifier>
- <ColumnReference Column="ConstExpr1019">
- <ScalarOperator>
- <Convert DataType="bigint" Style="0" Implicit="1">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@PageSize" />
- </Identifier>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </ColumnReference>
- </Identifier>
- </ScalarOperator>
- </TopExpression>
- <RelOp NodeId="2" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="100" EstimateIO="0" EstimateCPU="0.0760357" AvgRowSize="532" EstimatedTotalSubtreeCost="9.94396" 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="Expr1008" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="50" ActualEndOfScans="0" ActualExecutions="1" />
- </RunTimeInformation>
- <NestedLoops Optimized="0">
- <RelOp NodeId="3" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="0.0109147" AvgRowSize="11" EstimatedTotalSubtreeCost="4.19726" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
- <OutputList>
- <ColumnReference Column="Expr1008" />
- </OutputList>
- <ComputeScalar>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1008" />
- <ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[Expr1027],0)">
- <Convert DataType="int" Style="0" Implicit="1">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Expr1027" />
- </Identifier>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp NodeId="4" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="0.0109147" AvgRowSize="11" EstimatedTotalSubtreeCost="4.19726" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
- <OutputList>
- <ColumnReference Column="Expr1027" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="0" ActualExecutions="1" />
- </RunTimeInformation>
- <StreamAggregate>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1027" />
- <ScalarOperator ScalarString="Count(*)">
- <Aggregate AggType="countstar" Distinct="0" />
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp NodeId="5" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="18190.4" EstimateIO="0" EstimateCPU="2.25928" AvgRowSize="9" EstimatedTotalSubtreeCost="4.18635" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
- <OutputList />
- <MemoryFractions Input="1" Output="1" />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="75" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <Hash>
- <DefinedValues />
- <HashKeysBuild>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[clients]" Alias="[C]" Column="client_guid" />
- </HashKeysBuild>
- <HashKeysProbe>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="client_guid" />
- </HashKeysProbe>
- <ProbeResidual>
- <ScalarOperator ScalarString="[MobileServices].[dbo].[clients].[client_guid] as [C].[client_guid]=[MobileServices].[dbo].[patients].[client_guid] as [P].[client_guid]">
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[clients]" Alias="[C]" Column="client_guid" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="client_guid" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </ProbeResidual>
- <RelOp NodeId="6" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="16648.7" EstimateIO="0.0816799" EstimateCPU="0.0184706" AvgRowSize="23" EstimatedTotalSubtreeCost="0.100151" 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" />
- </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>
- </DefinedValues>
- <Object Database="[MobileServices]" Schema="[dbo]" Table="[clients]" Index="[IX_clients]" Alias="[C]" TableReferenceId="2" 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="7" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="283916" EstimateIO="1.26461" EstimateCPU="0.312464" AvgRowSize="33" EstimatedTotalSubtreeCost="1.57707" TableCardinality="1.05638e+007" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
- <OutputList>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="client_guid" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="110555" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <NestedLoops Optimized="0">
- <OuterReferences>
- <ColumnReference Column="Expr1024" />
- <ColumnReference Column="Expr1025" />
- <ColumnReference Column="Expr1026" />
- </OuterReferences>
- <RelOp NodeId="8" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="0" AvgRowSize="69" EstimatedTotalSubtreeCost="0" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
- <OutputList>
- <ColumnReference Column="Expr1024" />
- <ColumnReference Column="Expr1025" />
- <ColumnReference Column="Expr1026" />
- </OutputList>
- <ComputeScalar>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1024" />
- <ScalarOperator ScalarString="LikeRangeStart('%'+[@SearchText]+'%')">
- <Identifier>
- <ColumnReference Column="ConstExpr1016">
- <ScalarOperator>
- <Intrinsic FunctionName="LikeRangeStart">
- <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>
- <ScalarOperator>
- <Const ConstValue="" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </ColumnReference>
- </Identifier>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1025" />
- <ScalarOperator ScalarString="LikeRangeEnd('%'+[@SearchText]+'%')">
- <Identifier>
- <ColumnReference Column="ConstExpr1017">
- <ScalarOperator>
- <Intrinsic FunctionName="LikeRangeEnd">
- <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>
- <ScalarOperator>
- <Const ConstValue="" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </ColumnReference>
- </Identifier>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1026" />
- <ScalarOperator ScalarString="LikeRangeInfo('%'+[@SearchText]+'%')">
- <Identifier>
- <ColumnReference Column="ConstExpr1018">
- <ScalarOperator>
- <Intrinsic FunctionName="LikeRangeInfo">
- <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>
- <ScalarOperator>
- <Const ConstValue="" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </ColumnReference>
- </Identifier>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp NodeId="9" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="1" EstimateIO="0" EstimateCPU="0" AvgRowSize="0" EstimatedTotalSubtreeCost="0" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
- <OutputList />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <ConstantScan />
- </RelOp>
- </ComputeScalar>
- </RelOp>
- <RelOp NodeId="17" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="283916" EstimateIO="1.26461" EstimateCPU="0.312464" AvgRowSize="33" EstimatedTotalSubtreeCost="1.57707" TableCardinality="1.05638e+007" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
- <OutputList>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="client_guid" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="110555" 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="[patients]" Alias="[P]" Column="client_guid" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Index="[_dta_index_patients_17_1479676319__K5_3]" Alias="[P]" TableReferenceId="2" IndexKind="NonClustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <StartRange ScanType="GT">
- <RangeColumns>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="patient_name" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[Expr1024]">
- <Identifier>
- <ColumnReference Column="Expr1024" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </StartRange>
- <EndRange ScanType="LT">
- <RangeColumns>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="patient_name" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[Expr1025]">
- <Identifier>
- <ColumnReference Column="Expr1025" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </EndRange>
- </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="ConstExpr1015">
- <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>
- </Hash>
- </RelOp>
- </StreamAggregate>
- </RelOp>
- </ComputeScalar>
- </RelOp>
- <RelOp NodeId="23" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="100" EstimateIO="0" EstimateCPU="1.18677" AvgRowSize="528" EstimatedTotalSubtreeCost="5.74628" 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="50" ActualEndOfScans="0" ActualExecutions="1" />
- </RunTimeInformation>
- <NestedLoops Optimized="0" WithOrderedPrefetch="1">
- <OuterReferences>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="client_guid" />
- <ColumnReference Column="Expr1032" />
- </OuterReferences>
- <RelOp NodeId="25" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1560.8" EstimateIO="0" EstimateCPU="1.18677" AvgRowSize="495" EstimatedTotalSubtreeCost="5.1355" 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" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="77753" ActualEndOfScans="0" ActualExecutions="1" />
- </RunTimeInformation>
- <NestedLoops Optimized="0" WithOrderedPrefetch="1">
- <OuterReferences>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="patient_guid" />
- <ColumnReference Column="Expr1031" />
- </OuterReferences>
- <RelOp NodeId="27" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1560.8" EstimateIO="0.846829" EstimateCPU="0.312464" AvgRowSize="33" EstimatedTotalSubtreeCost="0.00963412" TableCardinality="1.05638e+007" 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="patient_name" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="77753" ActualEndOfScans="0" ActualExecutions="1" />
- </RunTimeInformation>
- <NestedLoops Optimized="0">
- <OuterReferences>
- <ColumnReference Column="Expr1028" />
- <ColumnReference Column="Expr1029" />
- <ColumnReference Column="Expr1030" />
- </OuterReferences>
- <RelOp NodeId="28" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="0" AvgRowSize="69" EstimatedTotalSubtreeCost="0" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
- <OutputList>
- <ColumnReference Column="Expr1028" />
- <ColumnReference Column="Expr1029" />
- <ColumnReference Column="Expr1030" />
- </OutputList>
- <ComputeScalar>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1028" />
- <ScalarOperator ScalarString="LikeRangeStart('%'+[@SearchText]+'%')">
- <Identifier>
- <ColumnReference Column="ConstExpr1012">
- <ScalarOperator>
- <Intrinsic FunctionName="LikeRangeStart">
- <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>
- <ScalarOperator>
- <Const ConstValue="" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </ColumnReference>
- </Identifier>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1029" />
- <ScalarOperator ScalarString="LikeRangeEnd('%'+[@SearchText]+'%')">
- <Identifier>
- <ColumnReference Column="ConstExpr1013">
- <ScalarOperator>
- <Intrinsic FunctionName="LikeRangeEnd">
- <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>
- <ScalarOperator>
- <Const ConstValue="" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </ColumnReference>
- </Identifier>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1030" />
- <ScalarOperator ScalarString="LikeRangeInfo('%'+[@SearchText]+'%')">
- <Identifier>
- <ColumnReference Column="ConstExpr1014">
- <ScalarOperator>
- <Intrinsic FunctionName="LikeRangeInfo">
- <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>
- <ScalarOperator>
- <Const ConstValue="" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </ColumnReference>
- </Identifier>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp NodeId="29" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="1" EstimateIO="0" EstimateCPU="0" AvgRowSize="0" EstimatedTotalSubtreeCost="0" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
- <OutputList />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="0" ActualExecutions="1" />
- </RunTimeInformation>
- <ConstantScan />
- </RelOp>
- </ComputeScalar>
- </RelOp>
- <RelOp NodeId="37" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="1560.8" EstimateIO="0.846829" EstimateCPU="0.312464" AvgRowSize="33" EstimatedTotalSubtreeCost="0.00963412" TableCardinality="1.05638e+007" 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="patient_name" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="77753" ActualEndOfScans="0" 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="[patients]" Alias="[P]" Column="patient_guid" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="patient_name" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Index="[_dta_index_patients_17_1479676319__K5]" Alias="[P]" TableReferenceId="1" IndexKind="NonClustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <StartRange ScanType="GT">
- <RangeColumns>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="patient_name" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[Expr1028]">
- <Identifier>
- <ColumnReference Column="Expr1028" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </StartRange>
- <EndRange ScanType="LT">
- <RangeColumns>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="patient_name" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[Expr1029]">
- <Identifier>
- <ColumnReference Column="Expr1029" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </EndRange>
- </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="ConstExpr1011">
- <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>
- <RelOp NodeId="39" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="477" EstimatedTotalSubtreeCost="5.11798" TableCardinality="1.05638e+007" Parallel="0" EstimateRebinds="1560.8" EstimateRewinds="0" EstimatedExecutionMode="Row">
- <OutputList>
- <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="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="77753" ActualEndOfScans="0" ActualExecutions="77753" />
- </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="client_guid" />
- </DefinedValue>
- <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="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>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- <RelOp NodeId="99" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="41" EstimatedTotalSubtreeCost="0.619433" TableCardinality="5.07786e+006" Parallel="0" EstimateRebinds="1600" EstimateRewinds="0.219897" EstimatedExecutionMode="Row">
- <OutputList>
- <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="50" ActualEndOfScans="77703" ActualExecutions="77753" />
- </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="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]" TableReferenceId="1" IndexKind="NonClustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[clients]" Alias="[C]" Column="database_guid" />
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[clients]" Alias="[C]" Column="client_guid" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[@DatabaseGuid]">
- <Identifier>
- <ColumnReference Column="@DatabaseGuid" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator ScalarString="[MobileServices].[dbo].[patients].[client_guid] as [P].[client_guid]">
- <Identifier>
- <ColumnReference Database="[MobileServices]" Schema="[dbo]" Table="[patients]" Alias="[P]" Column="client_guid" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- </NestedLoops>
- </RelOp>
- </Top>
- </RelOp>
- </ComputeScalar>
- </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