clear markdown compare help donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 541802 fiddles created (11229 in the last week).

CREATE TABLE dbo.Promocje_31BIT ( Nazwa VARCHAR(20) NOT NULL, Miesiac DATE NOT NULL, D1 BIT SPARSE NULL, D2 BIT SPARSE NULL, D3 BIT SPARSE NULL, D4 BIT SPARSE NULL, D5 BIT SPARSE NULL, D6 BIT SPARSE NULL, D7 BIT SPARSE NULL, D8 BIT SPARSE NULL, D9 BIT SPARSE NULL, D10 BIT SPARSE NULL, D11 BIT SPARSE NULL, D12 BIT SPARSE NULL, D13 BIT SPARSE NULL, D14 BIT SPARSE NULL, D15 BIT SPARSE NULL, D16 BIT SPARSE NULL, D17 BIT SPARSE NULL, D18 BIT SPARSE NULL, D19 BIT SPARSE NULL, D20 BIT SPARSE NULL, D21 BIT SPARSE NULL, D22 BIT SPARSE NULL, D23 BIT SPARSE NULL, D24 BIT SPARSE NULL, D25 BIT SPARSE NULL, D26 BIT SPARSE NULL, D27 BIT SPARSE NULL, D28 BIT SPARSE NULL, D29 BIT SPARSE NULL, D30 BIT SPARSE NULL, D31 BIT SPARSE NULL ); INSERT INTO dbo.Promocje_31BIT (Nazwa, miesiac, d7, d8,d9,d10, d11,d12,d13,d14) VALUES ('AAA', GETDATE(), 1,1,1,1,1,1,1,1) --CREATE INDEX inx ON dbo.Promocje_31BIT(d1,d2,d3,d4,d5,d6,d7,d8,d9,d10,d11,d12,d13,d14,d15,d16,d17,d18,d19,d20,d21,d22,d23,d24,d25,d26,d27,d28,d29,d30,d31)
1 rows affected
 hidden batch(es)


set statistics xml on; SELECT COUNT(*) FROM dbo.Promocje_31BIT WHERE d7 = 1 AND d8 = 1 AND d9 = 1 AND d10 = 1 AND d11 = 1 AND d12 = 1 AND d13 = 1 AND d14 = 1
(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>
 hidden batch(es)


set statistics xml on; 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
(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(*) &#xa; FROM dbo.Promocje_31BIT &#xa; WHERE d7 IS NOT NULL&#xa; AND d8 IS NOT NULL&#xa; AND d9 IS NOT NULL&#xa; AND d10 IS NOT NULL&#xa; AND d11 IS NOT NULL&#xa; AND d12 IS NOT NULL&#xa; AND d13 IS NOT NULL&#xa; 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>
 hidden batch(es)