SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
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

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>


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>