Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?xml version="1.0" encoding="utf-16"?>
- <ShowPlanXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="1.1" Build="10.50.2550.0" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
- <BatchSequence>
- <Batch>
- <Statements>
- <StmtSimple StatementCompId="1" StatementEstRows="1" StatementId="1" StatementOptmLevel="FULL" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" StatementSubTreeCost="0.0130019" StatementText="SELECT * FROM customer c
LEFT JOIN business_customer bc on c.customer_id=bc.business_customer_id
WHERE
 CONTAINS(c.*, '"noresult"');

" StatementType="SELECT" QueryHash="0xCC824D45A9F5D45A" QueryPlanHash="0x9BAF61C9BC532B11">
- <StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" />
- <QueryPlan DegreeOfParallelism="1" CachedPlanSize="88" CompileTime="19" CompileCPU="19" CompileMemory="616">
- <RelOp AvgRowSize="2426" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Left Outer Join" NodeId="0" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0130019">
- <OutputList>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="customer_id" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name1" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name2" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name3" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name4" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="external_id" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="street" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="number" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="floor" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="door" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="zip_code" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="city" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="country" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="telephone" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="email" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="create_time" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="created_by_user_id" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="letter" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="external_id2" />
- <ColumnReference Table="[c]" Column="fullname1" ComputedColumn="true" />
- <ColumnReference Table="[c]" Column="fullname2" ComputedColumn="true" />
- <ColumnReference Table="[c]" Column="street_address" ComputedColumn="true" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="business_customer_id" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="company_contact" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="cvr_number" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="p_number" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="ean_number" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <NestedLoops Optimized="false">
- <OuterReferences>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="customer_id" />
- </OuterReferences>
- <RelOp AvgRowSize="1897" EstimateCPU="1E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Aggregate" NodeId="2" Parallel="false" PhysicalOp="Stream Aggregate" EstimatedTotalSubtreeCost="0.00971458">
- <OutputList>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="customer_id" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name1" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name2" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name3" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name4" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="external_id" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="street" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="number" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="floor" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="door" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="zip_code" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="city" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="country" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="telephone" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="email" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="create_time" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="created_by_user_id" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="letter" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="external_id2" />
- <ColumnReference Table="[c]" Column="fullname1" ComputedColumn="true" />
- <ColumnReference Table="[c]" Column="fullname2" ComputedColumn="true" />
- <ColumnReference Table="[c]" Column="street_address" ComputedColumn="true" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <StreamAggregate>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name1" />
- <ScalarOperator ScalarString="ANY([cpt].[dbo].[customer].[name1] as [c].[name1])">
- <Aggregate AggType="ANY" Distinct="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name1" />
- </Identifier>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name2" />
- <ScalarOperator ScalarString="ANY([cpt].[dbo].[customer].[name2] as [c].[name2])">
- <Aggregate AggType="ANY" Distinct="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name2" />
- </Identifier>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name3" />
- <ScalarOperator ScalarString="ANY([cpt].[dbo].[customer].[name3] as [c].[name3])">
- <Aggregate AggType="ANY" Distinct="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name3" />
- </Identifier>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name4" />
- <ScalarOperator ScalarString="ANY([cpt].[dbo].[customer].[name4] as [c].[name4])">
- <Aggregate AggType="ANY" Distinct="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name4" />
- </Identifier>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="external_id" />
- <ScalarOperator ScalarString="ANY([cpt].[dbo].[customer].[external_id] as [c].[external_id])">
- <Aggregate AggType="ANY" Distinct="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="external_id" />
- </Identifier>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="street" />
- <ScalarOperator ScalarString="ANY([cpt].[dbo].[customer].[street] as [c].[street])">
- <Aggregate AggType="ANY" Distinct="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="street" />
- </Identifier>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="number" />
- <ScalarOperator ScalarString="ANY([cpt].[dbo].[customer].[number] as [c].[number])">
- <Aggregate AggType="ANY" Distinct="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="number" />
- </Identifier>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="floor" />
- <ScalarOperator ScalarString="ANY([cpt].[dbo].[customer].[floor] as [c].[floor])">
- <Aggregate AggType="ANY" Distinct="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="floor" />
- </Identifier>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="door" />
- <ScalarOperator ScalarString="ANY([cpt].[dbo].[customer].[door] as [c].[door])">
- <Aggregate AggType="ANY" Distinct="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="door" />
- </Identifier>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="zip_code" />
- <ScalarOperator ScalarString="ANY([cpt].[dbo].[customer].[zip_code] as [c].[zip_code])">
- <Aggregate AggType="ANY" Distinct="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="zip_code" />
- </Identifier>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="city" />
- <ScalarOperator ScalarString="ANY([cpt].[dbo].[customer].[city] as [c].[city])">
- <Aggregate AggType="ANY" Distinct="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="city" />
- </Identifier>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="country" />
- <ScalarOperator ScalarString="ANY([cpt].[dbo].[customer].[country] as [c].[country])">
- <Aggregate AggType="ANY" Distinct="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="country" />
- </Identifier>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="telephone" />
- <ScalarOperator ScalarString="ANY([cpt].[dbo].[customer].[telephone] as [c].[telephone])">
- <Aggregate AggType="ANY" Distinct="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="telephone" />
- </Identifier>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="email" />
- <ScalarOperator ScalarString="ANY([cpt].[dbo].[customer].[email] as [c].[email])">
- <Aggregate AggType="ANY" Distinct="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="email" />
- </Identifier>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="create_time" />
- <ScalarOperator ScalarString="ANY([cpt].[dbo].[customer].[create_time] as [c].[create_time])">
- <Aggregate AggType="ANY" Distinct="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="create_time" />
- </Identifier>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="created_by_user_id" />
- <ScalarOperator ScalarString="ANY([cpt].[dbo].[customer].[created_by_user_id] as [c].[created_by_user_id])">
- <Aggregate AggType="ANY" Distinct="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="created_by_user_id" />
- </Identifier>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="letter" />
- <ScalarOperator ScalarString="ANY([cpt].[dbo].[customer].[letter] as [c].[letter])">
- <Aggregate AggType="ANY" Distinct="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="letter" />
- </Identifier>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="external_id2" />
- <ScalarOperator ScalarString="ANY([cpt].[dbo].[customer].[external_id2] as [c].[external_id2])">
- <Aggregate AggType="ANY" Distinct="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="external_id2" />
- </Identifier>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Table="[c]" Column="fullname1" ComputedColumn="true" />
- <ScalarOperator ScalarString="ANY([c].[fullname1])">
- <Aggregate AggType="ANY" Distinct="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Table="[c]" Column="fullname1" ComputedColumn="true" />
- </Identifier>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Table="[c]" Column="fullname2" ComputedColumn="true" />
- <ScalarOperator ScalarString="ANY([c].[fullname2])">
- <Aggregate AggType="ANY" Distinct="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Table="[c]" Column="fullname2" ComputedColumn="true" />
- </Identifier>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Table="[c]" Column="street_address" ComputedColumn="true" />
- <ScalarOperator ScalarString="ANY([c].[street_address])">
- <Aggregate AggType="ANY" Distinct="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Table="[c]" Column="street_address" ComputedColumn="true" />
- </Identifier>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <GroupBy>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="customer_id" />
- </GroupBy>
- <RelOp AvgRowSize="1897" EstimateCPU="1E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Compute Scalar" NodeId="3" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.00971358">
- <OutputList>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="customer_id" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name1" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name2" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name3" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name4" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="external_id" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="street" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="number" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="floor" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="door" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="zip_code" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="city" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="country" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="telephone" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="email" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="create_time" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="created_by_user_id" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="letter" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="external_id2" />
- <ColumnReference Table="[c]" Column="fullname1" ComputedColumn="true" />
- <ColumnReference Table="[c]" Column="fullname2" ComputedColumn="true" />
- <ColumnReference Table="[c]" Column="street_address" ComputedColumn="true" />
- </OutputList>
- <ComputeScalar>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Table="[c]" Column="fullname1" ComputedColumn="true" />
- <ScalarOperator ScalarString="[cpt].[dbo].[customer].[fullname1] as [c].[fullname1]">
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="fullname1" ComputedColumn="true" />
- </Identifier>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Table="[c]" Column="fullname2" ComputedColumn="true" />
- <ScalarOperator ScalarString="[cpt].[dbo].[customer].[fullname2] as [c].[fullname2]">
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="fullname2" ComputedColumn="true" />
- </Identifier>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Table="[c]" Column="street_address" ComputedColumn="true" />
- <ScalarOperator ScalarString="[cpt].[dbo].[customer].[street_address] as [c].[street_address]">
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="street_address" ComputedColumn="true" />
- </Identifier>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="1897" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Inner Join" NodeId="4" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.00971348">
- <OutputList>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="customer_id" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name1" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name2" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name3" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name4" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="external_id" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="street" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="number" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="floor" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="door" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="zip_code" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="city" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="country" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="telephone" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="email" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="create_time" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="created_by_user_id" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="letter" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="external_id2" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="fullname1" ComputedColumn="true" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="fullname2" ComputedColumn="true" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="street_address" ComputedColumn="true" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <NestedLoops Optimized="false">
- <OuterReferences>
- <ColumnReference Table="[FulltextMatch]" Column="docid" />
- </OuterReferences>
- <RelOp AvgRowSize="15" EstimateCPU="0.0033011" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Table-valued function" NodeId="5" Parallel="false" PhysicalOp="Table-valued function" EstimatedTotalSubtreeCost="0.0064261">
- <OutputList>
- <ColumnReference Table="[FulltextMatch]" Column="docid" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRebinds="1" ActualRewinds="0" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <TableValuedFunction>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Table="[FulltextMatch]" Column="docid" />
- </DefinedValue>
- </DefinedValues>
- <Object Table="[FulltextMatch]" />
- <ParameterList>
- <ScalarOperator ScalarString="(1)">
- <Const ConstValue="(1)" />
- </ScalarOperator>
- <ScalarOperator ScalarString="(1)">
- <Const ConstValue="(1)" />
- </ScalarOperator>
- <ScalarOperator ScalarString="(2)">
- <Const ConstValue="(2)" />
- </ScalarOperator>
- <ScalarOperator ScalarString="(0)">
- <Const ConstValue="(0)" />
- </ScalarOperator>
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </ParameterList>
- </TableValuedFunction>
- </RelOp>
- <RelOp AvgRowSize="1897" EstimateCPU="1E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Compute Scalar" NodeId="12" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.0032832">
- <OutputList>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="customer_id" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name1" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name2" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name3" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name4" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="external_id" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="street" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="number" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="floor" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="door" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="zip_code" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="city" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="country" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="telephone" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="email" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="create_time" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="created_by_user_id" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="letter" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="external_id2" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="fullname1" ComputedColumn="true" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="fullname2" ComputedColumn="true" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="street_address" ComputedColumn="true" />
- </OutputList>
- <ComputeScalar>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="fullname1" ComputedColumn="true" />
- <ScalarOperator ScalarString="([cpt].[dbo].[customer].[name1] as [c].[name1]+' ')+[cpt].[dbo].[customer].[name2] as [c].[name2]">
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name1" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="' '" />
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name2" />
- </Identifier>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="fullname2" ComputedColumn="true" />
- <ScalarOperator ScalarString="([cpt].[dbo].[customer].[name3] as [c].[name3]+' ')+[cpt].[dbo].[customer].[name4] as [c].[name4]">
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name3" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="' '" />
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name4" />
- </Identifier>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="street_address" ComputedColumn="true" />
- <ScalarOperator ScalarString="(((([cpt].[dbo].[customer].[street] as [c].[street]+' ')+[cpt].[dbo].[customer].[number] as [c].[number])+CASE WHEN (' '+[cpt].[dbo].[customer].[letter] as [c].[letter]) IS NOT NULL THEN ' '+[cpt].[dbo].[customer].[letter] as [c].[letter] ELSE '' END)+CASE WHEN (', '+[cpt].[dbo].[customer].[floor] as [c].[floor]) IS NOT NULL THEN ', '+[cpt].[dbo].[customer].[floor] as [c].[floor] ELSE '' END)+CASE WHEN (' '+[cpt].[dbo].[customer].[door] as [c].[door]) IS NOT NULL THEN ' '+[cpt].[dbo].[customer].[door] as [c].[door] ELSE '' END">
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="street" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="' '" />
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="number" />
- </Identifier>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- <ScalarOperator>
- <IF>
- <Condition>
- <ScalarOperator>
- <Compare CompareOp="IS NOT">
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Const ConstValue="' '" />
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="letter" />
- </Identifier>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Condition>
- <Then>
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Const ConstValue="' '" />
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="letter" />
- </Identifier>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- </Then>
- <Else>
- <ScalarOperator>
- <Const ConstValue="''" />
- </ScalarOperator>
- </Else>
- </IF>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- <ScalarOperator>
- <IF>
- <Condition>
- <ScalarOperator>
- <Compare CompareOp="IS NOT">
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Const ConstValue="', '" />
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="floor" />
- </Identifier>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Condition>
- <Then>
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Const ConstValue="', '" />
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="floor" />
- </Identifier>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- </Then>
- <Else>
- <ScalarOperator>
- <Const ConstValue="''" />
- </ScalarOperator>
- </Else>
- </IF>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- <ScalarOperator>
- <IF>
- <Condition>
- <ScalarOperator>
- <Compare CompareOp="IS NOT">
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Const ConstValue="' '" />
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="door" />
- </Identifier>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Condition>
- <Then>
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Const ConstValue="' '" />
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="door" />
- </Identifier>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- </Then>
- <Else>
- <ScalarOperator>
- <Const ConstValue="''" />
- </ScalarOperator>
- </Else>
- </IF>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="1193" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="13" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="101387">
- <OutputList>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="customer_id" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name1" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name2" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name3" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name4" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="external_id" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="street" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="number" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="floor" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="door" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="zip_code" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="city" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="country" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="telephone" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="email" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="create_time" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="created_by_user_id" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="letter" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="external_id2" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="customer_id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name1" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name2" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name3" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name4" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="external_id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="street" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="number" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="floor" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="door" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="zip_code" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="city" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="country" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="telephone" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="email" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="create_time" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="created_by_user_id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="letter" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="external_id2" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[cpt]" Schema="[dbo]" Table="[customer]" Index="[pk_customer]" Alias="[c]" IndexKind="Clustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="customer_id" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="FulltextMatch.[docid]">
- <Identifier>
- <ColumnReference Table="[FulltextMatch]" Column="docid" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </ComputeScalar>
- </RelOp>
- </NestedLoops>
- </RelOp>
- </ComputeScalar>
- </RelOp>
- </StreamAggregate>
- </RelOp>
- <RelOp AvgRowSize="537" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="72" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="14862">
- <OutputList>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="business_customer_id" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="company_contact" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="cvr_number" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="p_number" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="ean_number" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="business_customer_id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="company_contact" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="cvr_number" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="p_number" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="ean_number" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Index="[business_customer_pk]" Alias="[bc]" IndexKind="Clustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="business_customer_id" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[cpt].[dbo].[customer].[customer_id] as [c].[customer_id]">
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="customer_id" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- </QueryPlan>
- </StmtSimple>
- </Statements>
- </Batch>
- <Batch>
- <Statements>
- <StmtSimple StatementCompId="2" StatementEstRows="1" StatementId="2" StatementOptmLevel="FULL" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" StatementSubTreeCost="0.0130019" StatementText="SELECT * FROM customer c
LEFT JOIN business_customer bc on c.customer_id=bc.business_customer_id
WHERE
 CONTAINS(bc.*, '"noresult"');

