July 15, 2011 at 12:24 pm
Hi guys!
I need your help to optimize this query. Any questions please let me know.
INSERT INTO dbo.Preguntas(
CONVOCATORIA,
PERIODO,
codigo_distrito,
codigo_centro,
MODALIDAD,
EXAMEN,
Asignatura,
RNE,
P,
Pno)
SELECT CONVOCATORIA, PERIODO, CODICO_DISTRITO, [CODIGO CENTRO], MODALIDAD, EXAMEN, ASIGNATURA, RNE,
P, ROW_NUMBER() OVER (Partition BY Asignatura, rne, Examen, Convocatoria ORDER BY RecordID) AS Pno
FROM (SELECT RecordID, CONVOCATORIA, PERIODO, CODICO_DISTRITO, [CODIGO CENTRO], MODALIDAD, EXAMEN,
ASIGNATURA, RNE, p1, p2, p3, p4, p5, p6, p7, p8, p9, p10, p11, p12, p13, p14, p15, p16, p17, p18,
p19, p20, p21, p22, p23, p24, p25, p26, p27, p28, p29, p30, p31, p32, p33, p34, p35, p36, p37, p38,
p39, p40, p41, p42, p43, p44, p45, p46, p47, p48, p49, p50, p51, p52, p53, p54, p55, p56, p57, p58,
p59, p60, p61, p62, p63, p64, p65, p66, p67, p68, p69, p70
FROM temp) Main UNPIVOT (P FOR Ps IN (p1, p2, p3, p4, p5, p6, p7, p8, p9, p10, p11, p12, p13, p14, p15, p16,
p17, p18, p19, p20, p21, p22, p23, p24, p25, p26, p27, p28, p29, p30, p31, p32, p33, p34, p35, p36,
p37, p38, p39, p40, p41, p42, p43, p44, p45, p46, p47, p48, p49, p50, p51, p52, p53, p54, p55, p56,
p57, p58, p59, p60, p61, p62, p63, p64, p65, p66, p67, p68, p69, p70)) Ct
INSERT INTO dbo.Resumen_CentrosXTemas(
Cod_Convocatoria, Cod_Distrito, Cod_Centro, Cod_Regional, Cod_Grado, Cod_Asignatura, ID_Tema, Promedio)
SELECT DISTINCT
Cod_Convocatoria = @CodigoConvocatoria,
codigo_distrito,
codigo_centro,
CodigoRegional = SUBSTRING(codigo_distrito, 1, 2),
CE.Cod_Grado,
CE.Cod_Asignatura,
TE.ID_Tema,
Promedio = Sum(Cast(P.P as Int)) * 100 / Count(P.P)
FROM
dbo.Preguntas P
JOIN dbo.Composicion_Examen CE
ON P.ASIGNATURA = CE.Cod_Asignatura
AND CE.Cod_Grado = (SELECT Cod_Grado
FROM dbo.Modalidades M
WHERE P.MODALIDAD = M.Cod_Modalidad)
AND CE.Cod_Convocatoria = @CodigoConvocatoria
JOIN dbo.CuadernillosLinea CL
ON P.Pno = CL.Numero
JOIN dbo.Cuadernillos C
ON CL.CuadernilloID = C.CuadernilloID
AND C.Cod_Asignatura = CE.Cod_Asignatura
AND C.Cod_Grado = CE.Cod_Grado
AND C.Cod_Convocatoria = @CodigoConvocatoria
AND C.Cod_Modalidad = P.MODALIDAD
AND C.TipoPrueba = P.EXAMEN
JOIN dbo.Contenidos CO
ON CO.Cod_Grado = C.Cod_Grado
AND CO.Cod_Asignatura = C.Cod_Asignatura
JOIN dbo.ContenidosLinea COL
ON COL.ContenidoID = CO.ContenidoID
AND COL.Cod_Contenido = CL.Cod_Competencia
JOIN dbo.Comptencias_Examen COEX
ON COEX.CompetenciaID = COL.RecordID
JOIN dbo.Tema_Examen TE
ON COEX.TemaID = TE.ID_Tema
GROUP BY
P.codigo_distrito, P.codigo_centro, CE.Cod_Grado, CE.Cod_Asignatura, TE.ID_Tema
Truncate Table dbo.Preguntas
July 15, 2011 at 12:41 pm
Can you post the actual execution plans for us?
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
July 15, 2011 at 12:50 pm
Are there any indexes on dbo.Preguntas?
If so, can you post the index definition, too?
July 15, 2011 at 1:09 pm
Hi
Yes it is an index in dbo.Preguntas. Here it is:
NONCLUSTERED INDEX [Idx] ON [dbo].[Preguntas]
(
[modalidad] ASC,
[examen] ASC,
[asignatura] ASC,
[Pno] ASC
)
INCLUDE ( [codigo_distrito],
[codigo_centro],
[p]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
About the acutla execution plan i didn't know how to put it here so i pasted it from an xml
<?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.0.1600.22" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
<BatchSequence>
<Batch>
<Statements>
<StmtSimple StatementCompId="1" StatementEstRows="1598940" StatementId="1" StatementOptmLevel="FULL" StatementSubTreeCost="661.005" StatementText="INSERT INTO dbo.Preguntas( CONVOCATORIA, PERIODO, codigo_distrito, codigo_centro, MODALIDAD, EXAMEN, Asignatura, RNE, P, Pno) SELECT CONVOCATORIA, PERIODO, CODICO_DISTRITO, [CODIGO CENTRO], MODALIDAD, EXAMEN, ASIGNATURA, RNE, P, ROW_NUMBER() OVER (Partition BY Asignatura, rne, Examen, Convocatoria ORDER BY RecordID) AS Pno FROM (SELECT RecordID, CONVOCATORIA, PERIODO, CODICO_DISTRITO, [CODIGO CENTRO], MODALIDAD, EXAMEN, ASIGNATURA, RNE, p1, p2, p3, p4, p5, p6, p7, p8, p9, p10, p11, p12, p13, p14, p15, p16, p17, p18, p19, p20, p21, p22, p23, p24, p25, p26, p27, p28, p29, p30, p31, p32, p33, p34, p35, p36, p37, p38, p39, p40, p41, p42, p43, p44, p45, p46, p47, p48, p49, p50, p51, p52, p53, p54, p55, p56, p57, p58, p59, p60, p61, p62, p63, p64, p65, p66, p67, p68, p69, p70 FROM temp) Main UNPIVOT (P FOR Ps IN (p1, p2, p3, p4, p5, p6, p7, p8, p9, p10, p11, p12, p13, p14, p15, p16, p17, p18, p19, p20, p21, p22, p23, p24, p25, p26, p27, p28, p29, p30, p31, p32, p33, p34, p35, p36, p37, p38, p39, p40, p41, p42, p43, p44, p45, p46, p47, p48, p49, p50, p51, p52, p53, p54, p55, p56, p57, p58, p59, p60, p61, p62, p63, p64, p65, p66, p67, p68, p69, p70)) Ct " StatementType="INSERT" QueryHash="0x92C7D91627B40974" QueryPlanHash="0x1AB9ECEF9FB840BA">
<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="0" MemoryGrant="74008" CachedPlanSize="136" CompileTime="4729" CompileCPU="4140" CompileMemory="960">
<RelOp AvgRowSize="9" EstimateCPU="1.59894" EstimateIO="61.9871" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1598940" LogicalOp="Insert" NodeId="0" Parallel="false" PhysicalOp="Index Insert" EstimatedTotalSubtreeCost="661.005">
<OutputList />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="1177799" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<Update DMLRequestSort="true">
<Object Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Index="[Idx]" IndexKind="NonClustered" />
<SetPredicate>
<ScalarOperator ScalarString="[Bmk10001100] = [Bmk1000],[codigo_distrito1101] = [SIPN].[dbo].[Preguntas].[codigo_distrito],[codigo_centro1102] = [SIPN].[dbo].[Preguntas].[codigo_centro],[modalidad1103] = [SIPN].[dbo].[Preguntas].[modalidad],[examen1104] = [SIPN].[dbo].[Preguntas].[examen],[asignatura1105] = [SIPN].[dbo].[Preguntas].[asignatura],[p1106] = [SIPN].[dbo].[Preguntas].[p],[Pno1107] = [SIPN].[dbo].[Preguntas].[Pno]">
<ScalarExpressionList>
<ScalarOperator>
<MultipleAssign>
<Assign>
<ColumnReference Column="Bmk10001100" />
<ScalarOperator>
<Identifier>
<ColumnReference Column="Bmk1000" />
</Identifier>
</ScalarOperator>
</Assign>
<Assign>
<ColumnReference Column="codigo_distrito1101" />
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Column="codigo_distrito" />
</Identifier>
</ScalarOperator>
</Assign>
<Assign>
<ColumnReference Column="codigo_centro1102" />
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Column="codigo_centro" />
</Identifier>
</ScalarOperator>
</Assign>
<Assign>
<ColumnReference Column="modalidad1103" />
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Column="modalidad" />
</Identifier>
</ScalarOperator>
</Assign>
<Assign>
<ColumnReference Column="examen1104" />
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Column="examen" />
</Identifier>
</ScalarOperator>
</Assign>
<Assign>
<ColumnReference Column="asignatura1105" />
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Column="asignatura" />
</Identifier>
</ScalarOperator>
</Assign>
<Assign>
<ColumnReference Column="p1106" />
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Column="p" />
</Identifier>
</ScalarOperator>
</Assign>
<Assign>
<ColumnReference Column="Pno1107" />
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Column="Pno" />
</Identifier>
</ScalarOperator>
</Assign>
</MultipleAssign>
</ScalarOperator>
</ScalarExpressionList>
</ScalarOperator>
</SetPredicate>
<RelOp AvgRowSize="47" EstimateCPU="50.9213" EstimateIO="163.694" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1598940" LogicalOp="Sort" NodeId="1" Parallel="false" PhysicalOp="Sort" EstimatedTotalSubtreeCost="597.419">
<OutputList>
<ColumnReference Column="Bmk1000" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Column="codigo_distrito" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Column="codigo_centro" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Column="modalidad" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Column="examen" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Column="asignatura" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Column="p" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Column="Pno" />
</OutputList>
<MemoryFractions Input="0.439674" Output="1" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRebinds="1" ActualRewinds="0" ActualRows="1177799" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<Sort Distinct="false">
<OrderBy>
<OrderByColumn Ascending="true">
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Column="modalidad" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Column="examen" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Column="asignatura" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Column="Pno" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Column="Bmk1000" />
</OrderByColumn>
</OrderBy>
<RelOp AvgRowSize="47" EstimateCPU="1.59894" EstimateIO="81.7691" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1598940" LogicalOp="Insert" NodeId="2" Parallel="false" PhysicalOp="Table Insert" EstimatedTotalSubtreeCost="382.804">
<OutputList>
<ColumnReference Column="Bmk1000" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Column="codigo_distrito" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Column="codigo_centro" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Column="modalidad" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Column="examen" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Column="asignatura" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Column="p" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Column="Pno" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="1177799" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<Update DMLRequestSort="false">
<Object Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" IndexKind="Heap" />
<SetPredicate>
<ScalarOperator ScalarString="[SIPN].[dbo].[Preguntas].[convocatoria] = [Expr1090],[SIPN].[dbo].[Preguntas].[periodo] = [Expr1091],[SIPN].[dbo].[Preguntas].[codigo_distrito] = [Expr1092],[SIPN].[dbo].[Preguntas].[codigo_centro] = [Expr1093],[SIPN].[dbo].[Preguntas].[modalidad] = [Expr1094],[SIPN].[dbo].[Preguntas].[examen] = [Expr1095],[SIPN].[dbo].[Preguntas].[asignatura] = [Expr1096],[SIPN].[dbo].[Preguntas].[rne] = [Expr1097],[SIPN].[dbo].[Preguntas].[p] = [Expr1098],[SIPN].[dbo].[Preguntas].[Pno] = [Expr1099],[SIPN].[dbo].[Preguntas].[notaPrueba] = NULL">
<ScalarExpressionList>
<ScalarOperator>
<MultipleAssign>
<Assign>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Column="convocatoria" />
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1090" />
</Identifier>
</ScalarOperator>
</Assign>
<Assign>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Column="periodo" />
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1091" />
</Identifier>
</ScalarOperator>
</Assign>
<Assign>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Column="codigo_distrito" />
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1092" />
</Identifier>
</ScalarOperator>
</Assign>
<Assign>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Column="codigo_centro" />
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1093" />
</Identifier>
</ScalarOperator>
</Assign>
<Assign>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Column="modalidad" />
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1094" />
</Identifier>
</ScalarOperator>
</Assign>
<Assign>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Column="examen" />
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1095" />
</Identifier>
</ScalarOperator>
</Assign>
<Assign>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Column="asignatura" />
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1096" />
</Identifier>
</ScalarOperator>
</Assign>
<Assign>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Column="rne" />
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1097" />
</Identifier>
</ScalarOperator>
</Assign>
<Assign>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Column="p" />
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1098" />
</Identifier>
</ScalarOperator>
</Assign>
<Assign>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Column="Pno" />
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1099" />
</Identifier>
</ScalarOperator>
</Assign>
<Assign>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Column="notaPrueba" />
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Assign>
</MultipleAssign>
</ScalarOperator>
</ScalarExpressionList>
</ScalarOperator>
</SetPredicate>
<RelOp AvgRowSize="62" EstimateCPU="0.159894" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1598940" LogicalOp="Compute Scalar" NodeId="3" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="299.436">
<OutputList>
<ColumnReference Column="Expr1090" />
<ColumnReference Column="Expr1091" />
<ColumnReference Column="Expr1092" />
<ColumnReference Column="Expr1093" />
<ColumnReference Column="Expr1094" />
<ColumnReference Column="Expr1095" />
<ColumnReference Column="Expr1096" />
<ColumnReference Column="Expr1097" />
<ColumnReference Column="Expr1098" />
<ColumnReference Column="Expr1099" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1090" />
<ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[Expr1009],0)">
<Convert DataType="int" Style="0" Implicit="true">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1009" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1091" />
<ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[Expr1010],0)">
<Convert DataType="int" Style="0" Implicit="true">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1010" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1092" />
<ScalarOperator ScalarString="CONVERT_IMPLICIT(char(4),[Expr1011],0)">
<Convert DataType="char" Length="4" Style="0" Implicit="true">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1011" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1093" />
<ScalarOperator ScalarString="CONVERT_IMPLICIT(varchar(10),[Expr1012],0)">
<Convert DataType="varchar" Length="10" Style="0" Implicit="true">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1012" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1094" />
<ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[Expr1013],0)">
<Convert DataType="int" Style="0" Implicit="true">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1013" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1095" />
<ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[Expr1014],0)">
<Convert DataType="int" Style="0" Implicit="true">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1014" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1096" />
<ScalarOperator ScalarString="CONVERT_IMPLICIT(char(3),[Expr1015],0)">
<Convert DataType="char" Length="3" Style="0" Implicit="true">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1015" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1097" />
<ScalarOperator ScalarString="CONVERT_IMPLICIT(varchar(25),[Expr1016],0)">
<Convert DataType="varchar" Length="25" Style="0" Implicit="true">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1016" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1098" />
<ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[Expr1087],0)">
<Convert DataType="int" Style="0" Implicit="true">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1087" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1099" />
<ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[Expr1089],0)">
<Convert DataType="int" Style="0" Implicit="true">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1089" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="1179" EstimateCPU="0.159894" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1598940" LogicalOp="Top" NodeId="4" Parallel="false" PhysicalOp="Top" EstimatedTotalSubtreeCost="299.276">
<OutputList>
<ColumnReference Column="Expr1009" />
<ColumnReference Column="Expr1010" />
<ColumnReference Column="Expr1011" />
<ColumnReference Column="Expr1012" />
<ColumnReference Column="Expr1013" />
<ColumnReference Column="Expr1014" />
<ColumnReference Column="Expr1015" />
<ColumnReference Column="Expr1016" />
<ColumnReference Column="Expr1087" />
<ColumnReference Column="Expr1089" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="1177799" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<Top RowCount="true" IsPercent="false" WithTies="false">
<TopExpression>
<ScalarOperator ScalarString="(0)">
<Const ConstValue="(0)" />
</ScalarOperator>
</TopExpression>
<RelOp AvgRowSize="1179" EstimateCPU="0.127915" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1598940" LogicalOp="Compute Scalar" NodeId="5" Parallel="false" PhysicalOp="Sequence Project" EstimatedTotalSubtreeCost="299.117">
<OutputList>
<ColumnReference Column="Expr1009" />
<ColumnReference Column="Expr1010" />
<ColumnReference Column="Expr1011" />
<ColumnReference Column="Expr1012" />
<ColumnReference Column="Expr1013" />
<ColumnReference Column="Expr1014" />
<ColumnReference Column="Expr1015" />
<ColumnReference Column="Expr1016" />
<ColumnReference Column="Expr1087" />
<ColumnReference Column="Expr1089" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="1177799" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<SequenceProject>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1089" />
<ScalarOperator ScalarString="row_number">
<Sequence FunctionName="row_number" />
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="1179" EstimateCPU="0.0319788" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1598940" LogicalOp="Segment" NodeId="6" Parallel="false" PhysicalOp="Segment" EstimatedTotalSubtreeCost="298.989">
<OutputList>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="CONVOCATORIA" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="RNE" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="ASIGNATURA" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="EXAMEN" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="RecordID" />
<ColumnReference Column="Expr1008" />
<ColumnReference Column="Expr1009" />
<ColumnReference Column="Expr1010" />
<ColumnReference Column="Expr1011" />
<ColumnReference Column="Expr1012" />
<ColumnReference Column="Expr1013" />
<ColumnReference Column="Expr1014" />
<ColumnReference Column="Expr1015" />
<ColumnReference Column="Expr1016" />
<ColumnReference Column="Expr1087" />
<ColumnReference Column="Segment1108" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="1177799" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<Segment>
<GroupBy>
<ColumnReference Column="Expr1015" />
<ColumnReference Column="Expr1016" />
<ColumnReference Column="Expr1014" />
<ColumnReference Column="Expr1009" />
</GroupBy>
<SegmentColumn>
<ColumnReference Column="Segment1108" />
</SegmentColumn>
<RelOp AvgRowSize="1703" EstimateCPU="0.675108" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1598940" LogicalOp="Filter" NodeId="7" Parallel="false" PhysicalOp="Filter" EstimatedTotalSubtreeCost="298.957">
<OutputList>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="CONVOCATORIA" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="RNE" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="ASIGNATURA" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="EXAMEN" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="RecordID" />
<ColumnReference Column="Expr1008" />
<ColumnReference Column="Expr1009" />
<ColumnReference Column="Expr1010" />
<ColumnReference Column="Expr1011" />
<ColumnReference Column="Expr1012" />
<ColumnReference Column="Expr1013" />
<ColumnReference Column="Expr1014" />
<ColumnReference Column="Expr1015" />
<ColumnReference Column="Expr1016" />
<ColumnReference Column="Expr1087" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="1177799" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<Filter StartupExpression="false">
<RelOp AvgRowSize="1703" EstimateCPU="7.42619" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1776600" LogicalOp="Left Outer Join" NodeId="8" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="298.282">
<OutputList>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="CONVOCATORIA" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="RNE" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="ASIGNATURA" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="EXAMEN" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="RecordID" />
<ColumnReference Column="Expr1008" />
<ColumnReference Column="Expr1009" />
<ColumnReference Column="Expr1010" />
<ColumnReference Column="Expr1011" />
<ColumnReference Column="Expr1012" />
<ColumnReference Column="Expr1013" />
<ColumnReference Column="Expr1014" />
<ColumnReference Column="Expr1015" />
<ColumnReference Column="Expr1016" />
<ColumnReference Column="Expr1087" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="1776600" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<NestedLoops Optimized="false">
<OuterReferences>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p1" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p2" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p3" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p4" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p5" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p6" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p7" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p8" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p9" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p10" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p11" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p12" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p13" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p14" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p15" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p16" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p17" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p18" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p19" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p20" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p21" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p22" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p23" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p24" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p25" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p26" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p27" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p28" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p29" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p30" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p31" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p32" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p33" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p34" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p35" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p36" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p37" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p38" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p39" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p40" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p41" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p42" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p43" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p44" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p45" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p46" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p47" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p48" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p49" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p50" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p51" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p52" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p53" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p54" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p55" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p56" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p57" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p58" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p59" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p60" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p61" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p62" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p63" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p64" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p65" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p66" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p67" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p68" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p69" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p70" />
</OuterReferences>
<RelOp AvgRowSize="6203" EstimateCPU="0.002538" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="25380" LogicalOp="Compute Scalar" NodeId="9" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="289.079">
<OutputList>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="CONVOCATORIA" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="RNE" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="ASIGNATURA" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="EXAMEN" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p1" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p2" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p3" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p4" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p5" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p6" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p7" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p8" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p9" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p10" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p11" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p12" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p13" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p14" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p15" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p16" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p17" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p18" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p19" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p20" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p21" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p22" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p23" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p24" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p25" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p26" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p27" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p28" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p29" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p30" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p31" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p32" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p33" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p34" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p35" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p36" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p37" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p38" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p39" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p40" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p41" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p42" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p43" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p44" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p45" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p46" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p47" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p48" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p49" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p50" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p51" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p52" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p53" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p54" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p55" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p56" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p57" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p58" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p59" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p60" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p61" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p62" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p63" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p64" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p65" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p66" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p67" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p68" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p69" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p70" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="RecordID" />
<ColumnReference Column="Expr1008" />
<ColumnReference Column="Expr1009" />
<ColumnReference Column="Expr1010" />
<ColumnReference Column="Expr1011" />
<ColumnReference Column="Expr1012" />
<ColumnReference Column="Expr1013" />
<ColumnReference Column="Expr1014" />
<ColumnReference Column="Expr1015" />
<ColumnReference Column="Expr1016" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1008" />
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[RecordID]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="RecordID" />
</Identifier>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1009" />
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[CONVOCATORIA]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="CONVOCATORIA" />
</Identifier>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1010" />
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[PERIODO]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="PERIODO" />
</Identifier>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1011" />
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[CODICO_DISTRITO]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="CODICO_DISTRITO" />
</Identifier>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1012" />
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[CODIGO CENTRO]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="CODIGO CENTRO" />
</Identifier>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1013" />
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[MODALIDAD]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="MODALIDAD" />
</Identifier>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1014" />
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[EXAMEN]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="EXAMEN" />
</Identifier>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1015" />
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[ASIGNATURA]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="ASIGNATURA" />
</Identifier>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1016" />
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[RNE]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="RNE" />
</Identifier>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="5678" EstimateCPU="1.70458" EstimateIO="285.811" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="25380" LogicalOp="Sort" NodeId="10" Parallel="false" PhysicalOp="Sort" EstimatedTotalSubtreeCost="289.076">
<OutputList>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="CODICO_DISTRITO" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="PERIODO" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="CONVOCATORIA" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="CODIGO CENTRO" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="RNE" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="ASIGNATURA" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="MODALIDAD" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="EXAMEN" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p1" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p2" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p3" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p4" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p5" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p6" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p7" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p8" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p9" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p10" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p11" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p12" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p13" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p14" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p15" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p16" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p17" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p18" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p19" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p20" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p21" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p22" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p23" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p24" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p25" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p26" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p27" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p28" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p29" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p30" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p31" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p32" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p33" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p34" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p35" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p36" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p37" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p38" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p39" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p40" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p41" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p42" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p43" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p44" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p45" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p46" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p47" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p48" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p49" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p50" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p51" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p52" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p53" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p54" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p55" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p56" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p57" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p58" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p59" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p60" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p61" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p62" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p63" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p64" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p65" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p66" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p67" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p68" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p69" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p70" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="RecordID" />
</OutputList>
<MemoryFractions Input="1" Output="0.560326" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRebinds="1" ActualRewinds="0" ActualRows="25380" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<Sort Distinct="false">
<OrderBy>
<OrderByColumn Ascending="true">
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="ASIGNATURA" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="RNE" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="EXAMEN" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="CONVOCATORIA" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="RecordID" />
</OrderByColumn>
</OrderBy>
<RelOp AvgRowSize="5678" EstimateCPU="0.028075" EstimateIO="1.53275" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="25380" LogicalOp="Table Scan" NodeId="11" Parallel="false" PhysicalOp="Table Scan" EstimatedTotalSubtreeCost="1.56083" TableCardinality="25380">
<OutputList>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="CODICO_DISTRITO" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="PERIODO" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="CONVOCATORIA" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="CODIGO CENTRO" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="RNE" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="ASIGNATURA" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="MODALIDAD" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="EXAMEN" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p1" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p2" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p3" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p4" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p5" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p6" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p7" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p8" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p9" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p10" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p11" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p12" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p13" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p14" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p15" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p16" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p17" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p18" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p19" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p20" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p21" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p22" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p23" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p24" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p25" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p26" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p27" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p28" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p29" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p30" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p31" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p32" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p33" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p34" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p35" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p36" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p37" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p38" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p39" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p40" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p41" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p42" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p43" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p44" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p45" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p46" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p47" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p48" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p49" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p50" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p51" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p52" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p53" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p54" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p55" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p56" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p57" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p58" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p59" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p60" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p61" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p62" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p63" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p64" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p65" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p66" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p67" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p68" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p69" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p70" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="RecordID" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="25380" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<TableScan Ordered="false" ForcedIndex="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="CODICO_DISTRITO" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="PERIODO" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="CONVOCATORIA" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="CODIGO CENTRO" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="RNE" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="ASIGNATURA" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="MODALIDAD" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="EXAMEN" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p1" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p2" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p3" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p4" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p5" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p6" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p7" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p8" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p9" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p10" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p11" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p12" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p13" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p14" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p15" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p16" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p17" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p18" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p19" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p20" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p21" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p22" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p23" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p24" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p25" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p26" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p27" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p28" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p29" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p30" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p31" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p32" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p33" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p34" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p35" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p36" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p37" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p38" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p39" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p40" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p41" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p42" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p43" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p44" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p45" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p46" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p47" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p48" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p49" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p50" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p51" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p52" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p53" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p54" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p55" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p56" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p57" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p58" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p59" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p60" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p61" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p62" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p63" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p64" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p65" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p66" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p67" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p68" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p69" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p70" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="RecordID" />
</DefinedValue>
</DefinedValues>
<Object Database="[SIPN]" Schema="[dbo]" Table="[temp]" IndexKind="Heap" />
</TableScan>
</RelOp>
</Sort>
</RelOp>
</ComputeScalar>
</RelOp>
<RelOp AvgRowSize="138" EstimateCPU="7.0157E-05" EstimateIO="0" EstimateRebinds="25379" EstimateRewinds="5.76235E-06" EstimateRows="70" LogicalOp="Constant Scan" NodeId="31" Parallel="false" PhysicalOp="Constant Scan" EstimatedTotalSubtreeCost="1.7766">
<OutputList>
<ColumnReference Column="Expr1087" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="1776600" ActualEndOfScans="25380" ActualExecutions="25380" />
</RunTimeInformation>
<ConstantScan>
<Values>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p1]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p1" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p2]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p2" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p3]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p3" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p4]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p4" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p5]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p5" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p6]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p6" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p7]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p7" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p8]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p8" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p9]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p9" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p10]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p10" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p11]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p11" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p12]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p12" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p13]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p13" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p14]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p14" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p15]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p15" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p16]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p16" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p17]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p17" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p18]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p18" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p19]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p19" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p20]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p20" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p21]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p21" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p22]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p22" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p23]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p23" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p24]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p24" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p25]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p25" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p26]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p26" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p27]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p27" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p28]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p28" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p29]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p29" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p30]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p30" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p31]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p31" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p32]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p32" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p33]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p33" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p34]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p34" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p35]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p35" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p36]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p36" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p37]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p37" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p38]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p38" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p39]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p39" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p40]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p40" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p41]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p41" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p42]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p42" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p43]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p43" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p44]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p44" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p45]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p45" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p46]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p46" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p47]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p47" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p48]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p48" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p49]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p49" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p50]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p50" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p51]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p51" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p52]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p52" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p53]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p53" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p54]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p54" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p55]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p55" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p56]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p56" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p57]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p57" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p58]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p58" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p59]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p59" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p60]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p60" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p61]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p61" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p62]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p62" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p63]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p63" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p64]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p64" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p65]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p65" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p66]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p66" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p67]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p67" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p68]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p68" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p69]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p69" />
</Identifier>
</ScalarOperator>
</Row>
<Row>
<ScalarOperator ScalarString="[SIPN].[dbo].[temp].[p70]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[temp]" Column="p70" />
</Identifier>
</ScalarOperator>
</Row>
</Values>
</ConstantScan>
</RelOp>
</NestedLoops>
</RelOp>
<Predicate>
<ScalarOperator ScalarString="[Expr1087] IS NOT NULL">
<Logical Operation="IS NOT NULL">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1087" />
</Identifier>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Predicate>
</Filter>
</RelOp>
</Segment>
</RelOp>
</SequenceProject>
</RelOp>
</Top>
</RelOp>
</ComputeScalar>
</RelOp>
</Update>
</RelOp>
</Sort>
</RelOp>
</Update>
</RelOp>
</QueryPlan>
</StmtSimple>
</Statements>
</Batch>
<Batch>
<Statements>
<StmtSimple StatementCompId="2" StatementEstRows="1" StatementId="2" StatementOptmLevel="FULL" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" StatementSubTreeCost="0.197056" StatementText="INSERT INTO dbo.Resumen_CentrosXTemas( Cod_Convocatoria, Cod_Distrito, Cod_Centro, Cod_Regional, Cod_Grado, Cod_Asignatura, ID_Tema, Promedio) SELECT DISTINCT Cod_Convocatoria = 2, codigo_distrito, codigo_centro, CodigoRegional = SUBSTRING(codigo_distrito, 1, 2), CE.Cod_Grado, CE.Cod_Asignatura, TE.ID_Tema, Promedio = Sum(Cast(P.P as Int)) * 100 / Count(P.P) FROM dbo.Preguntas P JOIN dbo.Composicion_Examen CE ON P.ASIGNATURA = CE.Cod_Asignatura AND CE.Cod_Grado = (SELECT Cod_Grado FROM dbo.Modalidades M WHERE P.MODALIDAD = M.Cod_Modalidad) AND CE.Cod_Convocatoria = 2 JOIN dbo.CuadernillosLinea CL ON P.Pno = CL.Numero JOIN dbo.Cuadernillos C ON CL.CuadernilloID = C.CuadernilloID AND C.Cod_Asignatura = CE.Cod_Asignatura AND C.Cod_Grado = CE.Cod_Grado AND C.Cod_Convocatoria = 2 AND C.Cod_Modalidad = P.MODALIDAD AND C.TipoPrueba = P.EXAMEN JOIN dbo.Contenidos CO ON CO.Cod_Grado = C.Cod_Grado AND CO.Cod_Asignatura = C.Cod_Asignatura JOIN dbo.ContenidosLinea COL ON COL.ContenidoID = CO.ContenidoID AND COL.Cod_Contenido = CL.Cod_Competencia JOIN dbo.Comptencias_Examen COEX ON COEX.CompetenciaID = COL.RecordID JOIN dbo.Tema_Examen TE ON COEX.TemaID = TE.ID_Tema GROUP BY P.codigo_distrito, P.codigo_centro, CE.Cod_Grado, CE.Cod_Asignatura, TE.ID_Tema " StatementType="INSERT" QueryHash="0x4E36CD00041E44D9" QueryPlanHash="0x94258BCD13E82FB2">
<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="0" MemoryGrant="1792" CachedPlanSize="104" CompileTime="3643" CompileCPU="3097" CompileMemory="1880">
<RelOp AvgRowSize="9" EstimateCPU="1E-06" EstimateIO="0.01" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Insert" NodeId="0" Parallel="false" PhysicalOp="Clustered Index Insert" EstimatedTotalSubtreeCost="0.197056">
<OutputList />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="504" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<Update DMLRequestSort="false">
<Object Database="[SIPN]" Schema="[dbo]" Table="[Resumen_CentrosXTemas]" Index="[PK__Resumen___43A6F60421F5FC7F]" IndexKind="Clustered" />
<SetPredicate>
<ScalarOperator ScalarString="[SIPN].[dbo].[Resumen_CentrosXTemas].[Cod_Convocatoria] = [Expr1025],[SIPN].[dbo].[Resumen_CentrosXTemas].[Cod_Distrito] = [SIPN].[dbo].[Preguntas].[codigo_distrito] as [P].[codigo_distrito],[SIPN].[dbo].[Resumen_CentrosXTemas].[Cod_Centro] = [SIPN].[dbo].[Preguntas].[codigo_centro] as [P].[codigo_centro],[SIPN].[dbo].[Resumen_CentrosXTemas].[Cod_Regional] = [Expr1029],[SIPN].[dbo].[Resumen_CentrosXTemas].[Cod_Grado] = [SIPN].[dbo].[Composicion_Examen].[Cod_Grado] as [CE].[Cod_Grado],[SIPN].[dbo].[Resumen_CentrosXTemas].[Cod_Asignatura] = [SIPN].[dbo].[Composicion_Examen].[Cod_Asignatura] as [CE].[Cod_Asignatura],[SIPN].[dbo].[Resumen_CentrosXTemas].[ID_Tema] = [Expr1030],[SIPN].[dbo].[Resumen_CentrosXTemas].[Promedio] = [Expr1031],[SIPN].[dbo].[Resumen_CentrosXTemas].[RecorID] = [Expr1028],[SIPN].[dbo].[Resumen_CentrosXTemas].[FhCreacion] = [Expr1032]">
<ScalarExpressionList>
<ScalarOperator>
<MultipleAssign>
<Assign>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Resumen_CentrosXTemas]" Column="Cod_Convocatoria" />
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1025" />
</Identifier>
</ScalarOperator>
</Assign>
<Assign>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Resumen_CentrosXTemas]" Column="Cod_Distrito" />
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Alias="[P]" Column="codigo_distrito" />
</Identifier>
</ScalarOperator>
</Assign>
<Assign>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Resumen_CentrosXTemas]" Column="Cod_Centro" />
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Alias="[P]" Column="codigo_centro" />
</Identifier>
</ScalarOperator>
</Assign>
<Assign>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Resumen_CentrosXTemas]" Column="Cod_Regional" />
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1029" />
</Identifier>
</ScalarOperator>
</Assign>
<Assign>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Resumen_CentrosXTemas]" Column="Cod_Grado" />
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Composicion_Examen]" Alias="[CE]" Column="Cod_Grado" />
</Identifier>
</ScalarOperator>
</Assign>
<Assign>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Resumen_CentrosXTemas]" Column="Cod_Asignatura" />
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Composicion_Examen]" Alias="[CE]" Column="Cod_Asignatura" />
</Identifier>
</ScalarOperator>
</Assign>
<Assign>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Resumen_CentrosXTemas]" Column="ID_Tema" />
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1030" />
</Identifier>
</ScalarOperator>
</Assign>
<Assign>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Resumen_CentrosXTemas]" Column="Promedio" />
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1031" />
</Identifier>
</ScalarOperator>
</Assign>
<Assign>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Resumen_CentrosXTemas]" Column="RecorID" />
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1028" />
</Identifier>
</ScalarOperator>
</Assign>
<Assign>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Resumen_CentrosXTemas]" Column="FhCreacion" />
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1032" />
</Identifier>
</ScalarOperator>
</Assign>
</MultipleAssign>
</ScalarOperator>
</ScalarExpressionList>
</ScalarOperator>
</SetPredicate>
<RelOp AvgRowSize="59" EstimateCPU="1E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Compute Scalar" NodeId="1" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.187055">
<OutputList>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Alias="[P]" Column="codigo_distrito" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Alias="[P]" Column="codigo_centro" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Composicion_Examen]" Alias="[CE]" Column="Cod_Grado" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Composicion_Examen]" Alias="[CE]" Column="Cod_Asignatura" />
<ColumnReference Column="Expr1025" />
<ColumnReference Column="Expr1028" />
<ColumnReference Column="Expr1029" />
<ColumnReference Column="Expr1030" />
<ColumnReference Column="Expr1031" />
<ColumnReference Column="Expr1032" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1029" />
<ScalarOperator ScalarString="CONVERT_IMPLICIT(char(2),[Expr1026],0)">
<Convert DataType="char" Length="2" Style="0" Implicit="true">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1026" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1030" />
<ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[SIPN].[dbo].[Tema_Examen].[ID_Tema] as [TE].[ID_Tema],0)">
<Convert DataType="int" Style="0" Implicit="true">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Tema_Examen]" Alias="[TE]" Column="ID_Tema" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1031" />
<ScalarOperator ScalarString="CONVERT_IMPLICIT(float(53),[Expr1027],0)">
<Convert DataType="float" Scale="0" Style="0" Implicit="true">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1027" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1032" />
<ScalarOperator ScalarString="getdate()">
<Identifier>
<ColumnReference Column="ConstExpr1033">
<ScalarOperator>
<Intrinsic FunctionName="getdate" />
</ScalarOperator>
</ColumnReference>
</Identifier>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="52" EstimateCPU="1E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Compute Scalar" NodeId="2" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.187054">
<OutputList>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Alias="[P]" Column="codigo_distrito" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Alias="[P]" Column="codigo_centro" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Composicion_Examen]" Alias="[CE]" Column="Cod_Grado" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Composicion_Examen]" Alias="[CE]" Column="Cod_Asignatura" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Tema_Examen]" Alias="[TE]" Column="ID_Tema" />
<ColumnReference Column="Expr1025" />
<ColumnReference Column="Expr1026" />
<ColumnReference Column="Expr1027" />
<ColumnReference Column="Expr1028" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="504" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1028" />
<ScalarOperator ScalarString="getidentity((537768973),(11),NULL)">
<Intrinsic FunctionName="getidentity">
<ScalarOperator>
<Const ConstValue="(537768973)" />
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(11)" />
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="47" EstimateCPU="1E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Compute Scalar" NodeId="3" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.187054">
<OutputList>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Alias="[P]" Column="codigo_distrito" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Alias="[P]" Column="codigo_centro" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Composicion_Examen]" Alias="[CE]" Column="Cod_Grado" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Composicion_Examen]" Alias="[CE]" Column="Cod_Asignatura" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Tema_Examen]" Alias="[TE]" Column="ID_Tema" />
<ColumnReference Column="Expr1025" />
<ColumnReference Column="Expr1026" />
<ColumnReference Column="Expr1027" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1025" />
<ScalarOperator ScalarString="(2)">
<Const ConstValue="(2)" />
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1027" />
<ScalarOperator ScalarString="([Expr1023]*(100))/[Expr1024]">
<Arithmetic Operation="DIV">
<ScalarOperator>
<Arithmetic Operation="MULT">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1023" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(100)" />
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1024" />
</Identifier>
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="47" EstimateCPU="1E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Top" NodeId="4" Parallel="false" PhysicalOp="Top" EstimatedTotalSubtreeCost="0.187054">
<OutputList>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Alias="[P]" Column="codigo_distrito" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Alias="[P]" Column="codigo_centro" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Composicion_Examen]" Alias="[CE]" Column="Cod_Grado" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Composicion_Examen]" Alias="[CE]" Column="Cod_Asignatura" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Tema_Examen]" Alias="[TE]" Column="ID_Tema" />
<ColumnReference Column="Expr1023" />
<ColumnReference Column="Expr1024" />
<ColumnReference Column="Expr1026" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="504" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<Top RowCount="true" IsPercent="false" WithTies="false">
<TopExpression>
<ScalarOperator ScalarString="(0)">
<Const ConstValue="(0)" />
</ScalarOperator>
</TopExpression>
<RelOp AvgRowSize="47" EstimateCPU="1E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Compute Scalar" NodeId="5" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.187054">
<OutputList>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Alias="[P]" Column="codigo_distrito" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Alias="[P]" Column="codigo_centro" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Composicion_Examen]" Alias="[CE]" Column="Cod_Grado" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Composicion_Examen]" Alias="[CE]" Column="Cod_Asignatura" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Tema_Examen]" Alias="[TE]" Column="ID_Tema" />
<ColumnReference Column="Expr1023" />
<ColumnReference Column="Expr1024" />
<ColumnReference Column="Expr1026" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1026" />
<ScalarOperator ScalarString="substring([SIPN].[dbo].[Preguntas].[codigo_distrito] as [P].[codigo_distrito],(1),(2))">
<Intrinsic FunctionName="substring">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Alias="[P]" Column="codigo_distrito" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(1)" />
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(2)" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="44" EstimateCPU="1.1E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Compute Scalar" NodeId="6" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.187054">
<OutputList>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Alias="[P]" Column="codigo_distrito" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Alias="[P]" Column="codigo_centro" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Composicion_Examen]" Alias="[CE]" Column="Cod_Grado" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Composicion_Examen]" Alias="[CE]" Column="Cod_Asignatura" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Tema_Examen]" Alias="[TE]" Column="ID_Tema" />
<ColumnReference Column="Expr1023" />
<ColumnReference Column="Expr1024" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1023" />
<ScalarOperator ScalarString="CASE WHEN [Expr1048]=(0) THEN NULL ELSE [Expr1049] END">
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1048" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(0)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1049" />
</Identifier>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1024" />
<ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[Expr1048],0)">
<Convert DataType="int" Style="0" Implicit="true">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1048" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="44" EstimateCPU="1.1E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Aggregate" NodeId="7" Parallel="false" PhysicalOp="Stream Aggregate" EstimatedTotalSubtreeCost="0.187054">
<OutputList>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Alias="[P]" Column="codigo_distrito" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Alias="[P]" Column="codigo_centro" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Composicion_Examen]" Alias="[CE]" Column="Cod_Grado" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Composicion_Examen]" Alias="[CE]" Column="Cod_Asignatura" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Tema_Examen]" Alias="[TE]" Column="ID_Tema" />
<ColumnReference Column="Expr1048" />
<ColumnReference Column="Expr1049" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="504" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<StreamAggregate>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1048" />
<ScalarOperator ScalarString="COUNT_BIG([SIPN].[dbo].[Preguntas].[p] as [P].[p])">
<Aggregate AggType="COUNT_BIG" Distinct="false">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Alias="[P]" Column="p" />
</Identifier>
</ScalarOperator>
</Aggregate>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1049" />
<ScalarOperator ScalarString="SUM([SIPN].[dbo].[Preguntas].[p] as [P].[p])">
<Aggregate AggType="SUM" Distinct="false">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Alias="[P]" Column="p" />
</Identifier>
</ScalarOperator>
</Aggregate>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<GroupBy>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Alias="[P]" Column="codigo_distrito" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Alias="[P]" Column="codigo_centro" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Composicion_Examen]" Alias="[CE]" Column="Cod_Grado" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Composicion_Examen]" Alias="[CE]" Column="Cod_Asignatura" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Tema_Examen]" Alias="[TE]" Column="ID_Tema" />
</GroupBy>
<RelOp AvgRowSize="47" EstimateCPU="0.000100047" EstimateIO="0.0112613" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Sort" NodeId="8" Parallel="false" PhysicalOp="Sort" EstimatedTotalSubtreeCost="0.187053">
<OutputList>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Alias="[P]" Column="codigo_distrito" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Alias="[P]" Column="codigo_centro" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Alias="[P]" Column="asignatura" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Alias="[P]" Column="p" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Composicion_Examen]" Alias="[CE]" Column="Cod_Grado" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Composicion_Examen]" Alias="[CE]" Column="Cod_Asignatura" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Comptencias_Examen]" Alias="[COEX]" Column="TemaID" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Tema_Examen]" Alias="[TE]" Column="ID_Tema" />
</OutputList>
<MemoryFractions Input="0.25" Output="1" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRebinds="1" ActualRewinds="0" ActualRows="168934" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<Sort Distinct="false">
<OrderBy>
<OrderByColumn Ascending="true">
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Alias="[P]" Column="codigo_distrito" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Alias="[P]" Column="codigo_centro" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Composicion_Examen]" Alias="[CE]" Column="Cod_Grado" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Alias="[P]" Column="asignatura" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Comptencias_Examen]" Alias="[COEX]" Column="TemaID" />
</OrderByColumn>
</OrderBy>
<RelOp AvgRowSize="47" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Inner Join" NodeId="9" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.175692">
<OutputList>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Alias="[P]" Column="codigo_distrito" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Alias="[P]" Column="codigo_centro" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Alias="[P]" Column="asignatura" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Alias="[P]" Column="p" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Composicion_Examen]" Alias="[CE]" Column="Cod_Grado" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Composicion_Examen]" Alias="[CE]" Column="Cod_Asignatura" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Comptencias_Examen]" Alias="[COEX]" Column="TemaID" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Tema_Examen]" Alias="[TE]" Column="ID_Tema" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="168934" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<NestedLoops Optimized="false">
<OuterReferences>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Alias="[P]" Column="modalidad" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Contenidos]" Alias="[CO]" Column="Cod_Grado" />
</OuterReferences>
<RelOp AvgRowSize="54" EstimateCPU="0.000159412" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Inner Join" NodeId="10" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.172393">
<OutputList>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Alias="[P]" Column="codigo_distrito" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Alias="[P]" Column="codigo_centro" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Alias="[P]" Column="modalidad" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Alias="[P]" Column="asignatura" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Alias="[P]" Column="p" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Composicion_Examen]" Alias="[CE]" Column="Cod_Grado" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Composicion_Examen]" Alias="[CE]" Column="Cod_Asignatura" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Contenidos]" Alias="[CO]" Column="Cod_Grado" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Comptencias_Examen]" Alias="[COEX]" Column="TemaID" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Tema_Examen]" Alias="[TE]" Column="ID_Tema" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="168934" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<NestedLoops Optimized="true" WithUnorderedPrefetch="true">
<OuterReferences>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[CuadernillosLinea]" Alias="[CL]" Column="Numero" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Cuadernillos]" Alias="[C]" Column="TipoPrueba" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Contenidos]" Alias="[CO]" Column="Cod_Asignatura" />
<ColumnReference Column="Expr1037" />
<ColumnReference Column="Expr1047" />
</OuterReferences>
<RelOp AvgRowSize="42" EstimateCPU="0.00634973" EstimateIO="0.000313" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="38.1368" LogicalOp="Inner Join" NodeId="13" Parallel="false" PhysicalOp="Merge Join" EstimatedTotalSubtreeCost="0.0799696">
<OutputList>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Composicion_Examen]" Alias="[CE]" Column="Cod_Grado" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Composicion_Examen]" Alias="[CE]" Column="Cod_Asignatura" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[CuadernillosLinea]" Alias="[CL]" Column="Numero" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Cuadernillos]" Alias="[C]" Column="TipoPrueba" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Contenidos]" Alias="[CO]" Column="Cod_Grado" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Contenidos]" Alias="[CO]" Column="Cod_Asignatura" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Comptencias_Examen]" Alias="[COEX]" Column="TemaID" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Tema_Examen]" Alias="[TE]" Column="ID_Tema" />
<ColumnReference Column="Expr1037" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="152" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<Merge ManyToMany="true">
<InnerSideJoinColumns>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[CuadernillosLinea]" Alias="[CL]" Column="Cod_Competencia" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[CuadernillosLinea]" Alias="[CL]" Column="CuadernilloID" />
</InnerSideJoinColumns>
<OuterSideJoinColumns>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[ContenidosLinea]" Alias="[COL]" Column="Cod_Contenido" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Cuadernillos]" Alias="[C]" Column="CuadernilloID" />
</OuterSideJoinColumns>
<Residual>
<ScalarOperator ScalarString="[SIPN].[dbo].[ContenidosLinea].[Cod_Contenido] as [COL].[Cod_Contenido]=[SIPN].[dbo].[CuadernillosLinea].[Cod_Competencia] as [CL].[Cod_Competencia] AND [SIPN].[dbo].[CuadernillosLinea].[CuadernilloID] as [CL].[CuadernilloID]=[SIPN].[dbo].[Cuadernillos].[CuadernilloID] as [C].[CuadernilloID]">
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[ContenidosLinea]" Alias="[COL]" Column="Cod_Contenido" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[CuadernillosLinea]" Alias="[CL]" Column="Cod_Competencia" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[CuadernillosLinea]" Alias="[CL]" Column="CuadernilloID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Cuadernillos]" Alias="[C]" Column="CuadernilloID" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Residual>
<RelOp AvgRowSize="44" EstimateCPU="0.000273277" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="8.71698" LogicalOp="Inner Join" NodeId="14" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0534912">
<OutputList>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Composicion_Examen]" Alias="[CE]" Column="Cod_Grado" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Composicion_Examen]" Alias="[CE]" Column="Cod_Asignatura" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Cuadernillos]" Alias="[C]" Column="CuadernilloID" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Cuadernillos]" Alias="[C]" Column="TipoPrueba" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Contenidos]" Alias="[CO]" Column="Cod_Grado" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Contenidos]" Alias="[CO]" Column="Cod_Asignatura" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[ContenidosLinea]" Alias="[COL]" Column="Cod_Contenido" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Comptencias_Examen]" Alias="[COEX]" Column="TemaID" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Tema_Examen]" Alias="[TE]" Column="ID_Tema" />
<ColumnReference Column="Expr1037" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="63" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<NestedLoops Optimized="false">
<Predicate>
<ScalarOperator ScalarString="[SIPN].[dbo].[Comptencias_Examen].[TemaID] as [COEX].[TemaID]=[SIPN].[dbo].[Tema_Examen].[ID_Tema] as [TE].[ID_Tema]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Comptencias_Examen]" Alias="[COEX]" Column="TemaID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Tema_Examen]" Alias="[TE]" Column="ID_Tema" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
<RelOp AvgRowSize="36" EstimateCPU="0.000746958" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="4.35849" LogicalOp="Inner Join" NodeId="15" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.045877">
<OutputList>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Composicion_Examen]" Alias="[CE]" Column="Cod_Grado" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Composicion_Examen]" Alias="[CE]" Column="Cod_Asignatura" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Cuadernillos]" Alias="[C]" Column="CuadernilloID" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Cuadernillos]" Alias="[C]" Column="TipoPrueba" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Contenidos]" Alias="[CO]" Column="Cod_Grado" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Contenidos]" Alias="[CO]" Column="Cod_Asignatura" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[ContenidosLinea]" Alias="[COL]" Column="Cod_Contenido" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Comptencias_Examen]" Alias="[COEX]" Column="TemaID" />
<ColumnReference Column="Expr1037" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="63" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<NestedLoops Optimized="false">
<Predicate>
<ScalarOperator ScalarString="[Expr1036]=[SIPN].[dbo].[ContenidosLinea].[RecordID] as [COL].[RecordID]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1036" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[ContenidosLinea]" Alias="[COL]" Column="RecordID" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
<RelOp AvgRowSize="40" EstimateCPU="1.82185E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="4.35849" LogicalOp="Inner Join" NodeId="16" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0413125">
<OutputList>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Composicion_Examen]" Alias="[CE]" Column="Cod_Grado" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Composicion_Examen]" Alias="[CE]" Column="Cod_Asignatura" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Cuadernillos]" Alias="[C]" Column="CuadernilloID" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Cuadernillos]" Alias="[C]" Column="TipoPrueba" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Contenidos]" Alias="[CO]" Column="Cod_Grado" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Contenidos]" Alias="[CO]" Column="Cod_Asignatura" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[ContenidosLinea]" Alias="[COL]" Column="RecordID" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[ContenidosLinea]" Alias="[COL]" Column="Cod_Contenido" />
<ColumnReference Column="Expr1037" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="63" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<NestedLoops Optimized="false">
<OuterReferences>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Composicion_Examen]" Alias="[CE]" Column="Cod_Examen" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Contenidos]" Alias="[CO]" Column="Cod_Asignatura" />
</OuterReferences>
<RelOp AvgRowSize="37" EstimateCPU="1.82185E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="4.35849" LogicalOp="Inner Join" NodeId="17" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0374802">
<OutputList>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Composicion_Examen]" Alias="[CE]" Column="Cod_Examen" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Composicion_Examen]" Alias="[CE]" Column="Cod_Grado" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Cuadernillos]" Alias="[C]" Column="CuadernilloID" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Cuadernillos]" Alias="[C]" Column="TipoPrueba" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Contenidos]" Alias="[CO]" Column="Cod_Grado" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Contenidos]" Alias="[CO]" Column="Cod_Asignatura" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[ContenidosLinea]" Alias="[COL]" Column="RecordID" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[ContenidosLinea]" Alias="[COL]" Column="Cod_Contenido" />
<ColumnReference Column="Expr1037" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="154" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<NestedLoops Optimized="false">
<OuterReferences>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Contenidos]" Alias="[CO]" Column="Cod_Grado" />
</OuterReferences>
<RelOp AvgRowSize="30" EstimateCPU="0.00011447" EstimateIO="0.0112613" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="4.35849" LogicalOp="Sort" NodeId="18" Parallel="false" PhysicalOp="Sort" EstimatedTotalSubtreeCost="0.0336479">
<OutputList>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Cuadernillos]" Alias="[C]" Column="CuadernilloID" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Cuadernillos]" Alias="[C]" Column="TipoPrueba" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Contenidos]" Alias="[CO]" Column="Cod_Grado" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Contenidos]" Alias="[CO]" Column="Cod_Asignatura" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[ContenidosLinea]" Alias="[COL]" Column="RecordID" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[ContenidosLinea]" Alias="[COL]" Column="Cod_Contenido" />
<ColumnReference Column="Expr1037" />
</OutputList>
<MemoryFractions Input="0.5" Output="0.25" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRebinds="1" ActualRewinds="0" ActualRows="77" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<Sort Distinct="false">
<OrderBy>
<OrderByColumn Ascending="true">
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[ContenidosLinea]" Alias="[COL]" Column="Cod_Contenido" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Cuadernillos]" Alias="[C]" Column="CuadernilloID" />
</OrderByColumn>
</OrderBy>
<RelOp AvgRowSize="36" EstimateCPU="0.00032186" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="4.35849" LogicalOp="Inner Join" NodeId="19" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0222722">
<OutputList>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Cuadernillos]" Alias="[C]" Column="CuadernilloID" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Cuadernillos]" Alias="[C]" Column="TipoPrueba" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Contenidos]" Alias="[CO]" Column="Cod_Grado" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Contenidos]" Alias="[CO]" Column="Cod_Asignatura" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[ContenidosLinea]" Alias="[COL]" Column="RecordID" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[ContenidosLinea]" Alias="[COL]" Column="Cod_Contenido" />
<ColumnReference Column="Expr1037" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="77" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<NestedLoops Optimized="false">
<Predicate>
<ScalarOperator ScalarString="[SIPN].[dbo].[ContenidosLinea].[ContenidoID] as [COL].[ContenidoID]=[SIPN].[dbo].[Contenidos].[ContenidoID] as [CO].[ContenidoID]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[ContenidosLinea]" Alias="[COL]" Column="ContenidoID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Contenidos]" Alias="[CO]" Column="ContenidoID" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
<RelOp AvgRowSize="33" EstimateCPU="0.000100033" EstimateIO="0.0112613" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Sort" NodeId="20" Parallel="false" PhysicalOp="Sort" EstimatedTotalSubtreeCost="0.0185606">
<OutputList>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Cuadernillos]" Alias="[C]" Column="CuadernilloID" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Cuadernillos]" Alias="[C]" Column="Cod_Grado" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Cuadernillos]" Alias="[C]" Column="Cod_Asignatura" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Cuadernillos]" Alias="[C]" Column="TipoPrueba" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Contenidos]" Alias="[CO]" Column="ContenidoID" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Contenidos]" Alias="[CO]" Column="Cod_Grado" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Contenidos]" Alias="[CO]" Column="Cod_Asignatura" />
<ColumnReference Column="Expr1037" />
</OutputList>
<MemoryFractions Input="1" Output="0.5" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRebinds="1" ActualRewinds="0" ActualRows="4" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<Sort Distinct="false">
<OrderBy>
<OrderByColumn Ascending="true">
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Cuadernillos]" Alias="[C]" Column="Cod_Asignatura" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Cuadernillos]" Alias="[C]" Column="Cod_Grado" />
</OrderByColumn>
</OrderBy>
<RelOp AvgRowSize="33" EstimateCPU="0.00015048" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Inner Join" NodeId="21" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.00719926">
<OutputList>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Cuadernillos]" Alias="[C]" Column="CuadernilloID" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Cuadernillos]" Alias="[C]" Column="Cod_Grado" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Cuadernillos]" Alias="[C]" Column="Cod_Asignatura" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Cuadernillos]" Alias="[C]" Column="TipoPrueba" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Contenidos]" Alias="[CO]" Column="ContenidoID" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Contenidos]" Alias="[CO]" Column="Cod_Grado" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Contenidos]" Alias="[CO]" Column="Cod_Asignatura" />
<ColumnReference Column="Expr1037" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="4" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<NestedLoops Optimized="false">
<Predicate>
<ScalarOperator ScalarString="[SIPN].[dbo].[Contenidos].[Cod_Asignatura] as [CO].[Cod_Asignatura]=[SIPN].[dbo].[Cuadernillos].[Cod_Asignatura] as [C].[Cod_Asignatura] AND [SIPN].[dbo].[Contenidos].[Cod_Grado] as [CO].[Cod_Grado]=[SIPN].[dbo].[Cuadernillos].[Cod_Grado] as [C].[Cod_Grado]">
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Contenidos]" Alias="[CO]" Column="Cod_Asignatura" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Cuadernillos]" Alias="[C]" Column="Cod_Asignatura" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Contenidos]" Alias="[CO]" Column="Cod_Grado" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Cuadernillos]" Alias="[C]" Column="Cod_Grado" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Predicate>
<RelOp AvgRowSize="16" EstimateCPU="0.0001636" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="6" LogicalOp="Clustered Index Scan" NodeId="22" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0032886" TableCardinality="6">
<OutputList>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Contenidos]" Alias="[CO]" Column="ContenidoID" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Contenidos]" Alias="[CO]" Column="Cod_Grado" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Contenidos]" Alias="[CO]" Column="Cod_Asignatura" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="6" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Contenidos]" Alias="[CO]" Column="ContenidoID" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Contenidos]" Alias="[CO]" Column="Cod_Grado" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Contenidos]" Alias="[CO]" Column="Cod_Asignatura" />
</DefinedValue>
</DefinedValues>
<Object Database="[SIPN]" Schema="[dbo]" Table="[Contenidos]" Index="[PK__Contenid__154DDD9641399DAE]" Alias="[CO]" IndexKind="Clustered" />
</IndexScan>
</RelOp>
<RelOp AvgRowSize="28" EstimateCPU="6E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="5" EstimateRows="6" LogicalOp="Compute Scalar" NodeId="23" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.0037177">
<OutputList>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Cuadernillos]" Alias="[C]" Column="CuadernilloID" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Cuadernillos]" Alias="[C]" Column="Cod_Grado" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Cuadernillos]" Alias="[C]" Column="Cod_Asignatura" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Cuadernillos]" Alias="[C]" Column="TipoPrueba" />
<ColumnReference Column="Expr1037" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1037" />
<ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[SIPN].[dbo].[Cuadernillos].[Cod_Modalidad] as [C].[Cod_Modalidad],0)">
<Convert DataType="int" Style="0" Implicit="true">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Cuadernillos]" Alias="[C]" Column="Cod_Modalidad" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="26" EstimateCPU="8.51E-05" EstimateIO="0.0032035" EstimateRebinds="0" EstimateRewinds="5" EstimateRows="6" LogicalOp="Clustered Index Scan" NodeId="24" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0037141" TableCardinality="6">
<OutputList>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Cuadernillos]" Alias="[C]" Column="CuadernilloID" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Cuadernillos]" Alias="[C]" Column="Cod_Grado" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Cuadernillos]" Alias="[C]" Column="Cod_Modalidad" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Cuadernillos]" Alias="[C]" Column="Cod_Asignatura" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Cuadernillos]" Alias="[C]" Column="TipoPrueba" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="36" ActualEndOfScans="6" ActualExecutions="6" />
</RunTimeInformation>
<IndexScan Ordered="false" ForcedIndex="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Cuadernillos]" Alias="[C]" Column="CuadernilloID" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Cuadernillos]" Alias="[C]" Column="Cod_Grado" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Cuadernillos]" Alias="[C]" Column="Cod_Modalidad" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Cuadernillos]" Alias="[C]" Column="Cod_Asignatura" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Cuadernillos]" Alias="[C]" Column="TipoPrueba" />
</DefinedValue>
</DefinedValues>
<Object Database="[SIPN]" Schema="[dbo]" Table="[Cuadernillos]" Index="[PK__Cuaderni__FD420CBD164F3FA9]" Alias="[C]" IndexKind="Clustered" />
<Predicate>
<ScalarOperator ScalarString="[SIPN].[dbo].[Cuadernillos].[Cod_Convocatoria] as [C].[Cod_Convocatoria]=(2)">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Cuadernillos]" Alias="[C]" Column="Cod_Convocatoria" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(2)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
</ComputeScalar>
</RelOp>
</NestedLoops>
</RelOp>
</Sort>
</RelOp>
<RelOp AvgRowSize="17" EstimateCPU="0.0002417" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="77" LogicalOp="Clustered Index Scan" NodeId="29" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0033667" TableCardinality="77">
<OutputList>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[ContenidosLinea]" Alias="[COL]" Column="RecordID" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[ContenidosLinea]" Alias="[COL]" Column="ContenidoID" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[ContenidosLinea]" Alias="[COL]" Column="Cod_Contenido" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="308" ActualEndOfScans="4" ActualExecutions="4" />
</RunTimeInformation>
<IndexScan Ordered="false" ForcedIndex="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[ContenidosLinea]" Alias="[COL]" Column="RecordID" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[ContenidosLinea]" Alias="[COL]" Column="ContenidoID" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[ContenidosLinea]" Alias="[COL]" Column="Cod_Contenido" />
</DefinedValue>
</DefinedValues>
<Object Database="[SIPN]" Schema="[dbo]" Table="[ContenidosLinea]" Index="[PK__Contenid__FBDF78C945FE52CB]" Alias="[COL]" IndexKind="Clustered" />
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
</Sort>
</RelOp>
<RelOp AvgRowSize="13" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="3.35849" EstimateRows="1" LogicalOp="Index Seek" NodeId="31" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.00381408" TableCardinality="3">
<OutputList>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Composicion_Examen]" Alias="[CE]" Column="Cod_Examen" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Composicion_Examen]" Alias="[CE]" Column="Cod_Grado" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="154" ActualEndOfScans="77" ActualExecutions="77" />
</RunTimeInformation>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Composicion_Examen]" Alias="[CE]" Column="Cod_Examen" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Composicion_Examen]" Alias="[CE]" Column="Cod_Grado" />
</DefinedValue>
</DefinedValues>
<Object Database="[SIPN]" Schema="[dbo]" Table="[Composicion_Examen]" Index="[XIF2Composicion_Examen]" Alias="[CE]" IndexKind="NonClustered" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Composicion_Examen]" Alias="[CE]" Column="Cod_Grado" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[SIPN].[dbo].[Contenidos].[Cod_Grado] as [CO].[Cod_Grado]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Contenidos]" Alias="[CO]" Column="Cod_Grado" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="14" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="3.35849" EstimateRewinds="0" EstimateRows="4.35849" LogicalOp="Clustered Index Seek" NodeId="33" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00381408" TableCardinality="3">
<OutputList>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Composicion_Examen]" Alias="[CE]" Column="Cod_Asignatura" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="63" ActualEndOfScans="91" ActualExecutions="154" />
</RunTimeInformation>
<IndexScan Lookup="true" Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Composicion_Examen]" Alias="[CE]" Column="Cod_Asignatura" />
</DefinedValue>
</DefinedValues>
<Object Database="[SIPN]" Schema="[dbo]" Table="[Composicion_Examen]" Index="[PK__Composic__39E0295010AB74EC]" Alias="[CE]" TableReferenceId="-1" IndexKind="Clustered" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Composicion_Examen]" Alias="[CE]" Column="Cod_Examen" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[SIPN].[dbo].[Composicion_Examen].[Cod_Examen] as [CE].[Cod_Examen]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Composicion_Examen]" Alias="[CE]" Column="Cod_Examen" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
<Predicate>
<ScalarOperator ScalarString="[SIPN].[dbo].[Composicion_Examen].[Cod_Convocatoria] as [CE].[Cod_Convocatoria]=(2) AND [SIPN].[dbo].[Composicion_Examen].[Cod_Asignatura] as [CE].[Cod_Asignatura]=[SIPN].[dbo].[Contenidos].[Cod_Asignatura] as [CO].[Cod_Asignatura]">
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Composicion_Examen]" Alias="[CE]" Column="Cod_Convocatoria" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(2)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Composicion_Examen]" Alias="[CE]" Column="Cod_Asignatura" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Contenidos]" Alias="[CO]" Column="Cod_Asignatura" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="15" EstimateCPU="4.1E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="3.35849" EstimateRows="41" LogicalOp="Compute Scalar" NodeId="37" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.00376008">
<OutputList>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Comptencias_Examen]" Alias="[COEX]" Column="TemaID" />
<ColumnReference Column="Expr1036" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1036" />
<ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[SIPN].[dbo].[Comptencias_Examen].[CompetenciaID] as [COEX].[CompetenciaID],0)">
<Convert DataType="int" Style="0" Implicit="true">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Comptencias_Examen]" Alias="[COEX]" Column="CompetenciaID" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="25" EstimateCPU="0.0001236" EstimateIO="0.0032035" EstimateRebinds="0" EstimateRewinds="3.35849" EstimateRows="41" LogicalOp="Clustered Index Scan" NodeId="38" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.00374221" TableCardinality="41">
<OutputList>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Comptencias_Examen]" Alias="[COEX]" Column="TemaID" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Comptencias_Examen]" Alias="[COEX]" Column="CompetenciaID" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="2583" ActualEndOfScans="63" ActualExecutions="63" />
</RunTimeInformation>
<IndexScan Ordered="false" ForcedIndex="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Comptencias_Examen]" Alias="[COEX]" Column="TemaID" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Comptencias_Examen]" Alias="[COEX]" Column="CompetenciaID" />
</DefinedValue>
</DefinedValues>
<Object Database="[SIPN]" Schema="[dbo]" Table="[Comptencias_Examen]" Index="[PK_Comptencias_Examen]" Alias="[COEX]" IndexKind="Clustered" />
</IndexScan>
</RelOp>
</ComputeScalar>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="15" EstimateCPU="9.5E-05" EstimateIO="0.0069072" EstimateRebinds="0" EstimateRewinds="3.35849" EstimateRows="15" LogicalOp="Clustered Index Scan" NodeId="43" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.00732126" TableCardinality="15">
<OutputList>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Tema_Examen]" Alias="[TE]" Column="ID_Tema" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="945" ActualEndOfScans="63" ActualExecutions="63" />
</RunTimeInformation>
<IndexScan Ordered="false" ForcedIndex="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Tema_Examen]" Alias="[TE]" Column="ID_Tema" />
</DefinedValue>
</DefinedValues>
<Object Database="[SIPN]" Schema="[dbo]" Table="[Tema_Examen]" Index="[PK_Tema_Examen]" Alias="[TE]" IndexKind="Clustered" />
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="20" EstimateCPU="0.00417825" EstimateIO="0.0112613" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="315" LogicalOp="Sort" NodeId="45" Parallel="false" PhysicalOp="Sort" EstimatedTotalSubtreeCost="0.0198088">
<OutputList>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[CuadernillosLinea]" Alias="[CL]" Column="CuadernilloID" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[CuadernillosLinea]" Alias="[CL]" Column="Numero" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[CuadernillosLinea]" Alias="[CL]" Column="Cod_Competencia" />
</OutputList>
<MemoryFractions Input="0.25" Output="0.25" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRebinds="1" ActualRewinds="0" ActualRows="295" ActualEndOfScans="0" ActualExecutions="1" />
</RunTimeInformation>
<Sort Distinct="false">
<OrderBy>
<OrderByColumn Ascending="true">
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[CuadernillosLinea]" Alias="[CL]" Column="Cod_Competencia" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[CuadernillosLinea]" Alias="[CL]" Column="CuadernilloID" />
</OrderByColumn>
</OrderBy>
<RelOp AvgRowSize="20" EstimateCPU="0.0005035" EstimateIO="0.00386574" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="315" LogicalOp="Clustered Index Scan" NodeId="46" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.00436924" TableCardinality="315">
<OutputList>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[CuadernillosLinea]" Alias="[CL]" Column="CuadernilloID" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[CuadernillosLinea]" Alias="[CL]" Column="Numero" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[CuadernillosLinea]" Alias="[CL]" Column="Cod_Competencia" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="315" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<IndexScan Ordered="false" ForcedIndex="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[CuadernillosLinea]" Alias="[CL]" Column="CuadernilloID" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[CuadernillosLinea]" Alias="[CL]" Column="Numero" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[CuadernillosLinea]" Alias="[CL]" Column="Cod_Competencia" />
</DefinedValue>
</DefinedValues>
<Object Database="[SIPN]" Schema="[dbo]" Table="[CuadernillosLinea]" Index="[PK__Cuaderni__FD420CBD1B13F4C6]" Alias="[CL]" IndexKind="Clustered" />
</IndexScan>
</RelOp>
</Sort>
</RelOp>
</Merge>
</RelOp>
<RelOp AvgRowSize="34" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="36.7574" EstimateRewinds="0.379435" EstimateRows="1" LogicalOp="Index Seek" NodeId="48" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0922642" TableCardinality="1177800">
<OutputList>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Alias="[P]" Column="codigo_distrito" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Alias="[P]" Column="codigo_centro" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Alias="[P]" Column="modalidad" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Alias="[P]" Column="asignatura" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Alias="[P]" Column="p" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="168934" ActualEndOfScans="152" ActualExecutions="152" />
</RunTimeInformation>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Alias="[P]" Column="codigo_distrito" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Alias="[P]" Column="codigo_centro" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Alias="[P]" Column="modalidad" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Alias="[P]" Column="asignatura" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Alias="[P]" Column="p" />
</DefinedValue>
</DefinedValues>
<Object Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Index="[Idx]" Alias="[P]" IndexKind="NonClustered" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Alias="[P]" Column="modalidad" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Alias="[P]" Column="examen" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Alias="[P]" Column="asignatura" />
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Alias="[P]" Column="Pno" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[Expr1037]">
<Identifier>
<ColumnReference Column="Expr1037" />
</Identifier>
</ScalarOperator>
<ScalarOperator ScalarString="[SIPN].[dbo].[Cuadernillos].[TipoPrueba] as [C].[TipoPrueba]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Cuadernillos]" Alias="[C]" Column="TipoPrueba" />
</Identifier>
</ScalarOperator>
<ScalarOperator ScalarString="[SIPN].[dbo].[Contenidos].[Cod_Asignatura] as [CO].[Cod_Asignatura]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Contenidos]" Alias="[CO]" Column="Cod_Asignatura" />
</Identifier>
</ScalarOperator>
<ScalarOperator ScalarString="[SIPN].[dbo].[CuadernillosLinea].[Numero] as [CL].[Numero]">
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[CuadernillosLinea]" Alias="[CL]" Column="Numero" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="9" EstimateCPU="4.8E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Filter" NodeId="49" Parallel="false" PhysicalOp="Filter" EstimatedTotalSubtreeCost="0.00329414">
<OutputList />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="168934" ActualEndOfScans="0" ActualExecutions="168934" />
</RunTimeInformation>
<Filter StartupExpression="false">
<RelOp AvgRowSize="9" EstimateCPU="4.8E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Assert" NodeId="50" Parallel="false" PhysicalOp="Assert" EstimatedTotalSubtreeCost="0.00329366">
<OutputList>
<ColumnReference Column="Expr1035" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="168934" ActualEndOfScans="0" ActualExecutions="168934" />
</RunTimeInformation>
<Assert StartupExpression="false">
<RelOp AvgRowSize="17" EstimateCPU="1.1E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Aggregate" NodeId="51" Parallel="false" PhysicalOp="Stream Aggregate" EstimatedTotalSubtreeCost="0.00329318">
<OutputList>
<ColumnReference Column="Expr1034" />
<ColumnReference Column="Expr1035" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="168934" ActualEndOfScans="0" ActualExecutions="168934" />
</RunTimeInformation>
<StreamAggregate>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1034" />
<ScalarOperator ScalarString="Count(*)">
<Aggregate AggType="countstar" Distinct="false" />
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1035" />
<ScalarOperator ScalarString="ANY([SIPN].[dbo].[Modalidades].[Cod_Grado] as [M].[Cod_Grado])">
<Aggregate AggType="ANY" Distinct="false">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Modalidades]" Alias="[M]" Column="Cod_Grado" />
</Identifier>
</ScalarOperator>
</Aggregate>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="14" EstimateCPU="0.0001636" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Scan" NodeId="53" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0032886" TableCardinality="6">
<OutputList>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Modalidades]" Alias="[M]" Column="Cod_Grado" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="168934" ActualEndOfScans="168934" ActualExecutions="168934" />
</RunTimeInformation>
<IndexScan Ordered="false" ForcedIndex="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Modalidades]" Alias="[M]" Column="Cod_Grado" />
</DefinedValue>
</DefinedValues>
<Object Database="[SIPN]" Schema="[dbo]" Table="[Modalidades]" Index="[PK_Modalidades]" Alias="[M]" IndexKind="Clustered" />
<Predicate>
<ScalarOperator ScalarString="[SIPN].[dbo].[Preguntas].[modalidad] as [P].[modalidad]=CONVERT_IMPLICIT(int,[SIPN].[dbo].[Modalidades].[Cod_Modalidad] as [M].[Cod_Modalidad],0)">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Preguntas]" Alias="[P]" Column="modalidad" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Convert DataType="int" Style="0" Implicit="true">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Modalidades]" Alias="[M]" Column="Cod_Modalidad" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
</StreamAggregate>
</RelOp>
<Predicate>
<ScalarOperator ScalarString="CASE WHEN [Expr1034]>(1) THEN (0) ELSE NULL END">
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="GT">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1034" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(1)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(0)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Predicate>
</Assert>
</RelOp>
<Predicate>
<ScalarOperator ScalarString="[Expr1035]=[SIPN].[dbo].[Contenidos].[Cod_Grado] as [CO].[Cod_Grado]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1035" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SIPN]" Schema="[dbo]" Table="[Contenidos]" Alias="[CO]" Column="Cod_Grado" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</Filter>
</RelOp>
</NestedLoops>
</RelOp>
</Sort>
</RelOp>
</StreamAggregate>
</RelOp>
</ComputeScalar>
</RelOp>
</ComputeScalar>
</RelOp>
</Top>
</RelOp>
</ComputeScalar>
</RelOp>
</ComputeScalar>
</RelOp>
</ComputeScalar>
</RelOp>
</Update>
</RelOp>
</QueryPlan>
</StmtSimple>
</Statements>
</Batch>
</BatchSequence>
</ShowPlanXML>
Thanks guys
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply