Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?xml version="1.0" encoding="utf-16"?>
- <ShowPlanXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="1.2" Build="12.0.2402.0" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
- <BatchSequence>
- <Batch>
- <Statements>
- <StmtSimple StatementCompId="60" StatementEstRows="1" StatementId="1" StatementOptmLevel="FULL" StatementOptmEarlyAbortReason="TimeOut" CardinalityEstimationModelVersion="70" StatementSubTreeCost="3.32479" StatementText="SELECT COUNT_BIG(1) FROM dbo.Conteudos AS conteudo INNER JOIN dbo.Usuarios AS usuario ON conteudo.UsuarioId = usuario.UsuarioId INNER JOIN dbo.ConteudosCategorias AS conteudoCategoria ON conteudo.ConteudoId = conteudoCategoria.ConteudoId INNER JOIN dbo.ConteudosGeneros AS conteudoGenero ON conteudo.ConteudoId = conteudoGenero.ConteudoId INNER JOIN dbo.ConteudosGeneros AS conteudoGenero2 ON conteudo.ConteudoId = conteudoGenero2.ConteudoId WHERE conteudo.ConteudoTipo = 6 AND conteudo.ConteudoExcluido = 0 AND usuario.UsuarioExcluido = 0 AND usuario.UsuarioBanido = 0 AND conteudoCategoria.CategoriaId = @CategoriaId AND conteudoGenero.GeneroId = @GeneroId AND conteudoGenero2.GeneroId = @SegundoGeneroId AND NOT EXISTS (SELECT t0.ConteudoId FROM dbo.ConteudosPersonagens AS t0 WHERE t0.ConteudoId = conteudo.ConteudoId AND t0.PersonagemId = @RemoverPersonagemId) AND NOT EXISTS (SELECT t0.ConteudoId FROM dbo.ConteudosGeneros AS t0 WHERE t0.ConteudoId = conteudo.ConteudoId AND t0.GeneroId = @RemoverGeneroId) OPTION (QUERYTRACEON 9481)" StatementType="SELECT" QueryHash="0x4C5E796462CBA4E4" QueryPlanHash="0xB9823124657FD100" RetrievedFromCache="true">
- <StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" />
- <QueryPlan DegreeOfParallelism="1" MemoryGrant="1024" CachedPlanSize="72" CompileTime="97" CompileCPU="97" CompileMemory="3080">
- <MemoryGrantInfo SerialRequiredMemory="512" SerialDesiredMemory="960" RequiredMemory="512" DesiredMemory="960" RequestedMemory="1024" GrantWaitTime="0" GrantedMemory="1024" MaxUsedMemory="168" />
- <OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="247466" EstimatedPagesCached="371200" EstimatedAvailableDegreeOfParallelism="8" />
- <RelOp AvgRowSize="15" EstimateCPU="0.0235911" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Aggregate" NodeId="0" Parallel="false" PhysicalOp="Stream Aggregate" EstimatedTotalSubtreeCost="3.32479">
- <OutputList>
- <ColumnReference Column="Expr1007" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <StreamAggregate>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1007" />
- <ScalarOperator ScalarString="Count(*)">
- <Aggregate AggType="countstar" Distinct="false" />
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="9" EstimateCPU="0.485642" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="39317.7" LogicalOp="Inner Join" NodeId="1" Parallel="false" PhysicalOp="Merge Join" EstimatedTotalSubtreeCost="3.3012">
- <OutputList />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="461" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <Merge ManyToMany="false">
- <InnerSideJoinColumns>
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[Conteudos]" Alias="[conteudo]" Column="UsuarioId" />
- </InnerSideJoinColumns>
- <OuterSideJoinColumns>
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[Usuarios]" Alias="[usuario]" Column="UsuarioId" />
- </OuterSideJoinColumns>
- <Residual>
- <ScalarOperator ScalarString="[Spirit].[dbo].[Conteudos].[UsuarioId] as [conteudo].[UsuarioId]=[Spirit].[dbo].[Usuarios].[UsuarioId] as [usuario].[UsuarioId]">
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[Conteudos]" Alias="[conteudo]" Column="UsuarioId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[Usuarios]" Alias="[usuario]" Column="UsuarioId" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Residual>
- <RelOp AvgRowSize="11" EstimateCPU="0.178169" EstimateIO="0.16292" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="161829" LogicalOp="Index Seek" NodeId="2" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.341089" TableCardinality="486108">
- <OutputList>
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[Usuarios]" Alias="[usuario]" Column="UsuarioId" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="458520" ActualEndOfScans="0" ActualExecutions="1" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[Usuarios]" Alias="[usuario]" Column="UsuarioId" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[Spirit]" Schema="[dbo]" Table="[Usuarios]" Index="[IDX_Usuarios_UsuarioBanido_UsuarioExcluido]" Alias="[usuario]" IndexKind="NonClustered" Storage="RowStore" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[Usuarios]" Alias="[usuario]" Column="UsuarioBanido" />
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[Usuarios]" Alias="[usuario]" Column="UsuarioExcluido" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="(0)">
- <Const ConstValue="(0)" />
- </ScalarOperator>
- <ScalarOperator ScalarString="(0)">
- <Const ConstValue="(0)" />
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- <RelOp AvgRowSize="11" EstimateCPU="0.0164348" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="41529.2" LogicalOp="Inner Join" NodeId="3" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="2.47447">
- <OutputList>
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[Conteudos]" Alias="[conteudo]" Column="UsuarioId" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="488" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <NestedLoops Optimized="false" WithOrderedPrefetch="true">
- <OuterReferences>
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[ConteudosGeneros]" Alias="[conteudoGenero2]" Column="ConteudoId" />
- <ColumnReference Column="Expr1009" />
- </OuterReferences>
- <RelOp AvgRowSize="15" EstimateCPU="0.0733407" EstimateIO="0.0112613" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3931.77" LogicalOp="Sort" NodeId="5" Parallel="false" PhysicalOp="Sort" EstimatedTotalSubtreeCost="1.59832">
- <OutputList>
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[Conteudos]" Alias="[conteudo]" Column="UsuarioId" />
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[ConteudosGeneros]" Alias="[conteudoGenero2]" Column="ConteudoId" />
- </OutputList>
- <MemoryFractions Input="1" Output="1" />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRebinds="1" ActualRewinds="0" ActualRows="3062" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <Sort Distinct="false">
- <OrderBy>
- <OrderByColumn Ascending="true">
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[Conteudos]" Alias="[conteudo]" Column="UsuarioId" />
- </OrderByColumn>
- </OrderBy>
- <RelOp AvgRowSize="15" EstimateCPU="0.202792" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3931.77" LogicalOp="Inner Join" NodeId="6" Parallel="false" PhysicalOp="Merge Join" EstimatedTotalSubtreeCost="1.51372">
- <OutputList>
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[Conteudos]" Alias="[conteudo]" Column="UsuarioId" />
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[ConteudosGeneros]" Alias="[conteudoGenero2]" Column="ConteudoId" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="3062" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <Merge ManyToMany="false">
- <InnerSideJoinColumns>
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[ConteudosGeneros]" Alias="[conteudoGenero]" Column="ConteudoId" />
- </InnerSideJoinColumns>
- <OuterSideJoinColumns>
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[ConteudosGeneros]" Alias="[conteudoGenero2]" Column="ConteudoId" />
- </OuterSideJoinColumns>
- <Residual>
- <ScalarOperator ScalarString="[Spirit].[dbo].[ConteudosGeneros].[ConteudoId] as [conteudoGenero].[ConteudoId]=[Spirit].[dbo].[ConteudosGeneros].[ConteudoId] as [conteudoGenero2].[ConteudoId]">
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[ConteudosGeneros]" Alias="[conteudoGenero]" Column="ConteudoId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[ConteudosGeneros]" Alias="[conteudoGenero2]" Column="ConteudoId" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Residual>
- <RelOp AvgRowSize="11" EstimateCPU="0.0599929" EstimateIO="0.0561249" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="54396.2" LogicalOp="Index Seek" NodeId="7" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.116118" TableCardinality="2062640">
- <OutputList>
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[ConteudosGeneros]" Alias="[conteudoGenero2]" Column="ConteudoId" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="54984" ActualEndOfScans="0" ActualExecutions="1" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[ConteudosGeneros]" Alias="[conteudoGenero2]" Column="ConteudoId" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[Spirit]" Schema="[dbo]" Table="[ConteudosGeneros]" Index="[IDX_ConteudosGeneros_GeneroId]" Alias="[conteudoGenero2]" IndexKind="NonClustered" Storage="RowStore" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[ConteudosGeneros]" Alias="[conteudoGenero2]" Column="GeneroId" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[@SegundoGeneroId]">
- <Identifier>
- <ColumnReference Column="@SegundoGeneroId" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- <RelOp AvgRowSize="19" EstimateCPU="0.162514" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="39317.7" LogicalOp="Left Anti Semi Join" NodeId="8" Parallel="false" PhysicalOp="Merge Join" EstimatedTotalSubtreeCost="1.1948">
- <OutputList>
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[Conteudos]" Alias="[conteudo]" Column="ConteudoId" />
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[Conteudos]" Alias="[conteudo]" Column="UsuarioId" />
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[ConteudosGeneros]" Alias="[conteudoGenero]" Column="ConteudoId" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="17416" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <Merge ManyToMany="false">
- <InnerSideJoinColumns>
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[ConteudosGeneros]" Alias="[t0]" Column="ConteudoId" />
- </InnerSideJoinColumns>
- <OuterSideJoinColumns>
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[Conteudos]" Alias="[conteudo]" Column="ConteudoId" />
- </OuterSideJoinColumns>
- <Residual>
- <ScalarOperator ScalarString="[Spirit].[dbo].[ConteudosGeneros].[ConteudoId] as [t0].[ConteudoId]=[Spirit].[dbo].[Conteudos].[ConteudoId] as [conteudo].[ConteudoId]">
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[ConteudosGeneros]" Alias="[t0]" Column="ConteudoId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[Conteudos]" Alias="[conteudo]" Column="ConteudoId" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Residual>
- <RelOp AvgRowSize="19" EstimateCPU="0.174843" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="45844" LogicalOp="Left Anti Semi Join" NodeId="9" Parallel="false" PhysicalOp="Merge Join" EstimatedTotalSubtreeCost="0.97336">
- <OutputList>
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[Conteudos]" Alias="[conteudo]" Column="ConteudoId" />
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[Conteudos]" Alias="[conteudo]" Column="UsuarioId" />
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[ConteudosGeneros]" Alias="[conteudoGenero]" Column="ConteudoId" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="23074" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <Merge ManyToMany="false">
- <InnerSideJoinColumns>
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[ConteudosPersonagens]" Alias="[t0]" Column="ConteudoId" />
- </InnerSideJoinColumns>
- <OuterSideJoinColumns>
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[Conteudos]" Alias="[conteudo]" Column="ConteudoId" />
- </OuterSideJoinColumns>
- <Residual>
- <ScalarOperator ScalarString="[Spirit].[dbo].[ConteudosPersonagens].[ConteudoId] as [t0].[ConteudoId]=[Spirit].[dbo].[Conteudos].[ConteudoId] as [conteudo].[ConteudoId]">
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[ConteudosPersonagens]" Alias="[t0]" Column="ConteudoId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[Conteudos]" Alias="[conteudo]" Column="ConteudoId" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Residual>
- <RelOp AvgRowSize="19" EstimateCPU="0.351646" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="48786.4" LogicalOp="Inner Join" NodeId="10" Parallel="false" PhysicalOp="Merge Join" EstimatedTotalSubtreeCost="0.733736">
- <OutputList>
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[Conteudos]" Alias="[conteudo]" Column="ConteudoId" />
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[Conteudos]" Alias="[conteudo]" Column="UsuarioId" />
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[ConteudosGeneros]" Alias="[conteudoGenero]" Column="ConteudoId" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="26406" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <Merge ManyToMany="false">
- <InnerSideJoinColumns>
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[ConteudosGeneros]" Alias="[conteudoGenero]" Column="ConteudoId" />
- </InnerSideJoinColumns>
- <OuterSideJoinColumns>
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[Conteudos]" Alias="[conteudo]" Column="ConteudoId" />
- </OuterSideJoinColumns>
- <Residual>
- <ScalarOperator ScalarString="[Spirit].[dbo].[Conteudos].[ConteudoId] as [conteudo].[ConteudoId]=[Spirit].[dbo].[ConteudosGeneros].[ConteudoId] as [conteudoGenero].[ConteudoId]">
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[Conteudos]" Alias="[conteudo]" Column="ConteudoId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[ConteudosGeneros]" Alias="[conteudoGenero]" Column="ConteudoId" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Residual>
- <RelOp AvgRowSize="15" EstimateCPU="0.124692" EstimateIO="0.152029" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="113214" LogicalOp="Index Seek" NodeId="11" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.276722" TableCardinality="2380610">
- <OutputList>
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[Conteudos]" Alias="[conteudo]" Column="ConteudoId" />
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[Conteudos]" Alias="[conteudo]" Column="UsuarioId" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="201324" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[Conteudos]" Alias="[conteudo]" Column="ConteudoId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[Conteudos]" Alias="[conteudo]" Column="UsuarioId" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[Spirit]" Schema="[dbo]" Table="[Conteudos]" Index="[IDX_Conteudos_ConteudoTipo_ConteudoExcluido]" Alias="[conteudo]" IndexKind="NonClustered" Storage="RowStore" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[Conteudos]" Alias="[conteudo]" Column="ConteudoTipo" />
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[Conteudos]" Alias="[conteudo]" Column="ConteudoExcluido" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="(6)">
- <Const ConstValue="(6)" />
- </ScalarOperator>
- <ScalarOperator ScalarString="(0)">
- <Const ConstValue="(0)" />
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- <RelOp AvgRowSize="11" EstimateCPU="0.0543281" EstimateIO="0.0510371" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="49246.4" LogicalOp="Index Seek" NodeId="12" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.105365" TableCardinality="2062640">
- <OutputList>
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[ConteudosGeneros]" Alias="[conteudoGenero]" Column="ConteudoId" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="48871" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[ConteudosGeneros]" Alias="[conteudoGenero]" Column="ConteudoId" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[Spirit]" Schema="[dbo]" Table="[ConteudosGeneros]" Index="[IDX_ConteudosGeneros_GeneroId]" Alias="[conteudoGenero]" IndexKind="NonClustered" Storage="RowStore" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[ConteudosGeneros]" Alias="[conteudoGenero]" Column="GeneroId" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[@GeneroId]">
- <Identifier>
- <ColumnReference Column="@GeneroId" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </Merge>
- </RelOp>
- <RelOp AvgRowSize="11" EstimateCPU="0.0327417" EstimateIO="0.0320369" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="29622.4" LogicalOp="Index Seek" NodeId="14" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0647786" TableCardinality="1197300">
- <OutputList>
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[ConteudosPersonagens]" Alias="[t0]" Column="ConteudoId" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="28975" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[ConteudosPersonagens]" Alias="[t0]" Column="ConteudoId" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[Spirit]" Schema="[dbo]" Table="[ConteudosPersonagens]" Index="[IDX_ConteudosPersonagens_PersonagemId]" Alias="[t0]" IndexKind="NonClustered" Storage="RowStore" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[ConteudosPersonagens]" Alias="[t0]" Column="PersonagemId" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[@RemoverPersonagemId]">
- <Identifier>
- <ColumnReference Column="@RemoverPersonagemId" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </Merge>
- </RelOp>
- <RelOp AvgRowSize="11" EstimateCPU="0.029862" EstimateIO="0.0290634" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="27004.6" LogicalOp="Index Seek" NodeId="16" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0589254" TableCardinality="2062640">
- <OutputList>
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[ConteudosGeneros]" Alias="[t0]" Column="ConteudoId" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="27138" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[ConteudosGeneros]" Alias="[t0]" Column="ConteudoId" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[Spirit]" Schema="[dbo]" Table="[ConteudosGeneros]" Index="[IDX_ConteudosGeneros_GeneroId]" Alias="[t0]" IndexKind="NonClustered" Storage="RowStore" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[ConteudosGeneros]" Alias="[t0]" Column="GeneroId" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[@RemoverGeneroId]">
- <Identifier>
- <ColumnReference Column="@RemoverGeneroId" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </Merge>
- </RelOp>
- </Merge>
- </RelOp>
- </Sort>
- </RelOp>
- <RelOp AvgRowSize="9" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="3930.73" EstimateRewinds="0.0421537" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Index Seek" NodeId="19" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.859715" TableCardinality="687260">
- <OutputList />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="488" ActualEndOfScans="2574" ActualExecutions="3062" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues />
- <Object Database="[Spirit]" Schema="[dbo]" Table="[ConteudosCategorias]" Index="[IDX_ConteudosCategorias_CategoriaId]" Alias="[conteudoCategoria]" IndexKind="NonClustered" Storage="RowStore" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[ConteudosCategorias]" Alias="[conteudoCategoria]" Column="CategoriaId" />
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[ConteudosCategorias]" Alias="[conteudoCategoria]" Column="ConteudoId" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[@CategoriaId]">
- <Identifier>
- <ColumnReference Column="@CategoriaId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator ScalarString="[Spirit].[dbo].[ConteudosGeneros].[ConteudoId] as [conteudoGenero2].[ConteudoId]">
- <Identifier>
- <ColumnReference Database="[Spirit]" Schema="[dbo]" Table="[ConteudosGeneros]" Alias="[conteudoGenero2]" Column="ConteudoId" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- </Merge>
- </RelOp>
- </StreamAggregate>
- </RelOp>
- <ParameterList>
- <ColumnReference Column="@RemoverGeneroId" ParameterCompiledValue="(135)" ParameterRuntimeValue="(135)" />
- <ColumnReference Column="@RemoverPersonagemId" ParameterCompiledValue="(57007)" ParameterRuntimeValue="(57007)" />
- <ColumnReference Column="@SegundoGeneroId" ParameterCompiledValue="(58)" ParameterRuntimeValue="(58)" />
- <ColumnReference Column="@GeneroId" ParameterCompiledValue="(34)" ParameterRuntimeValue="(34)" />
- <ColumnReference Column="@CategoriaId" ParameterCompiledValue="(1227)" ParameterRuntimeValue="(1227)" />
- </ParameterList>
- </QueryPlan>
- </StmtSimple>
- </Statements>
- </Batch>
- </BatchSequence>
- </ShowPlanXML>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement