By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
1 rows affected
(No column name) |
---|
1 |
Microsoft SQL Server 2005 XML Showplan |
---|
<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.8" Build="14.0.3015.40"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT COUNT(*) FROM [dbo].[Promocje_31BIT] WHERE [d7]=@1 AND [d8]=@2 AND [d9]=@3 AND [d10]=@4 AND [d11]=@5 AND [d12]=@6 AND [d13]=@7 AND [d14]=@8" StatementId="1" StatementCompId="2" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="0.00328438" StatementEstRows="1" SecurityPolicyApplied="false" StatementOptmLevel="TRIVIAL" QueryHash="0x01F2E56752E05AB7" QueryPlanHash="0xF60F116A32377265" CardinalityEstimationModelVersion="140"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"></StatementSetOptions><QueryPlan DegreeOfParallelism="0" NonParallelPlanReason="NoParallelPlansInDesktopOrExpressEdition" CachedPlanSize="32" CompileTime="0" CompileCPU="0" CompileMemory="200"><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="419378" EstimatedPagesCached="26211" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="2346664"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2018-02-25T16:58:46.98" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_0000000E_35BCFE0A]" Table="[Promocje_31BIT]" Schema="[dbo]" Database="[fiddle_9fde78daf3884565b836eea640a71c07]"></StatisticsInfo><StatisticsInfo LastUpdate="2018-02-25T16:58:46.98" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_0000000B_35BCFE0A]" Table="[Promocje_31BIT]" Schema="[dbo]" Database="[fiddle_9fde78daf3884565b836eea640a71c07]"></StatisticsInfo><StatisticsInfo LastUpdate="2018-02-25T16:58:46.98" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_0000000D_35BCFE0A]" Table="[Promocje_31BIT]" Schema="[dbo]" Database="[fiddle_9fde78daf3884565b836eea640a71c07]"></StatisticsInfo><StatisticsInfo LastUpdate="2018-02-25T16:58:46.98" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_0000000A_35BCFE0A]" Table="[Promocje_31BIT]" Schema="[dbo]" Database="[fiddle_9fde78daf3884565b836eea640a71c07]"></StatisticsInfo><StatisticsInfo LastUpdate="2018-02-25T16:58:46.98" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000010_35BCFE0A]" Table="[Promocje_31BIT]" Schema="[dbo]" Database="[fiddle_9fde78daf3884565b836eea640a71c07]"></StatisticsInfo><StatisticsInfo LastUpdate="2018-02-25T16:58:46.98" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_0000000F_35BCFE0A]" Table="[Promocje_31BIT]" Schema="[dbo]" Database="[fiddle_9fde78daf3884565b836eea640a71c07]"></StatisticsInfo><StatisticsInfo LastUpdate="2018-02-25T16:58:46.98" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_0000000C_35BCFE0A]" Table="[Promocje_31BIT]" Schema="[dbo]" Database="[fiddle_9fde78daf3884565b836eea640a71c07]"></StatisticsInfo><StatisticsInfo LastUpdate="2018-02-25T16:58:46.98" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000009_35BCFE0A]" Table="[Promocje_31BIT]" Schema="[dbo]" Database="[fiddle_9fde78daf3884565b836eea640a71c07]"></StatisticsInfo></OptimizerStatsUsage><TraceFlags IsCompileTime="1"><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><TraceFlags IsCompileTime="0"><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><QueryTimeStats ElapsedTime="0" CpuTime="0"></QueryTimeStats><RelOp NodeId="0" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="0" AvgRowSize="11" EstimatedTotalSubtreeCost="0.00328438" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1003"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1003"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[Expr1004],0)"><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Expr1004"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="1" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="1.1e-006" AvgRowSize="11" EstimatedTotalSubtreeCost="0.00328438" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1004"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Expr1004"></ColumnReference><ScalarOperator ScalarString="Count(*)"><Aggregate AggType="countstar" Distinct="0"></Aggregate></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="2" PhysicalOp="Table Scan" LogicalOp="Table Scan" EstimateRows="1" EstimatedRowsRead="1" EstimateIO="0.0032035" EstimateCPU="7.96e-005" AvgRowSize="9" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="1" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="1" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="1" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><TableScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues></DefinedValues><Object Database="[fiddle_9fde78daf3884565b836eea640a71c07]" Schema="[dbo]" Table="[Promocje_31BIT]" IndexKind="Heap" Storage="RowStore"></Object><Predicate><ScalarOperator ScalarString="[fiddle_9fde78daf3884565b836eea640a71c07].[dbo].[Promocje_31BIT].[D7]=[@1] AND [fiddle_9fde78daf3884565b836eea640a71c07].[dbo].[Promocje_31BIT].[D8]=[@2] AND [fiddle_9fde78daf3884565b836eea640a71c07].[dbo].[Promocje_31BIT].[D9]=[@3] AND [fiddle_9fde78daf3884565b836eea640a71c07].[dbo].[Promocje_31BIT].[D10]=[@4] AND [fiddle_9fde78daf3884565b836eea640a71c07].[dbo].[Promocje_31BIT].[D11]=[@5] AND [fiddle_9fde78daf3884565b836eea640a71c07].[dbo].[Promocje_31BIT].[D12]=[@6] AND [fiddle_9fde78daf3884565b836eea640a71c07].[dbo].[Promocje_31BIT].[D13]=[@7] AND [fiddle_9fde78daf3884565b836eea640a71c07].[dbo].[Promocje_31BIT].[D14]=[@8]"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_9fde78daf3884565b836eea640a71c07]" Schema="[dbo]" Table="[Promocje_31BIT]" Column="D7"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="@1"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_9fde78daf3884565b836eea640a71c07]" Schema="[dbo]" Table="[Promocje_31BIT]" Column="D8"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="@2"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_9fde78daf3884565b836eea640a71c07]" Schema="[dbo]" Table="[Promocje_31BIT]" Column="D9"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="@3"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_9fde78daf3884565b836eea640a71c07]" Schema="[dbo]" Table="[Promocje_31BIT]" Column="D10"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="@4"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_9fde78daf3884565b836eea640a71c07]" Schema="[dbo]" Table="[Promocje_31BIT]" Column="D11"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="@5"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_9fde78daf3884565b836eea640a71c07]" Schema="[dbo]" Table="[Promocje_31BIT]" Column="D12"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="@6"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_9fde78daf3884565b836eea640a71c07]" Schema="[dbo]" Table="[Promocje_31BIT]" Column="D13"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="@7"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_9fde78daf3884565b836eea640a71c07]" Schema="[dbo]" Table="[Promocje_31BIT]" Column="D14"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="@8"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></TableScan></RelOp></StreamAggregate></RelOp></ComputeScalar></RelOp><ParameterList><ColumnReference Column="@8" ParameterDataType="tinyint" ParameterCompiledValue="(1)" ParameterRuntimeValue="(1)"></ColumnReference><ColumnReference Column="@7" ParameterDataType="tinyint" ParameterCompiledValue="(1)" ParameterRuntimeValue="(1)"></ColumnReference><ColumnReference Column="@6" ParameterDataType="tinyint" ParameterCompiledValue="(1)" ParameterRuntimeValue="(1)"></ColumnReference><ColumnReference Column="@5" ParameterDataType="tinyint" ParameterCompiledValue="(1)" ParameterRuntimeValue="(1)"></ColumnReference><ColumnReference Column="@4" ParameterDataType="tinyint" ParameterCompiledValue="(1)" ParameterRuntimeValue="(1)"></ColumnReference><ColumnReference Column="@3" ParameterDataType="tinyint" ParameterCompiledValue="(1)" ParameterRuntimeValue="(1)"></ColumnReference><ColumnReference Column="@2" ParameterDataType="tinyint" ParameterCompiledValue="(1)" ParameterRuntimeValue="(1)"></ColumnReference><ColumnReference Column="@1" ParameterDataType="tinyint" ParameterCompiledValue="(1)" ParameterRuntimeValue="(1)"></ColumnReference></ParameterList></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML> |
(No column name) |
---|
1 |
Microsoft SQL Server 2005 XML Showplan |
---|
<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.8" Build="14.0.3015.40"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT COUNT(*) 
 FROM dbo.Promocje_31BIT 
 WHERE d7 IS NOT NULL
 AND d8 IS NOT NULL
 AND d9 IS NOT NULL
 AND d10 IS NOT NULL
 AND d11 IS NOT NULL
 AND d12 IS NOT NULL
 AND d13 IS NOT NULL
 AND d14 IS NOT NULL" StatementId="1" StatementCompId="2" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="0.00328438" StatementEstRows="1" SecurityPolicyApplied="false" StatementOptmLevel="TRIVIAL" QueryHash="0x9B6640132B998248" QueryPlanHash="0xF60F116A32377265" CardinalityEstimationModelVersion="140"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"></StatementSetOptions><QueryPlan DegreeOfParallelism="0" NonParallelPlanReason="NoParallelPlansInDesktopOrExpressEdition" CachedPlanSize="24" CompileTime="15" CompileCPU="15" CompileMemory="192"><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="419378" EstimatedPagesCached="26211" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="2346664"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2018-02-25T16:58:46.98" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_0000000E_35BCFE0A]" Table="[Promocje_31BIT]" Schema="[dbo]" Database="[fiddle_9fde78daf3884565b836eea640a71c07]"></StatisticsInfo><StatisticsInfo LastUpdate="2018-02-25T16:58:46.98" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_0000000B_35BCFE0A]" Table="[Promocje_31BIT]" Schema="[dbo]" Database="[fiddle_9fde78daf3884565b836eea640a71c07]"></StatisticsInfo><StatisticsInfo LastUpdate="2018-02-25T16:58:46.98" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_0000000D_35BCFE0A]" Table="[Promocje_31BIT]" Schema="[dbo]" Database="[fiddle_9fde78daf3884565b836eea640a71c07]"></StatisticsInfo><StatisticsInfo LastUpdate="2018-02-25T16:58:46.98" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_0000000A_35BCFE0A]" Table="[Promocje_31BIT]" Schema="[dbo]" Database="[fiddle_9fde78daf3884565b836eea640a71c07]"></StatisticsInfo><StatisticsInfo LastUpdate="2018-02-25T16:58:46.98" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000010_35BCFE0A]" Table="[Promocje_31BIT]" Schema="[dbo]" Database="[fiddle_9fde78daf3884565b836eea640a71c07]"></StatisticsInfo><StatisticsInfo LastUpdate="2018-02-25T16:58:46.98" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_0000000F_35BCFE0A]" Table="[Promocje_31BIT]" Schema="[dbo]" Database="[fiddle_9fde78daf3884565b836eea640a71c07]"></StatisticsInfo><StatisticsInfo LastUpdate="2018-02-25T16:58:46.98" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_0000000C_35BCFE0A]" Table="[Promocje_31BIT]" Schema="[dbo]" Database="[fiddle_9fde78daf3884565b836eea640a71c07]"></StatisticsInfo><StatisticsInfo LastUpdate="2018-02-25T16:58:46.98" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000009_35BCFE0A]" Table="[Promocje_31BIT]" Schema="[dbo]" Database="[fiddle_9fde78daf3884565b836eea640a71c07]"></StatisticsInfo></OptimizerStatsUsage><TraceFlags IsCompileTime="1"><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><TraceFlags IsCompileTime="0"><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><QueryTimeStats ElapsedTime="0" CpuTime="0"></QueryTimeStats><RelOp NodeId="0" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="0" AvgRowSize="11" EstimatedTotalSubtreeCost="0.00328438" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1003"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1003"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[Expr1004],0)"><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Expr1004"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="1" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="1.1e-006" AvgRowSize="11" EstimatedTotalSubtreeCost="0.00328438" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1004"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Expr1004"></ColumnReference><ScalarOperator ScalarString="Count(*)"><Aggregate AggType="countstar" Distinct="0"></Aggregate></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="2" PhysicalOp="Table Scan" LogicalOp="Table Scan" EstimateRows="1" EstimatedRowsRead="1" EstimateIO="0.0032035" EstimateCPU="7.96e-005" AvgRowSize="9" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="1" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="1" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="1" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><TableScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues></DefinedValues><Object Database="[fiddle_9fde78daf3884565b836eea640a71c07]" Schema="[dbo]" Table="[Promocje_31BIT]" IndexKind="Heap" Storage="RowStore"></Object><Predicate><ScalarOperator ScalarString="[fiddle_9fde78daf3884565b836eea640a71c07].[dbo].[Promocje_31BIT].[D7] IS NOT NULL AND [fiddle_9fde78daf3884565b836eea640a71c07].[dbo].[Promocje_31BIT].[D8] IS NOT NULL AND [fiddle_9fde78daf3884565b836eea640a71c07].[dbo].[Promocje_31BIT].[D9] IS NOT NULL AND [fiddle_9fde78daf3884565b836eea640a71c07].[dbo].[Promocje_31BIT].[D10] IS NOT NULL AND [fiddle_9fde78daf3884565b836eea640a71c07].[dbo].[Promocje_31BIT].[D11] IS NOT NULL AND [fiddle_9fde78daf3884565b836eea640a71c07].[dbo].[Promocje_31BIT].[D12] IS NOT NULL AND [fiddle_9fde78daf3884565b836eea640a71c07].[dbo].[Promocje_31BIT].[D13] IS NOT NULL AND [fiddle_9fde78daf3884565b836eea640a71c07].[dbo].[Promocje_31BIT].[D14] IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_9fde78daf3884565b836eea640a71c07]" Schema="[dbo]" Table="[Promocje_31BIT]" Column="D7"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_9fde78daf3884565b836eea640a71c07]" Schema="[dbo]" Table="[Promocje_31BIT]" Column="D8"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_9fde78daf3884565b836eea640a71c07]" Schema="[dbo]" Table="[Promocje_31BIT]" Column="D9"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_9fde78daf3884565b836eea640a71c07]" Schema="[dbo]" Table="[Promocje_31BIT]" Column="D10"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_9fde78daf3884565b836eea640a71c07]" Schema="[dbo]" Table="[Promocje_31BIT]" Column="D11"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_9fde78daf3884565b836eea640a71c07]" Schema="[dbo]" Table="[Promocje_31BIT]" Column="D12"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_9fde78daf3884565b836eea640a71c07]" Schema="[dbo]" Table="[Promocje_31BIT]" Column="D13"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_9fde78daf3884565b836eea640a71c07]" Schema="[dbo]" Table="[Promocje_31BIT]" Column="D14"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></TableScan></RelOp></StreamAggregate></RelOp></ComputeScalar></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML> |