Добро пожаловать в форум, Guest  >>   Войти | Регистрация | Поиск | Правила | В избранное | Подписаться
Все форумы / Microsoft SQL Server Новый топик    Ответить
 Подскажите по гиду плана запроса  [new]
volf153
Member

Откуда:
Сообщений: 8
Столкнулся с такой проблемой: SQL server иногда генерирует неоптимальный план запроса, в следствии чего время выполнения возрастает многократно.
Возможности поправить код нет (1с). Пробовал создание гида плана запроса, но такое впечатление, что он не используется. Поправьте, если я что не так делаю.
сам запрос, который я взял из профайлера (парметры меняются):
exec sp_executesql N'SELECT
0x0000022E,
T1._Document558_IDRRef,
T1._Fld14039RRef,
T1._Fld14051RRef,
T1._Fld14050RRef,
CAST(SUM((T1._Fld14044 * T1._Fld14043)) AS NUMERIC(33, 8)),
T1._Fld14056RRef
FROM _Document558_VT14037 T1
WHERE T1._Document558_IDRRef IN
(SELECT
CASE WHEN T2._Fld7019_TYPE = 0x08 AND T2._Fld7019_RTRef = @P1 THEN T2._Fld7019_RRRef END AS Q_002_F_000RRef
FROM _Document384_VT7004 T2
WHERE (T2._Document384_IDRRef = @P2) AND (T2._Fld7019_TYPE = 0x08 AND T2._Fld7019_RTRef = @P3)) AND T1._Fld14039RRef IN
(SELECT
T3._Fld7007RRef AS Q_003_F_000RRef
FROM _Document384_VT7004 T3
WHERE (T3._Document384_IDRRef = @P4) AND (T3._Fld7019_TYPE = 0x08 AND T3._Fld7019_RTRef = @P5))
GROUP BY T1._Document558_IDRRef,
T1._Fld14039RRef,
T1._Fld14051RRef,
T1._Fld14050RRef,
T1._Fld14056RRef
UNION ALL SELECT
0x0000014A,
T4._Document330_IDRRef,
T4._Fld4783RRef,
T4._Fld4792RRef,
T4._Fld4793RRef,
CAST(SUM((T4._Fld4788 * T4._Fld4787)) AS NUMERIC(33, 8)),
T4._Fld4800RRef
FROM _Document330_VT4776 T4
WHERE T4._Document330_IDRRef IN
(SELECT
CASE WHEN T5._Fld7019_TYPE = 0x08 AND T5._Fld7019_RTRef = @P6 THEN T5._Fld7019_RRRef END AS Q_004_F_000RRef
FROM _Document384_VT7004 T5
WHERE (T5._Document384_IDRRef = @P7) AND (T5._Fld7019_TYPE = 0x08 AND T5._Fld7019_RTRef = @P8)) AND T4._Fld4783RRef IN
(SELECT
T6._Fld7007RRef AS Q_005_F_000RRef
FROM _Document384_VT7004 T6
WHERE (T6._Document384_IDRRef = @P9) AND (T6._Fld7019_TYPE = 0x08 AND T6._Fld7019_RTRef = @P10))
GROUP BY T4._Document330_IDRRef,
T4._Fld4783RRef,
T4._Fld4792RRef,
T4._Fld4793RRef,
T4._Fld4800RRef',N'@P1 varbinary(4),@P2 varbinary(16),@P3 varbinary(4),@P4 varbinary(16),@P5 varbinary(4),@P6 varbinary(4),@P7 varbinary(16),@P8 varbinary(4),@P9 varbinary(16),@P10 varbinary(4)',0x0000022E,0x916600155D848F0311E2F01370731D20,0x0000022E,0x916600155D848F0311E2F01370731D20,0x0000022E,0x0000014A,0x916600155D848F0311E2F01370731D20,0x0000014A,0x916600155D848F0311E2F01370731D20,0x0000014A