" StatementType="SELECT" QueryHash="0x3DB81F3638CA6DAB" QueryPlanHash="0x48BC2D769EE8D53C">
- <StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" />
- <QueryPlan DegreeOfParallelism="1" CachedPlanSize="104" CompileTime="33" CompileCPU="33" CompileMemory="776">
- <RelOp AvgRowSize="2426" EstimateCPU="1E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Aggregate" NodeId="1" Parallel="false" PhysicalOp="Stream Aggregate" EstimatedTotalSubtreeCost="0.0130019">
- <OutputList>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="customer_id" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name1" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name2" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name3" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name4" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="external_id" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="street" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="number" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="floor" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="door" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="zip_code" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="city" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="country" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="telephone" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="email" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="create_time" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="created_by_user_id" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="letter" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="external_id2" />
- <ColumnReference Table="[c]" Column="fullname1" ComputedColumn="true" />
- <ColumnReference Table="[c]" Column="fullname2" ComputedColumn="true" />
- <ColumnReference Table="[c]" Column="street_address" ComputedColumn="true" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="business_customer_id" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="company_contact" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="cvr_number" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="p_number" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="ean_number" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <StreamAggregate>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name1" />
- <ScalarOperator ScalarString="ANY([cpt].[dbo].[customer].[name1] as [c].[name1])">
- <Aggregate AggType="ANY" Distinct="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name1" />
- </Identifier>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name2" />
- <ScalarOperator ScalarString="ANY([cpt].[dbo].[customer].[name2] as [c].[name2])">
- <Aggregate AggType="ANY" Distinct="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name2" />
- </Identifier>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name3" />
- <ScalarOperator ScalarString="ANY([cpt].[dbo].[customer].[name3] as [c].[name3])">
- <Aggregate AggType="ANY" Distinct="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name3" />
- </Identifier>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name4" />
- <ScalarOperator ScalarString="ANY([cpt].[dbo].[customer].[name4] as [c].[name4])">
- <Aggregate AggType="ANY" Distinct="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name4" />
- </Identifier>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="external_id" />
- <ScalarOperator ScalarString="ANY([cpt].[dbo].[customer].[external_id] as [c].[external_id])">
- <Aggregate AggType="ANY" Distinct="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="external_id" />
- </Identifier>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="street" />
- <ScalarOperator ScalarString="ANY([cpt].[dbo].[customer].[street] as [c].[street])">
- <Aggregate AggType="ANY" Distinct="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="street" />
- </Identifier>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="number" />
- <ScalarOperator ScalarString="ANY([cpt].[dbo].[customer].[number] as [c].[number])">
- <Aggregate AggType="ANY" Distinct="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="number" />
- </Identifier>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="floor" />
- <ScalarOperator ScalarString="ANY([cpt].[dbo].[customer].[floor] as [c].[floor])">
- <Aggregate AggType="ANY" Distinct="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="floor" />
- </Identifier>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="door" />
- <ScalarOperator ScalarString="ANY([cpt].[dbo].[customer].[door] as [c].[door])">
- <Aggregate AggType="ANY" Distinct="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="door" />
- </Identifier>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="zip_code" />
- <ScalarOperator ScalarString="ANY([cpt].[dbo].[customer].[zip_code] as [c].[zip_code])">
- <Aggregate AggType="ANY" Distinct="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="zip_code" />
- </Identifier>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="city" />
- <ScalarOperator ScalarString="ANY([cpt].[dbo].[customer].[city] as [c].[city])">
- <Aggregate AggType="ANY" Distinct="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="city" />
- </Identifier>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="country" />
- <ScalarOperator ScalarString="ANY([cpt].[dbo].[customer].[country] as [c].[country])">
- <Aggregate AggType="ANY" Distinct="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="country" />
- </Identifier>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="telephone" />
- <ScalarOperator ScalarString="ANY([cpt].[dbo].[customer].[telephone] as [c].[telephone])">
- <Aggregate AggType="ANY" Distinct="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="telephone" />
- </Identifier>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="email" />
- <ScalarOperator ScalarString="ANY([cpt].[dbo].[customer].[email] as [c].[email])">
- <Aggregate AggType="ANY" Distinct="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="email" />
- </Identifier>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="create_time" />
- <ScalarOperator ScalarString="ANY([cpt].[dbo].[customer].[create_time] as [c].[create_time])">
- <Aggregate AggType="ANY" Distinct="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="create_time" />
- </Identifier>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="created_by_user_id" />
- <ScalarOperator ScalarString="ANY([cpt].[dbo].[customer].[created_by_user_id] as [c].[created_by_user_id])">
- <Aggregate AggType="ANY" Distinct="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="created_by_user_id" />
- </Identifier>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="letter" />
- <ScalarOperator ScalarString="ANY([cpt].[dbo].[customer].[letter] as [c].[letter])">
- <Aggregate AggType="ANY" Distinct="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="letter" />
- </Identifier>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="external_id2" />
- <ScalarOperator ScalarString="ANY([cpt].[dbo].[customer].[external_id2] as [c].[external_id2])">
- <Aggregate AggType="ANY" Distinct="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="external_id2" />
- </Identifier>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Table="[c]" Column="fullname1" ComputedColumn="true" />
- <ScalarOperator ScalarString="ANY([c].[fullname1])">
- <Aggregate AggType="ANY" Distinct="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Table="[c]" Column="fullname1" ComputedColumn="true" />
- </Identifier>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Table="[c]" Column="fullname2" ComputedColumn="true" />
- <ScalarOperator ScalarString="ANY([c].[fullname2])">
- <Aggregate AggType="ANY" Distinct="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Table="[c]" Column="fullname2" ComputedColumn="true" />
- </Identifier>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Table="[c]" Column="street_address" ComputedColumn="true" />
- <ScalarOperator ScalarString="ANY([c].[street_address])">
- <Aggregate AggType="ANY" Distinct="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Table="[c]" Column="street_address" ComputedColumn="true" />
- </Identifier>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="business_customer_id" />
- <ScalarOperator ScalarString="ANY([cpt].[dbo].[business_customer].[business_customer_id] as [bc].[business_customer_id])">
- <Aggregate AggType="ANY" Distinct="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="business_customer_id" />
- </Identifier>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="company_contact" />
- <ScalarOperator ScalarString="ANY([cpt].[dbo].[business_customer].[company_contact] as [bc].[company_contact])">
- <Aggregate AggType="ANY" Distinct="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="company_contact" />
- </Identifier>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="cvr_number" />
- <ScalarOperator ScalarString="ANY([cpt].[dbo].[business_customer].[cvr_number] as [bc].[cvr_number])">
- <Aggregate AggType="ANY" Distinct="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="cvr_number" />
- </Identifier>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="p_number" />
- <ScalarOperator ScalarString="ANY([cpt].[dbo].[business_customer].[p_number] as [bc].[p_number])">
- <Aggregate AggType="ANY" Distinct="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="p_number" />
- </Identifier>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="ean_number" />
- <ScalarOperator ScalarString="ANY([cpt].[dbo].[business_customer].[ean_number] as [bc].[ean_number])">
- <Aggregate AggType="ANY" Distinct="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="ean_number" />
- </Identifier>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <GroupBy>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="customer_id" />
- </GroupBy>
- <RelOp AvgRowSize="2426" EstimateCPU="1E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Compute Scalar" NodeId="2" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.0130009">
- <OutputList>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="customer_id" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name1" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name2" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name3" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name4" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="external_id" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="street" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="number" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="floor" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="door" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="zip_code" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="city" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="country" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="telephone" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="email" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="create_time" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="created_by_user_id" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="letter" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="external_id2" />
- <ColumnReference Table="[c]" Column="fullname1" ComputedColumn="true" />
- <ColumnReference Table="[c]" Column="fullname2" ComputedColumn="true" />
- <ColumnReference Table="[c]" Column="street_address" ComputedColumn="true" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="business_customer_id" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="company_contact" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="cvr_number" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="p_number" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="ean_number" />
- </OutputList>
- <ComputeScalar>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Table="[c]" Column="fullname1" ComputedColumn="true" />
- <ScalarOperator ScalarString="[cpt].[dbo].[customer].[fullname1] as [c].[fullname1]">
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="fullname1" ComputedColumn="true" />
- </Identifier>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Table="[c]" Column="fullname2" ComputedColumn="true" />
- <ScalarOperator ScalarString="[cpt].[dbo].[customer].[fullname2] as [c].[fullname2]">
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="fullname2" ComputedColumn="true" />
- </Identifier>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Table="[c]" Column="street_address" ComputedColumn="true" />
- <ScalarOperator ScalarString="[cpt].[dbo].[customer].[street_address] as [c].[street_address]">
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="street_address" ComputedColumn="true" />
- </Identifier>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="2426" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Inner Join" NodeId="3" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0130008">
- <OutputList>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="customer_id" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name1" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name2" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name3" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name4" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="external_id" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="street" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="number" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="floor" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="door" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="zip_code" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="city" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="country" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="telephone" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="email" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="create_time" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="created_by_user_id" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="letter" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="external_id2" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="fullname1" ComputedColumn="true" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="fullname2" ComputedColumn="true" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="street_address" ComputedColumn="true" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="business_customer_id" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="company_contact" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="cvr_number" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="p_number" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="ean_number" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <NestedLoops Optimized="false">
- <OuterReferences>
- <ColumnReference Table="[FulltextMatch]" Column="docid" />
- </OuterReferences>
- <RelOp AvgRowSize="545" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Inner Join" NodeId="4" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.00971338">
- <OutputList>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="business_customer_id" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="company_contact" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="cvr_number" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="p_number" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="ean_number" />
- <ColumnReference Table="[FulltextMatch]" Column="docid" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <NestedLoops Optimized="false">
- <OuterReferences>
- <ColumnReference Table="[FulltextMatch]" Column="docid" />
- </OuterReferences>
- <RelOp AvgRowSize="15" EstimateCPU="0.0033011" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Table-valued function" NodeId="5" Parallel="false" PhysicalOp="Table-valued function" EstimatedTotalSubtreeCost="0.0064261">
- <OutputList>
- <ColumnReference Table="[FulltextMatch]" Column="docid" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRebinds="1" ActualRewinds="0" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <TableValuedFunction>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Table="[FulltextMatch]" Column="docid" />
- </DefinedValue>
- </DefinedValues>
- <Object Table="[FulltextMatch]" />
- <ParameterList>
- <ScalarOperator ScalarString="(1)">
- <Const ConstValue="(1)" />
- </ScalarOperator>
- <ScalarOperator ScalarString="(1)">
- <Const ConstValue="(1)" />
- </ScalarOperator>
- <ScalarOperator ScalarString="(2)">
- <Const ConstValue="(2)" />
- </ScalarOperator>
- <ScalarOperator ScalarString="(0)">
- <Const ConstValue="(0)" />
- </ScalarOperator>
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </ParameterList>
- </TableValuedFunction>
- </RelOp>
- <RelOp AvgRowSize="537" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="12" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="14862">
- <OutputList>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="business_customer_id" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="company_contact" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="cvr_number" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="p_number" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="ean_number" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="business_customer_id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="company_contact" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="cvr_number" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="p_number" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="ean_number" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Index="[business_customer_pk]" Alias="[bc]" IndexKind="Clustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="business_customer_id" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="FulltextMatch.[docid]">
- <Identifier>
- <ColumnReference Table="[FulltextMatch]" Column="docid" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- <RelOp AvgRowSize="1897" EstimateCPU="1E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Compute Scalar" NodeId="13" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.0032832">
- <OutputList>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="customer_id" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name1" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name2" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name3" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name4" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="external_id" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="street" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="number" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="floor" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="door" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="zip_code" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="city" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="country" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="telephone" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="email" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="create_time" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="created_by_user_id" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="letter" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="external_id2" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="fullname1" ComputedColumn="true" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="fullname2" ComputedColumn="true" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="street_address" ComputedColumn="true" />
- </OutputList>
- <ComputeScalar>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="fullname1" ComputedColumn="true" />
- <ScalarOperator ScalarString="([cpt].[dbo].[customer].[name1] as [c].[name1]+' ')+[cpt].[dbo].[customer].[name2] as [c].[name2]">
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name1" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="' '" />
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name2" />
- </Identifier>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="fullname2" ComputedColumn="true" />
- <ScalarOperator ScalarString="([cpt].[dbo].[customer].[name3] as [c].[name3]+' ')+[cpt].[dbo].[customer].[name4] as [c].[name4]">
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name3" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="' '" />
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name4" />
- </Identifier>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="street_address" ComputedColumn="true" />
- <ScalarOperator ScalarString="(((([cpt].[dbo].[customer].[street] as [c].[street]+' ')+[cpt].[dbo].[customer].[number] as [c].[number])+CASE WHEN (' '+[cpt].[dbo].[customer].[letter] as [c].[letter]) IS NOT NULL THEN ' '+[cpt].[dbo].[customer].[letter] as [c].[letter] ELSE '' END)+CASE WHEN (', '+[cpt].[dbo].[customer].[floor] as [c].[floor]) IS NOT NULL THEN ', '+[cpt].[dbo].[customer].[floor] as [c].[floor] ELSE '' END)+CASE WHEN (' '+[cpt].[dbo].[customer].[door] as [c].[door]) IS NOT NULL THEN ' '+[cpt].[dbo].[customer].[door] as [c].[door] ELSE '' END">
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="street" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="' '" />
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="number" />
- </Identifier>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- <ScalarOperator>
- <IF>
- <Condition>
- <ScalarOperator>
- <Compare CompareOp="IS NOT">
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Const ConstValue="' '" />
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="letter" />
- </Identifier>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Condition>
- <Then>
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Const ConstValue="' '" />
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="letter" />
- </Identifier>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- </Then>
- <Else>
- <ScalarOperator>
- <Const ConstValue="''" />
- </ScalarOperator>
- </Else>
- </IF>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- <ScalarOperator>
- <IF>
- <Condition>
- <ScalarOperator>
- <Compare CompareOp="IS NOT">
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Const ConstValue="', '" />
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="floor" />
- </Identifier>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Condition>
- <Then>
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Const ConstValue="', '" />
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="floor" />
- </Identifier>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- </Then>
- <Else>
- <ScalarOperator>
- <Const ConstValue="''" />
- </ScalarOperator>
- </Else>
- </IF>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- <ScalarOperator>
- <IF>
- <Condition>
- <ScalarOperator>
- <Compare CompareOp="IS NOT">
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Const ConstValue="' '" />
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="door" />
- </Identifier>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Condition>
- <Then>
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Const ConstValue="' '" />
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="door" />
- </Identifier>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- </Then>
- <Else>
- <ScalarOperator>
- <Const ConstValue="''" />
- </ScalarOperator>
- </Else>
- </IF>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="1193" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="14" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="101387">
- <OutputList>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="customer_id" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name1" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name2" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name3" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name4" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="external_id" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="street" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="number" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="floor" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="door" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="zip_code" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="city" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="country" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="telephone" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="email" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="create_time" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="created_by_user_id" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="letter" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="external_id2" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="customer_id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name1" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name2" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name3" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name4" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="external_id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="street" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="number" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="floor" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="door" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="zip_code" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="city" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="country" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="telephone" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="email" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="create_time" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="created_by_user_id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="letter" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="external_id2" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[cpt]" Schema="[dbo]" Table="[customer]" Index="[pk_customer]" Alias="[c]" IndexKind="Clustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="customer_id" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="FulltextMatch.[docid]">
- <Identifier>
- <ColumnReference Table="[FulltextMatch]" Column="docid" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </ComputeScalar>
- </RelOp>
- </NestedLoops>
- </RelOp>
- </ComputeScalar>
- </RelOp>
- </StreamAggregate>
- </RelOp>
- </QueryPlan>
- </StmtSimple>
- </Statements>
- </Batch>
- <Batch>
- <Statements>
- <StmtSimple StatementCompId="3" StatementEstRows="13036.4" StatementId="3" StatementOptmLevel="FULL" StatementSubTreeCost="94.8262" StatementText="SELECT * FROM customer c
INNER JOIN business_customer bc on c.customer_id=bc.business_customer_id
WHERE
 CONTAINS(c.*, '"noresult"')
 OR CONTAINS(bc.*, '"noresult"');" StatementType="SELECT" QueryHash="0xEB5AD7E71F33BB0C" QueryPlanHash="0x243F418831696A6B">