Создаю гид так:
EXEC sp_create_plan_guide N'Guide_plan_import_GTD', 
'SELECT
0x0000022E,
T1._Document558_IDRRef,
T1._Fld14039RRef,
T1._Fld14051RRef,
T1._Fld14050RRef,
CAST(SUM((T1._Fld14044 * T1._Fld14043)) AS NUMERIC(33, 8)),
T1._Fld14056RRef
FROM _Document558_VT14037 T1
WHERE T1._Document558_IDRRef IN
(SELECT
CASE WHEN T2._Fld7019_TYPE = 0x08 AND T2._Fld7019_RTRef = @P1 THEN T2._Fld7019_RRRef END AS Q_002_F_000RRef
FROM _Document384_VT7004 T2
WHERE (T2._Document384_IDRRef = @P2) AND (T2._Fld7019_TYPE = 0x08 AND T2._Fld7019_RTRef = @P3)) AND T1._Fld14039RRef IN
(SELECT
T3._Fld7007RRef AS Q_003_F_000RRef
FROM _Document384_VT7004 T3
WHERE (T3._Document384_IDRRef = @P4) AND (T3._Fld7019_TYPE = 0x08 AND T3._Fld7019_RTRef = @P5))
GROUP BY T1._Document558_IDRRef,
T1._Fld14039RRef,
T1._Fld14051RRef,
T1._Fld14050RRef,
T1._Fld14056RRef
UNION ALL SELECT
0x0000014A,
T4._Document330_IDRRef,
T4._Fld4783RRef,
T4._Fld4792RRef,
T4._Fld4793RRef,
CAST(SUM((T4._Fld4788 * T4._Fld4787)) AS NUMERIC(33, 8)),
T4._Fld4800RRef
FROM _Document330_VT4776 T4
WHERE T4._Document330_IDRRef IN
(SELECT
CASE WHEN T5._Fld7019_TYPE = 0x08 AND T5._Fld7019_RTRef = @P6 THEN T5._Fld7019_RRRef END AS Q_004_F_000RRef
FROM _Document384_VT7004 T5
WHERE (T5._Document384_IDRRef = @P7) AND (T5._Fld7019_TYPE = 0x08 AND T5._Fld7019_RTRef = @P8)) AND T4._Fld4783RRef IN
(SELECT
T6._Fld7007RRef AS Q_005_F_000RRef
FROM _Document384_VT7004 T6
WHERE (T6._Document384_IDRRef = @P9) AND (T6._Fld7019_TYPE = 0x08 AND T6._Fld7019_RTRef = @P10))
GROUP BY T4._Document330_IDRRef,
T4._Fld4783RRef,
T4._Fld4792RRef,
T4._Fld4793RRef,
T4._Fld4800RRef', 
N'SQL', 
NULL, 
N'@P1 varbinary(4),@P2 varbinary(16),@P3 varbinary(4),@P4 varbinary(16),@P5 varbinary(4),@P6 varbinary(4),@P7 varbinary(16),@P8 varbinary(4),@P9 varbinary(16),@P10 varbinary(4)', 
N'<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.2" Build="11.0.3128.0"><BatchSequence><Batch><Statements><StmtSimple StatementText="(@P1 varbinary(4),@P2 varbinary(16),@P3 varbinary(4),@P4 varbinary(16),@P5 varbinary(4),@P6 varbinary(4),@P7 varbinary(16),@P8 varbinary(4),@P9 varbinary(16),@P10 varbinary(4))SELECT&#xA;0x0000022E,&#xA;T1._Document558_IDRRef,&#xA;T1._Fld14039RRef,&#xA;T1._Fld14051RRef,&#xA;T1._Fld14050RRef,&#xA;CAST(SUM((T1._Fld14044 * T1._Fld14043)) AS NUMERIC(33, 8)),&#xA;T1._Fld14056RRef&#xA;FROM _Document558_VT14037 T1&#xA;WHERE T1._Document558_IDRRef IN&#xA;(SELECT&#xA;CASE WHEN T2._Fld7019_TYPE = 0x08 AND T2._Fld7019_RTRef = @P1 THEN T2._Fld7019_RRRef END AS Q_002_F_000RRef&#xA;FROM _Document384_VT7004 T2&#xA;WHERE (T2._Document384_IDRRef = @P2) AND (T2._Fld7019_TYPE = 0x08 AND T2._Fld7019_RTRef = @P3)) AND T1._Fld14039RRef IN&#xA;(SELECT&#xA;T3._Fld7007RRef AS Q_003_F_000RRef&#xA;FROM _Document384_VT7004 T3&#xA;WHERE (T3._Document384_IDRRef = @P4) AND (T3._Fld7019_TYPE = 0x08 AND T3._Fld7019_RTRef = @P5))&#xA;GROUP BY T1._Document558_IDRRef,&#xA;T1._Fld14039RRef,&#xA;T1._Fld14051RRef,&#xA;T1._Fld14050RRef,&#xA;T1._Fld14056RRef&#xA;UNION ALL SELECT&#xA;0x0000014A,&#xA;T4._Document330_IDRRef,&#xA;T4._Fld4783RRef,&#xA;T4._Fld4792RRef,&#xA;T4._Fld4793RRef,&#xA;CAST(SUM((T4._Fld4788 * T4._Fld4787)) AS NUMERIC(33, 8)),&#xA;T4._Fld4800RRef&#xA;FROM _Document330_VT4776 T4&#xA;WHERE T4._Document330_IDRRef IN&#xA;(SELECT&#xA;CASE WHEN T5._Fld7019_TYPE = 0x08 AND T5._Fld7019_RTRef = @P6 THEN T5._Fld7019_RRRef END AS Q_004_F_000RRef&#xA;FROM _Document384_VT7004 T5&#xA;WHERE (T5._Document384_IDRRef = @P7) AND (T5._Fld7019_TYPE = 0x08 AND T5._Fld7019_RTRef = @P8)) AND T4._Fld4783RRef IN&#xA;(SELECT&#xA;T6._Fld7007RRef AS Q_005_F_000RRef&#xA;FROM _Document384_VT7004 T6&#xA;WHERE (T6._Document384_IDRRef = @P9) AND (T6._Fld7019_TYPE = 0x08 AND T6._Fld7019_RTRef = @P10))&#xA;GROUP BY T4._Document330_IDRRef,&#xA;T4._Fld4783RRef,&#xA;T4._Fld4792RRef,&#xA;T4._Fld4793RRef,&#xA;T4._Fld4800RRef" StatementId="1" StatementCompId="1" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="2186.03" StatementEstRows="2729.69" StatementOptmLevel="FULL" QueryHash="0x78A0765252BF5E1E" QueryPlanHash="0x65FCD8970FEB64FF"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="false" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false" /><QueryPlan CachedPlanSize="136" CompileTime="165" CompileCPU="165" CompileMemory="2624"><ThreadStat Branches="2" /><MemoryGrantInfo SerialRequiredMemory="640" SerialDesiredMemory="1648" /><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="98304" EstimatedPagesCached="393216" EstimatedAvailableDegreeOfParallelism="32" /><RelOp NodeId="0" PhysicalOp="Concatenation" LogicalOp="Concatenation" EstimateRows="2729.69" EstimateIO="0" EstimateCPU="0.000272969" AvgRowSize="110" EstimatedTotalSubtreeCost="2186.03" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Union1020" /><ColumnReference Column="Union1021" /><ColumnReference Column="Union1022" /><ColumnReference Column="Union1023" /><ColumnReference Column="Union1024" /><ColumnReference Column="Union1025" /><ColumnReference Column="Union1026" /></OutputList><Concat><DefinedValues><DefinedValue><ColumnReference Column="Union1020" /><ColumnReference Column="Expr1008" /><ColumnReference Column="Expr1018" /></DefinedValue><DefinedValue><ColumnReference Column="Union1021" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Document558_IDRRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Document330_IDRRef" /></DefinedValue><DefinedValue><ColumnReference Column="Union1022" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14039RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Fld4783RRef" /></DefinedValue><DefinedValue><ColumnReference Column="Union1023" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14051RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Fld4792RRef" /></DefinedValue><DefinedValue><ColumnReference Column="Union1024" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14050RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Fld4793RRef" /></DefinedValue><DefinedValue><ColumnReference Column="Union1025" /><ColumnReference Column="Expr1009" /><ColumnReference Column="Expr1019" /></DefinedValue><DefinedValue><ColumnReference Column="Union1026" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14056RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Fld4800RRef" /></DefinedValue></DefinedValues><RelOp NodeId="1" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="2728.69" EstimateIO="0" EstimateCPU="0.000272869" AvgRowSize="110" EstimatedTotalSubtreeCost="2185.91" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Document558_IDRRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14039RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14050RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14051RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14056RRef" /><ColumnReference Column="Expr1008" /><ColumnReference Column="Expr1009" /></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1008" /><ScalarOperator ScalarString="0x0000022E"><Const ConstValue="0x0000022E" /></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1009" /><ScalarOperator ScalarString="CONVERT(numeric(33,8),[Expr1007],0)"><Convert DataType="numeric" Precision="33" Scale="8" Style="0" Implicit="0"><ScalarOperator><Identifier><ColumnReference Column="Expr1007" /></Identifier></ScalarOperator></Convert></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="2" PhysicalOp="Parallelism" LogicalOp="Gather Streams" EstimateRows="2728.69" EstimateIO="0" EstimateCPU="0.0294129" AvgRowSize="104" EstimatedTotalSubtreeCost="2185.91" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Document558_IDRRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14039RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14050RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14051RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14056RRef" /><ColumnReference Column="Expr1007" /></OutputList><Parallelism><RelOp NodeId="3" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="2728.69" EstimateIO="0" EstimateCPU="9.23513e-005" AvgRowSize="104" EstimatedTotalSubtreeCost="2185.88" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Document558_IDRRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14039RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14050RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14051RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14056RRef" /><ColumnReference Column="Expr1007" /></OutputList><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Expr1007" /><ScalarOperator ScalarString="SUM([Expr1029])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1029" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><GroupBy><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Document558_IDRRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14039RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14051RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14050RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14056RRef" /></GroupBy><RelOp NodeId="4" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="2686.58" EstimateIO="0.000351914" EstimateCPU="0.00149509" AvgRowSize="100" EstimatedTotalSubtreeCost="2185.88" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Document558_IDRRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14039RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14050RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14051RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14056RRef" /><ColumnReference Column="Expr1029" /></OutputList><MemoryFractions Input="0.746032" Output="1" /><Sort Distinct="0"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Document558_IDRRef" /></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14039RRef" /></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14051RRef" /></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14050RRef" /></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14056RRef" /></OrderByColumn></OrderBy><RelOp NodeId="5" PhysicalOp="Parallelism" LogicalOp="Repartition Streams" EstimateRows="2686.58" EstimateIO="0" EstimateCPU="0.029753" AvgRowSize="100" EstimatedTotalSubtreeCost="2185.88" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Document558_IDRRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14039RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14050RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14051RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14056RRef" /><ColumnReference Column="Expr1029" /></OutputList><Parallelism PartitioningType="Hash"><PartitionColumns><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Document558_IDRRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14039RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14051RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14050RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14056RRef" /></PartitionColumns><RelOp NodeId="6" PhysicalOp="Nested Loops" LogicalOp="Left Semi Join" EstimateRows="2686.58" EstimateIO="0" EstimateCPU="181.314" AvgRowSize="100" EstimatedTotalSubtreeCost="2185.85" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Document558_IDRRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14039RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14050RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14051RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14056RRef" /><ColumnReference Column="Expr1029" /></OutputList><NestedLoops Optimized="0"><Predicate><ScalarOperator ScalarString="[upp_msmr].[dbo].[_Document558_VT14037].[_Document558_IDRRef] as [T1].[_Document558_IDRRef]=CASE WHEN [upp_msmr].[dbo].[_Document384_VT7004].[_Fld7019_TYPE] as [T2].[_Fld7019_TYPE]=0x08 AND [upp_msmr].[dbo].[_Document384_VT7004].[_Fld7019_RTRef] as [T2].[_Fld7019_RTRef]=[@P1] THEN [upp_msmr].[dbo].[_Document384_VT7004].[_Fld7019_RRRef] as [T2].[_Fld7019_RRRef] ELSE NULL END"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Document558_IDRRef" /></Identifier></ScalarOperator><ScalarOperator><IF><Condition><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Alias="[T2]" Column="_Fld7019_TYPE" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="0x08" /></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Alias="[T2]" Column="_Fld7019_RTRef" /></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="@P1" /></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Alias="[T2]" Column="_Fld7019_RRRef" /></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL" /></ScalarOperator></Else></IF></ScalarOperator></Compare></ScalarOperator></Predicate><RelOp NodeId="7" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="754896" EstimateIO="0" EstimateCPU="0.00235905" AvgRowSize="100" EstimatedTotalSubtreeCost="13.0567" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Document558_IDRRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14039RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14050RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14051RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14056RRef" /><ColumnReference Column="Expr1029" /></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1029" /><ScalarOperator ScalarString="[upp_msmr].[dbo].[_Document558_VT14037].[_Fld14044] as [T1].[_Fld14044]*[upp_msmr].[dbo].[_Document558_VT14037].[_Fld14043] as [T1].[_Fld14043]"><Arithmetic Operation="MULT"><ScalarOperator><Identifier><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14044" /></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14043" /></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="8" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="754896" EstimateIO="0" EstimateCPU="0.0986083" AvgRowSize="105" EstimatedTotalSubtreeCost="13.0543" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Document558_IDRRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14039RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14044" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14043" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14050RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14051RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14056RRef" /></OutputList><NestedLoops Optimized="0" WithUnorderedPrefetch="1"><OuterReferences><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Alias="[T3]" Column="_Fld7007RRef" /><ColumnReference Column="Expr1104" /></OuterReferences><RelOp NodeId="10" PhysicalOp="Sort" LogicalOp="Distinct Sort" EstimateRows="561.309" EstimateIO="0.000351914" EstimateCPU="0.000977171" AvgRowSize="23" EstimatedTotalSubtreeCost="0.100206" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Alias="[T3]" Column="_Fld7007RRef" /></OutputList><MemoryFractions Input="1" Output="0.253968" /><Sort Distinct="1"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Alias="[T3]" Column="_Fld7007RRef" /></OrderByColumn></OrderBy><RelOp NodeId="11" PhysicalOp="Parallelism" LogicalOp="Repartition Streams" EstimateRows="1842.01" EstimateIO="0" EstimateCPU="0.0287198" AvgRowSize="23" EstimatedTotalSubtreeCost="0.0988766" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Alias="[T3]" Column="_Fld7007RRef" /></OutputList><Parallelism PartitioningType="Hash"><PartitionColumns><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Alias="[T3]" Column="_Fld7007RRef" /></PartitionColumns><RelOp NodeId="12" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1842.01" EstimateIO="0.0700379" EstimateCPU="6.82254e-005" AvgRowSize="28" EstimatedTotalSubtreeCost="0.0701061" TableCardinality="818184" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Alias="[T3]" Column="_Fld7007RRef" /></OutputList><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Alias="[T3]" Column="_Fld7007RRef" /></DefinedValue></DefinedValues><Object Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Index="[_Documen384_VT7004_IntKeyInd]" Alias="[T3]" IndexKind="Clustered" /><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Alias="[T3]" Column="_Document384_IDRRef" /></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[@P4]"><Identifier><ColumnReference Column="@P4" /></Identifier></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates><Predicate><ScalarOperator ScalarString="[upp_msmr].[dbo].[_Document384_VT7004].[_Fld7019_RTRef] as [T3].[_Fld7019_RTRef]=[@P5] AND [upp_msmr].[dbo].[_Document384_VT7004].[_Fld7019_TYPE] as [T3].[_Fld7019_TYPE]=0x08"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Alias="[T3]" Column="_Fld7019_RTRef" /></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="@P5" /></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Alias="[T3]" Column="_Fld7019_TYPE" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="0x08" /></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Parallelism></RelOp></Sort></RelOp><RelOp NodeId="13" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="1344.89" EstimateIO="0.0216435" EstimateCPU="0.00163637" AvgRowSize="105" EstimatedTotalSubtreeCost="12.8555" TableCardinality="920093" Parallel="1" EstimateRebinds="560.309" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Document558_IDRRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14039RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14044" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14043" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14050RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14051RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14056RRef" /></OutputList><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Document558_IDRRef" /></DefinedValue><DefinedValue><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14039RRef" /></DefinedValue><DefinedValue><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14044" /></DefinedValue><DefinedValue><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14043" /></DefinedValue><DefinedValue><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14050RRef" /></DefinedValue><DefinedValue><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14051RRef" /></DefinedValue><DefinedValue><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14056RRef" /></DefinedValue></DefinedValues><Object Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Index="[IDX_Document558_VT14037_Fld14039RRef)]" Alias="[T1]" IndexKind="NonClustered" /><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document558_VT14037]" Alias="[T1]" Column="_Fld14039RRef" /></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[upp_msmr].[dbo].[_Document384_VT7004].[_Fld7007RRef] as [T3].[_Fld7007RRef]"><Identifier><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Alias="[T3]" Column="_Fld7007RRef" /></Identifier></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp></NestedLoops></RelOp></ComputeScalar></RelOp><RelOp NodeId="17" PhysicalOp="Table Spool" LogicalOp="Lazy Spool" EstimateRows="1842.01" EstimateIO="0.01" EstimateCPU="0.000431862" AvgRowSize="28" EstimatedTotalSubtreeCost="325.812" Parallel="1" EstimateRebinds="0" EstimateRewinds="754895" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Alias="[T2]" Column="_Fld7019_TYPE" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Alias="[T2]" Column="_Fld7019_RTRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Alias="[T2]" Column="_Fld7019_RRRef" /></OutputList><Spool><RelOp NodeId="18" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="1842.01" EstimateIO="0.0152953" EstimateCPU="0.00218321" AvgRowSize="28" EstimatedTotalSubtreeCost="0.0174785" TableCardinality="818184" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Alias="[T2]" Column="_Fld7019_TYPE" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Alias="[T2]" Column="_Fld7019_RTRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Alias="[T2]" Column="_Fld7019_RRRef" /></OutputList><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Alias="[T2]" Column="_Fld7019_TYPE" /></DefinedValue><DefinedValue><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Alias="[T2]" Column="_Fld7019_RTRef" /></DefinedValue><DefinedValue><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Alias="[T2]" Column="_Fld7019_RRRef" /></DefinedValue></DefinedValues><Object Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Index="[IDX__Document384_VT7004_Document384_IDRRef_Fld7019_TYPE_Fld7019_RTRef]" Alias="[T2]" IndexKind="NonClustered" /><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Alias="[T2]" Column="_Document384_IDRRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Alias="[T2]" Column="_Fld7019_TYPE" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Alias="[T2]" Column="_Fld7019_RTRef" /></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[@P2]"><Identifier><ColumnReference Column="@P2" /></Identifier></ScalarOperator><ScalarOperator ScalarString="0x08"><Const ConstValue="0x08" /></ScalarOperator><ScalarOperator ScalarString="[@P3]"><Identifier><ColumnReference Column="@P3" /></Identifier></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp></Spool></RelOp></NestedLoops></RelOp></Parallelism></RelOp></Sort></RelOp></StreamAggregate></RelOp></Parallelism></RelOp></ComputeScalar></RelOp><RelOp NodeId="28" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-007" AvgRowSize="110" EstimatedTotalSubtreeCost="0.123128" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Document330_IDRRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Fld4783RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Fld4792RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Fld4793RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Fld4800RRef" /><ColumnReference Column="Expr1018" /><ColumnReference Column="Expr1019" /></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1018" /><ScalarOperator ScalarString="0x0000014A"><Const ConstValue="0x0000014A" /></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1019" /><ScalarOperator ScalarString="CONVERT(numeric(33,8),[Expr1017],0)"><Convert DataType="numeric" Precision="33" Scale="8" Style="0" Implicit="0"><ScalarOperator><Identifier><ColumnReference Column="Expr1017" /></Identifier></ScalarOperator></Convert></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="29" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="1.1e-006" AvgRowSize="104" EstimatedTotalSubtreeCost="0.123128" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Document330_IDRRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Fld4783RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Fld4792RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Fld4793RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Fld4800RRef" /><ColumnReference Column="Expr1017" /></OutputList><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Expr1017" /><ScalarOperator ScalarString="SUM([Expr1030])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1030" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><GroupBy><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Document330_IDRRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Fld4783RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Fld4792RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Fld4793RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Fld4800RRef" /></GroupBy><RelOp NodeId="31" PhysicalOp="Sort" LogicalOp="Distinct Sort" EstimateRows="1" EstimateIO="0.0112613" EstimateCPU="0.000100104" AvgRowSize="100" EstimatedTotalSubtreeCost="0.123127" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Document330_IDRRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Fld4783RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Fld4792RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Fld4793RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Fld4800RRef" /><ColumnReference Column="Expr1030" /></OutputList><MemoryFractions Input="1" Output="1" /><Sort Distinct="1"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Document330_IDRRef" /></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Fld4783RRef" /></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Fld4792RRef" /></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Fld4793RRef" /></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Fld4800RRef" /></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_KeyField" /></OrderByColumn></OrderBy><RelOp NodeId="32" PhysicalOp="Nested Loops" LogicalOp="Left Semi Join" EstimateRows="1" EstimateIO="0" EstimateCPU="4.95e-006" AvgRowSize="104" EstimatedTotalSubtreeCost="0.111766" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Document330_IDRRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_KeyField" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Fld4783RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Fld4792RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Fld4793RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Fld4800RRef" /><ColumnReference Column="Expr1030" /></OutputList><NestedLoops Optimized="0"><Predicate><ScalarOperator ScalarString="[upp_msmr].[dbo].[_Document330_VT4776].[_Document330_IDRRef] as [T4].[_Document330_IDRRef]=CASE WHEN [upp_msmr].[dbo].[_Document384_VT7004].[_Fld7019_TYPE] as [T5].[_Fld7019_TYPE]=0x08 AND [upp_msmr].[dbo].[_Document384_VT7004].[_Fld7019_RTRef] as [T5].[_Fld7019_RTRef]=[@P6] THEN [upp_msmr].[dbo].[_Document384_VT7004].[_Fld7019_RRRef] as [T5].[_Fld7019_RRRef] ELSE NULL END"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Document330_IDRRef" /></Identifier></ScalarOperator><ScalarOperator><IF><Condition><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Alias="[T5]" Column="_Fld7019_TYPE" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="0x08" /></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Alias="[T5]" Column="_Fld7019_RTRef" /></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="@P6" /></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Alias="[T5]" Column="_Fld7019_RRRef" /></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL" /></ScalarOperator></Else></IF></ScalarOperator></Compare></ScalarOperator></Predicate><RelOp NodeId="33" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1.18421" EstimateIO="0" EstimateCPU="0.0024453" AvgRowSize="104" EstimatedTotalSubtreeCost="0.108447" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Document330_IDRRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_KeyField" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Fld4783RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Fld4792RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Fld4793RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Fld4800RRef" /><ColumnReference Column="Expr1030" /></OutputList><NestedLoops Optimized="0"><Predicate><ScalarOperator ScalarString="[upp_msmr].[dbo].[_Document330_VT4776].[_Fld4783RRef] as [T4].[_Fld4783RRef]=[upp_msmr].[dbo].[_Document384_VT7004].[_Fld7007RRef] as [T6].[_Fld7007RRef]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Fld4783RRef" /></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Alias="[T6]" Column="_Fld7007RRef" /></Identifier></ScalarOperator></Compare></ScalarOperator></Predicate><RelOp NodeId="34" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="585" EstimateIO="0" EstimateCPU="5.85e-005" AvgRowSize="104" EstimatedTotalSubtreeCost="0.0306507" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Document330_IDRRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_KeyField" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Fld4783RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Fld4792RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Fld4793RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Fld4800RRef" /><ColumnReference Column="Expr1030" /></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1030" /><ScalarOperator ScalarString="[upp_msmr].[dbo].[_Document330_VT4776].[_Fld4788] as [T4].[_Fld4788]*[upp_msmr].[dbo].[_Document330_VT4776].[_Fld4787] as [T4].[_Fld4787]"><Arithmetic Operation="MULT"><ScalarOperator><Identifier><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Fld4788" /></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Fld4787" /></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="35" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="585" EstimateIO="0.0297917" EstimateCPU="0.0008005" AvgRowSize="109" EstimatedTotalSubtreeCost="0.0305922" TableCardinality="585" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Document330_IDRRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_KeyField" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Fld4783RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Fld4787" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Fld4788" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Fld4792RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Fld4793RRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Fld4800RRef" /></OutputList><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Document330_IDRRef" /></DefinedValue><DefinedValue><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_KeyField" /></DefinedValue><DefinedValue><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Fld4783RRef" /></DefinedValue><DefinedValue><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Fld4787" /></DefinedValue><DefinedValue><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Fld4788" /></DefinedValue><DefinedValue><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Fld4792RRef" /></DefinedValue><DefinedValue><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Fld4793RRef" /></DefinedValue><DefinedValue><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Alias="[T4]" Column="_Fld4800RRef" /></DefinedValue></DefinedValues><Object Database="[upp_msmr]" Schema="[dbo]" Table="[_Document330_VT4776]" Index="[_Documen330_VT4776_IntKeyInd]" Alias="[T4]" IndexKind="Clustered" /></IndexScan></RelOp></ComputeScalar></RelOp><RelOp NodeId="39" PhysicalOp="Table Spool" LogicalOp="Lazy Spool" EstimateRows="1" EstimateIO="0.01" EstimateCPU="0.00010028" AvgRowSize="23" EstimatedTotalSubtreeCost="0.0751758" Parallel="0" EstimateRebinds="0" EstimateRewinds="584" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Alias="[T6]" Column="_Fld7007RRef" /></OutputList><Spool><RelOp NodeId="40" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" EstimateCPU="4.18e-006" AvgRowSize="23" EstimatedTotalSubtreeCost="0.00657038" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Alias="[T6]" Column="_Fld7007RRef" /></OutputList><NestedLoops Optimized="0"><OuterReferences><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Alias="[T6]" Column="_Document384_IDRRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Alias="[T6]" Column="_KeyField" /></OuterReferences><RelOp NodeId="41" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="27" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="818184" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Alias="[T6]" Column="_Document384_IDRRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Alias="[T6]" Column="_KeyField" /></OutputList><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Alias="[T6]" Column="_Document384_IDRRef" /></DefinedValue><DefinedValue><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Alias="[T6]" Column="_KeyField" /></DefinedValue></DefinedValues><Object Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Index="[IDX__Document384_VT7004_Document384_IDRRef_Fld7019_TYPE_Fld7019_RTRef]" Alias="[T6]" IndexKind="NonClustered" /><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Alias="[T6]" Column="_Document384_IDRRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Alias="[T6]" Column="_Fld7019_TYPE" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Alias="[T6]" Column="_Fld7019_RTRef" /></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[@P9]"><Identifier><ColumnReference Column="@P9" /></Identifier></ScalarOperator><ScalarOperator ScalarString="0x08"><Const ConstValue="0x08" /></ScalarOperator><ScalarOperator ScalarString="[@P10]"><Identifier><ColumnReference Column="@P10" /></Identifier></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp><RelOp NodeId="43" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="23" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="818184" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Alias="[T6]" Column="_Fld7007RRef" /></OutputList><IndexScan Lookup="1" Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Alias="[T6]" Column="_Fld7007RRef" /></DefinedValue></DefinedValues><Object Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Index="[_Documen384_VT7004_IntKeyInd]" Alias="[T6]" TableReferenceId="-1" IndexKind="Clustered" /><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Alias="[T6]" Column="_Document384_IDRRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Alias="[T6]" Column="_KeyField" /></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[upp_msmr].[dbo].[_Document384_VT7004].[_Document384_IDRRef] as [T6].[_Document384_IDRRef]"><Identifier><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Alias="[T6]" Column="_Document384_IDRRef" /></Identifier></ScalarOperator><ScalarOperator ScalarString="[upp_msmr].[dbo].[_Document384_VT7004].[_KeyField] as [T6].[_KeyField]"><Identifier><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Alias="[T6]" Column="_KeyField" /></Identifier></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp></NestedLoops></RelOp></Spool></RelOp></NestedLoops></RelOp><RelOp NodeId="48" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="28" EstimatedTotalSubtreeCost="0.00331222" TableCardinality="818184" Parallel="0" EstimateRebinds="0" EstimateRewinds="0.184211" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Alias="[T5]" Column="_Fld7019_TYPE" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Alias="[T5]" Column="_Fld7019_RTRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Alias="[T5]" Column="_Fld7019_RRRef" /></OutputList><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Alias="[T5]" Column="_Fld7019_TYPE" /></DefinedValue><DefinedValue><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Alias="[T5]" Column="_Fld7019_RTRef" /></DefinedValue><DefinedValue><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Alias="[T5]" Column="_Fld7019_RRRef" /></DefinedValue></DefinedValues><Object Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Index="[IDX__Document384_VT7004_Document384_IDRRef_Fld7019_TYPE_Fld7019_RTRef]" Alias="[T5]" IndexKind="NonClustered" /><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Alias="[T5]" Column="_Document384_IDRRef" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Alias="[T5]" Column="_Fld7019_TYPE" /><ColumnReference Database="[upp_msmr]" Schema="[dbo]" Table="[_Document384_VT7004]" Alias="[T5]" Column="_Fld7019_RTRef" /></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[@P7]"><Identifier><ColumnReference Column="@P7" /></Identifier></ScalarOperator><ScalarOperator ScalarString="0x08"><Const ConstValue="0x08" /></ScalarOperator><ScalarOperator ScalarString="[@P8]"><Identifier><ColumnReference Column="@P8" /></Identifier></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp></NestedLoops></RelOp></Sort></RelOp></StreamAggregate></RelOp></ComputeScalar></RelOp></Concat></RelOp><ParameterList><ColumnReference Column="@P10" ParameterCompiledValue="0x0000014A" /><ColumnReference Column="@P9" ParameterCompiledValue="0x916600155D848F0311E2ED99C115B598" /><ColumnReference Column="@P6" ParameterCompiledValue="0x0000014A" /><ColumnReference Column="@P8" ParameterCompiledValue="0x0000014A" /><ColumnReference Column="@P7" ParameterCompiledValue="0x916600155D848F0311E2ED99C115B598" /><ColumnReference Column="@P5" ParameterCompiledValue="0x0000022E" /><ColumnReference Column="@P4" ParameterCompiledValue="0x916600155D848F0311E2ED99C115B598" /><ColumnReference Column="@P1" ParameterCompiledValue="0x0000022E" /><ColumnReference Column="@P3" ParameterCompiledValue="0x0000022E" /><ColumnReference Column="@P2" ParameterCompiledValue="0x916600155D848F0311E2ED99C115B598" /></ParameterList></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>'


В профайлере событий Plan Guide Successful/Unsuccessful нет.
И ещё вопрос: должен ли использоваться гид, если план этого запроса уже есть в кэше?
19 июл 13, 07:03    [14587216]     Ответить | Цитировать Сообщить модератору
 Re: Подскажите по гиду плана запроса  [new]
volf153
Member

Откуда:
Сообщений: 8
up?
24 июл 13, 10:26    [14608696]     Ответить | Цитировать Сообщить модератору
 Re: Подскажите по гиду плана запроса  [new]
Ivan Durak
Member

Откуда: Minsk!!!
Сообщений: 3646
начни с обновления статистики. в 9 случаях из 10 помогает
24 июл 13, 11:45    [14609208]     Ответить | Цитировать Сообщить модератору
Все форумы / Microsoft SQL Server Ответить