- <StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" />
- <QueryPlan DegreeOfParallelism="1" CachedPlanSize="72" CompileTime="19" CompileCPU="19" CompileMemory="624">
- <RelOp AvgRowSize="2426" EstimateCPU="0.0605468" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="13036.4" LogicalOp="Left Semi Join" NodeId="0" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="94.8262">
- <OutputList>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="customer_id" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name1" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name2" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name3" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name4" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="external_id" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="street" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="number" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="floor" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="door" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="zip_code" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="city" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="country" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="telephone" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="email" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="create_time" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="created_by_user_id" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="letter" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="external_id2" />
- <ColumnReference Table="[c]" Column="fullname1" ComputedColumn="true" />
- <ColumnReference Table="[c]" Column="fullname2" ComputedColumn="true" />
- <ColumnReference Table="[c]" Column="street_address" ComputedColumn="true" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="business_customer_id" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="company_contact" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="cvr_number" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="p_number" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="ean_number" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <NestedLoops Optimized="false">
- <OuterReferences>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="customer_id" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="business_customer_id" />
- </OuterReferences>
- <RelOp AvgRowSize="2426" EstimateCPU="0.251171" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="14484.9" LogicalOp="Inner Join" NodeId="1" Parallel="false" PhysicalOp="Merge Join" EstimatedTotalSubtreeCost="1.68293">
- <OutputList>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="customer_id" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name1" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name2" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name3" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name4" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="external_id" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="street" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="number" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="floor" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="door" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="zip_code" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="city" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="country" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="telephone" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="email" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="create_time" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="created_by_user_id" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="letter" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="external_id2" />
- <ColumnReference Table="[c]" Column="fullname1" ComputedColumn="true" />
- <ColumnReference Table="[c]" Column="fullname2" ComputedColumn="true" />
- <ColumnReference Table="[c]" Column="street_address" ComputedColumn="true" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="business_customer_id" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="company_contact" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="cvr_number" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="p_number" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="ean_number" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="14862" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <Merge ManyToMany="false">
- <InnerSideJoinColumns>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="customer_id" />
- </InnerSideJoinColumns>
- <OuterSideJoinColumns>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="business_customer_id" />
- </OuterSideJoinColumns>
- <Residual>
- <ScalarOperator ScalarString="[cpt].[dbo].[customer].[customer_id] as [c].[customer_id]=[cpt].[dbo].[business_customer].[business_customer_id] as [bc].[business_customer_id]">
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="customer_id" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="business_customer_id" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Residual>
- <RelOp AvgRowSize="537" EstimateCPU="0.0165052" EstimateIO="0.0349769" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="14862" LogicalOp="Clustered Index Scan" NodeId="2" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0514821" TableCardinality="14862">
- <OutputList>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="business_customer_id" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="company_contact" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="cvr_number" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="p_number" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="ean_number" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="14862" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="business_customer_id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="company_contact" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="cvr_number" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="p_number" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="ean_number" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Index="[business_customer_pk]" Alias="[bc]" IndexKind="Clustered" />
- </IndexScan>
- </RelOp>
- <RelOp AvgRowSize="1897" EstimateCPU="0.0101387" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="101387" LogicalOp="Compute Scalar" NodeId="3" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="1.38027">
- <OutputList>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="customer_id" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name1" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name2" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name3" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name4" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="external_id" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="street" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="number" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="floor" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="door" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="zip_code" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="city" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="country" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="telephone" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="email" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="create_time" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="created_by_user_id" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="letter" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="external_id2" />
- <ColumnReference Table="[c]" Column="fullname1" ComputedColumn="true" />
- <ColumnReference Table="[c]" Column="fullname2" ComputedColumn="true" />
- <ColumnReference Table="[c]" Column="street_address" ComputedColumn="true" />
- </OutputList>
- <ComputeScalar>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Table="[c]" Column="fullname1" ComputedColumn="true" />
- <ScalarOperator ScalarString="[cpt].[dbo].[customer].[fullname1] as [c].[fullname1]">
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="fullname1" ComputedColumn="true" />
- </Identifier>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Table="[c]" Column="fullname2" ComputedColumn="true" />
- <ScalarOperator ScalarString="[cpt].[dbo].[customer].[fullname2] as [c].[fullname2]">
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="fullname2" ComputedColumn="true" />
- </Identifier>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Table="[c]" Column="street_address" ComputedColumn="true" />
- <ScalarOperator ScalarString="[cpt].[dbo].[customer].[street_address] as [c].[street_address]">
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="street_address" ComputedColumn="true" />
- </Identifier>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="1897" EstimateCPU="0.0101387" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="101387" LogicalOp="Compute Scalar" NodeId="4" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="1.37013">
- <OutputList>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="customer_id" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name1" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name2" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name3" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name4" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="external_id" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="street" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="number" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="floor" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="door" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="zip_code" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="city" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="country" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="telephone" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="email" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="create_time" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="created_by_user_id" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="letter" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="external_id2" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="fullname1" ComputedColumn="true" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="fullname2" ComputedColumn="true" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="street_address" ComputedColumn="true" />
- </OutputList>
- <ComputeScalar>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="fullname1" ComputedColumn="true" />
- <ScalarOperator ScalarString="([cpt].[dbo].[customer].[name1] as [c].[name1]+' ')+[cpt].[dbo].[customer].[name2] as [c].[name2]">
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name1" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="' '" />
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name2" />
- </Identifier>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="fullname2" ComputedColumn="true" />
- <ScalarOperator ScalarString="([cpt].[dbo].[customer].[name3] as [c].[name3]+' ')+[cpt].[dbo].[customer].[name4] as [c].[name4]">
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name3" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="' '" />
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name4" />
- </Identifier>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="street_address" ComputedColumn="true" />
- <ScalarOperator ScalarString="(((([cpt].[dbo].[customer].[street] as [c].[street]+' ')+[cpt].[dbo].[customer].[number] as [c].[number])+CASE WHEN (' '+[cpt].[dbo].[customer].[letter] as [c].[letter]) IS NOT NULL THEN ' '+[cpt].[dbo].[customer].[letter] as [c].[letter] ELSE '' END)+CASE WHEN (', '+[cpt].[dbo].[customer].[floor] as [c].[floor]) IS NOT NULL THEN ', '+[cpt].[dbo].[customer].[floor] as [c].[floor] ELSE '' END)+CASE WHEN (' '+[cpt].[dbo].[customer].[door] as [c].[door]) IS NOT NULL THEN ' '+[cpt].[dbo].[customer].[door] as [c].[door] ELSE '' END">
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="street" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="' '" />
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="number" />
- </Identifier>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- <ScalarOperator>
- <IF>
- <Condition>
- <ScalarOperator>
- <Compare CompareOp="IS NOT">
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Const ConstValue="' '" />
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="letter" />
- </Identifier>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Condition>
- <Then>
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Const ConstValue="' '" />
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="letter" />
- </Identifier>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- </Then>
- <Else>
- <ScalarOperator>
- <Const ConstValue="''" />
- </ScalarOperator>
- </Else>
- </IF>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- <ScalarOperator>
- <IF>
- <Condition>
- <ScalarOperator>
- <Compare CompareOp="IS NOT">
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Const ConstValue="', '" />
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="floor" />
- </Identifier>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Condition>
- <Then>
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Const ConstValue="', '" />
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="floor" />
- </Identifier>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- </Then>
- <Else>
- <ScalarOperator>
- <Const ConstValue="''" />
- </ScalarOperator>
- </Else>
- </IF>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- <ScalarOperator>
- <IF>
- <Condition>
- <ScalarOperator>
- <Compare CompareOp="IS NOT">
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Const ConstValue="' '" />
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="door" />
- </Identifier>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Condition>
- <Then>
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Const ConstValue="' '" />
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="door" />
- </Identifier>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- </Then>
- <Else>
- <ScalarOperator>
- <Const ConstValue="''" />
- </ScalarOperator>
- </Else>
- </IF>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="1193" EstimateCPU="0.111683" EstimateIO="1.24831" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="101387" LogicalOp="Clustered Index Scan" NodeId="5" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="1.35999" TableCardinality="101387">
- <OutputList>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="customer_id" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name1" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name2" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name3" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name4" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="external_id" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="street" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="number" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="floor" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="door" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="zip_code" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="city" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="country" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="telephone" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="email" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="create_time" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="created_by_user_id" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="letter" />
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="external_id2" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="101387" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="customer_id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name1" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name2" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name3" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="name4" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="external_id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="street" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="number" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="floor" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="door" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="zip_code" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="city" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="country" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="telephone" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="email" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="create_time" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="created_by_user_id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="letter" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="external_id2" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[cpt]" Schema="[dbo]" Table="[customer]" Index="[pk_customer]" Alias="[c]" IndexKind="Clustered" />
- </IndexScan>
- </RelOp>
- </ComputeScalar>
- </RelOp>
- </ComputeScalar>
- </RelOp>
- </Merge>
- </RelOp>
- <RelOp AvgRowSize="9" EstimateCPU="2E-07" EstimateIO="0" EstimateRebinds="14483.9" EstimateRewinds="0" EstimateRows="1" LogicalOp="Concatenation" NodeId="21" Parallel="false" PhysicalOp="Concatenation" EstimatedTotalSubtreeCost="93.0828">
- <OutputList />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="14862" ActualExecutions="14862" />
- </RunTimeInformation>
- <Concat>
- <DefinedValues />
- <RelOp AvgRowSize="9" EstimateCPU="0.0033011" EstimateIO="0.003125" EstimateRebinds="14483.9" EstimateRewinds="0" EstimateRows="1" LogicalOp="Table-valued function" NodeId="22" Parallel="false" PhysicalOp="Table-valued function" EstimatedTotalSubtreeCost="93.0813">
- <OutputList />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRebinds="14862" ActualRewinds="0" ActualRows="0" ActualEndOfScans="14862" ActualExecutions="14862" />
- </RunTimeInformation>
- <TableValuedFunction>
- <DefinedValues />
- <Object Table="[FulltextMatch]" />
- <ParameterList>
- <ScalarOperator ScalarString="(1)">
- <Const ConstValue="(1)" />
- </ScalarOperator>
- <ScalarOperator ScalarString="(1)">
- <Const ConstValue="(1)" />
- </ScalarOperator>
- <ScalarOperator ScalarString="(2)">
- <Const ConstValue="(2)" />
- </ScalarOperator>
- <ScalarOperator ScalarString="(15)">
- <Const ConstValue="(15)" />
- </ScalarOperator>
- <ScalarOperator ScalarString="[cpt].[dbo].[customer].[customer_id] as [c].[customer_id]">
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="customer_id" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator ScalarString="[cpt].[dbo].[customer].[customer_id] as [c].[customer_id]">
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[customer]" Alias="[c]" Column="customer_id" />
- </Identifier>
- </ScalarOperator>
- </ParameterList>
- </TableValuedFunction>
- </RelOp>
- <RelOp AvgRowSize="9" EstimateCPU="0.0033011" EstimateIO="0.003125" EstimateRebinds="14483.9" EstimateRewinds="0" EstimateRows="1" LogicalOp="Table-valued function" NodeId="29" Parallel="false" PhysicalOp="Table-valued function" EstimatedTotalSubtreeCost="93.0813">
- <OutputList />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRebinds="14862" ActualRewinds="0" ActualRows="0" ActualEndOfScans="14862" ActualExecutions="14862" />
- </RunTimeInformation>
- <TableValuedFunction>
- <DefinedValues />
- <Object Table="[FulltextMatch]" />
- <ParameterList>
- <ScalarOperator ScalarString="(2)">
- <Const ConstValue="(2)" />
- </ScalarOperator>
- <ScalarOperator ScalarString="(1)">
- <Const ConstValue="(1)" />
- </ScalarOperator>
- <ScalarOperator ScalarString="(2)">
- <Const ConstValue="(2)" />
- </ScalarOperator>
- <ScalarOperator ScalarString="(15)">
- <Const ConstValue="(15)" />
- </ScalarOperator>
- <ScalarOperator ScalarString="[cpt].[dbo].[business_customer].[business_customer_id] as [bc].[business_customer_id]">
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="business_customer_id" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator ScalarString="[cpt].[dbo].[business_customer].[business_customer_id] as [bc].[business_customer_id]">
- <Identifier>
- <ColumnReference Database="[cpt]" Schema="[dbo]" Table="[business_customer]" Alias="[bc]" Column="business_customer_id" />
- </Identifier>
- </ScalarOperator>
- </ParameterList>
- </TableValuedFunction>
- </RelOp>
- </Concat>
- </RelOp>
- </NestedLoops>
- </RelOp>
- </QueryPlan>
- </StmtSimple>
- </Statements>
- </Batch>
- </BatchSequence>
- </ShowPlanXML>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement