SQL Server 2016

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE dbo.FlagTable
(
  id   int identity(1,1) primary key clustered,
  flag int,
  x    char(2000) NOT NULL DEFAULT '',
  INDEX ix_flag(flag)
);

INSERT dbo.FlagTable(flag) 
  SELECT TOP (25000) ABS(object_id) % 7 
  FROM sys.all_columns CROSS JOIN sys.databases;
25000 rows affected

SET SHOWPLAN_XML ON;
SELECT * FROM dbo.FlagTable WHERE flag & 4 = 4;

Microsoft SQL Server 2005 XML Showplan

<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.518" Build="13.0.6404.1"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT * FROM dbo.FlagTable WHERE flag &amp; 4 = 4" StatementId="1" StatementCompId="1" StatementType="SELECT" RetrievedFromCache="false" StatementSubTreeCost="4.65967" StatementEstRows="2500" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0xED0FBD5532BCCCD1" QueryPlanHash="0xB801067AE51546EC" CardinalityEstimationModelVersion="130" ParameterizedText="(@1 int,@2 tinyint)SELECT * FROM [dbo].[FlagTable] WHERE ([flag]&amp;@1)=@2"><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 NonParallelPlanReason="NoParallelPlansInDesktopOrExpressEdition" CachedPlanSize="16" CompileTime="0" CompileCPU="0" CompileMemory="168"><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="1258238" EstimatedPagesCached="78639" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="818400"></OptimizerHardwareDependentProperties><TraceFlags IsCompileTime="1"><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><RelOp NodeId="0" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2500" EstimatedRowsRead="25000" EstimateIO="4.63201" EstimateCPU="0.027657" AvgRowSize="2015" EstimatedTotalSubtreeCost="4.65967" TableCardinality="25000" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Column="id"></ColumnReference><ColumnReference Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Column="flag"></ColumnReference><ColumnReference Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Column="x"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Column="id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Column="flag"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Column="x"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Index="[PK__FlagTabl__3213E83FFFA0D4D8]" IndexKind="Clustered" Storage="RowStore"></Object><Predicate><ScalarOperator ScalarString="([fiddle_7fae79d79d4c4817b35c2bfc6094765a].[dbo].[FlagTable].[flag]&amp;(4))=(4)"><Compare CompareOp="EQ"><ScalarOperator><Arithmetic Operation="BIT_AND"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Column="flag"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(4)"></Const></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(4)"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></IndexScan></RelOp><ParameterList><ColumnReference Column="@2" ParameterDataType="tinyint" ParameterCompiledValue="(4)"></ColumnReference><ColumnReference Column="@1" ParameterDataType="int" ParameterCompiledValue="(4)"></ColumnReference></ParameterList></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>

SELECT * FROM dbo.FlagTable WHERE flag >= 4 AND flag & 4 = 4;

Microsoft SQL Server 2005 XML Showplan

<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.518" Build="13.0.6404.1"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT * FROM dbo.FlagTable WHERE flag &gt;= 4 AND flag &amp; 4 = 4" StatementId="1" StatementCompId="1" StatementType="SELECT" RetrievedFromCache="false" StatementSubTreeCost="4.65967" StatementEstRows="1674.91" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0xBE8D944429EC85F6" QueryPlanHash="0xB801067AE51546EC" CardinalityEstimationModelVersion="130" ParameterizedText="(@1 tinyint,@2 int,@3 tinyint)SELECT * FROM [dbo].[FlagTable] WHERE [flag]&gt;=@1 AND ([flag]&amp;@2)=@3"><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 NonParallelPlanReason="NoParallelPlansInDesktopOrExpressEdition" CachedPlanSize="24" CompileTime="0" CompileCPU="0" CompileMemory="216"><MissingIndexes><MissingIndexGroup Impact="61.0524"><MissingIndex Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]"><ColumnGroup Usage="INEQUALITY"><Column Name="[flag]" ColumnId="2"></Column></ColumnGroup><ColumnGroup Usage="INCLUDE"><Column Name="[id]" ColumnId="1"></Column><Column Name="[x]" ColumnId="3"></Column></ColumnGroup></MissingIndex></MissingIndexGroup></MissingIndexes><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="1258238" EstimatedPagesCached="78639" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="818400"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2023-10-25T17:34:34.42" ModificationCount="0" SamplingPercent="32.064" Statistics="[ix_flag]" Table="[FlagTable]" Schema="[dbo]" Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]"></StatisticsInfo></OptimizerStatsUsage><TraceFlags IsCompileTime="1"><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><RelOp NodeId="0" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1674.91" EstimatedRowsRead="25000" EstimateIO="4.63201" EstimateCPU="0.027657" AvgRowSize="2015" EstimatedTotalSubtreeCost="4.65967" TableCardinality="25000" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Column="id"></ColumnReference><ColumnReference Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Column="flag"></ColumnReference><ColumnReference Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Column="x"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Column="id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Column="flag"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Column="x"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Index="[PK__FlagTabl__3213E83FFFA0D4D8]" IndexKind="Clustered" Storage="RowStore"></Object><Predicate><ScalarOperator ScalarString="[fiddle_7fae79d79d4c4817b35c2bfc6094765a].[dbo].[FlagTable].[flag]&gt;=(4) AND ([fiddle_7fae79d79d4c4817b35c2bfc6094765a].[dbo].[FlagTable].[flag]&amp;(4))=(4)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Column="flag"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(4)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Arithmetic Operation="BIT_AND"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Column="flag"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(4)"></Const></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(4)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><ParameterList><ColumnReference Column="@3" ParameterDataType="tinyint" ParameterCompiledValue="(4)"></ColumnReference><ColumnReference Column="@2" ParameterDataType="int" ParameterCompiledValue="(4)"></ColumnReference><ColumnReference Column="@1" ParameterDataType="tinyint" ParameterCompiledValue="(4)"></ColumnReference></ParameterList></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>

SELECT id, flag FROM dbo.FlagTable WHERE flag & 4 = 4;

Microsoft SQL Server 2005 XML Showplan

<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.518" Build="13.0.6404.1"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT id, flag FROM dbo.FlagTable WHERE flag &amp; 4 = 4" StatementId="1" StatementCompId="1" StatementType="SELECT" RetrievedFromCache="false" StatementSubTreeCost="0.0626339" StatementEstRows="2500" SecurityPolicyApplied="false" StatementOptmLevel="TRIVIAL" QueryHash="0xC10991144062F983" QueryPlanHash="0x7A55F400E30A1B13" CardinalityEstimationModelVersion="130" ParameterizedText="(@1 int,@2 tinyint)SELECT [id],[flag] FROM [dbo].[FlagTable] WHERE ([flag]&amp;@1)=@2"><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 NonParallelPlanReason="NoParallelPlansInDesktopOrExpressEdition" CachedPlanSize="16" CompileTime="0" CompileCPU="0" CompileMemory="112"><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="1258238" EstimatedPagesCached="78639" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="818400"></OptimizerHardwareDependentProperties><TraceFlags IsCompileTime="1"><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><RelOp NodeId="0" PhysicalOp="Index Scan" LogicalOp="Index Scan" EstimateRows="2500" EstimatedRowsRead="25000" EstimateIO="0.0349769" EstimateCPU="0.027657" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0626339" TableCardinality="25000" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Column="id"></ColumnReference><ColumnReference Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Column="flag"></ColumnReference></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Column="id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Column="flag"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Index="[ix_flag]" IndexKind="NonClustered" Storage="RowStore"></Object><Predicate><ScalarOperator ScalarString="([fiddle_7fae79d79d4c4817b35c2bfc6094765a].[dbo].[FlagTable].[flag]&amp;[@1])=CONVERT_IMPLICIT(int,[@2],0)"><Compare CompareOp="EQ"><ScalarOperator><Arithmetic Operation="BIT_AND"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Column="flag"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="@1"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="ConstExpr1002"><ScalarOperator><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="@2"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Predicate></IndexScan></RelOp><ParameterList><ColumnReference Column="@2" ParameterDataType="tinyint" ParameterCompiledValue="(4)"></ColumnReference><ColumnReference Column="@1" ParameterDataType="int" ParameterCompiledValue="(4)"></ColumnReference></ParameterList></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>

SELECT id, flag FROM dbo.FlagTable WHERE flag >= 4 AND flag & 4 = 4;

Microsoft SQL Server 2005 XML Showplan

<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.518" Build="13.0.6404.1"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT id, flag FROM dbo.FlagTable WHERE flag &gt;= 4 AND flag &amp; 4 = 4" StatementId="1" StatementCompId="1" StatementType="SELECT" RetrievedFromCache="false" StatementSubTreeCost="0.0296995" StatementEstRows="1674.91" SecurityPolicyApplied="false" StatementOptmLevel="TRIVIAL" QueryHash="0x927E5C896F779EE2" QueryPlanHash="0x647D0523591E0A9C" CardinalityEstimationModelVersion="130" ParameterizedText="(@1 tinyint,@2 int,@3 tinyint)SELECT [id],[flag] FROM [dbo].[FlagTable] WHERE [flag]&gt;=@1 AND ([flag]&amp;@2)=@3"><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 NonParallelPlanReason="NoParallelPlansInDesktopOrExpressEdition" CachedPlanSize="24" CompileTime="0" CompileCPU="0" CompileMemory="144"><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="1258238" EstimatedPagesCached="78639" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="818400"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2023-10-25T17:34:34.42" ModificationCount="0" SamplingPercent="32.064" Statistics="[ix_flag]" Table="[FlagTable]" Schema="[dbo]" Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]"></StatisticsInfo></OptimizerStatsUsage><TraceFlags IsCompileTime="1"><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><RelOp NodeId="0" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="1674.91" EstimatedRowsRead="11221.3" EstimateIO="0.0171991" EstimateCPU="0.0125004" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0296995" TableCardinality="25000" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Column="id"></ColumnReference><ColumnReference Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Column="flag"></ColumnReference></OutputList><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Column="id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Column="flag"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Index="[ix_flag]" IndexKind="NonClustered" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><StartRange ScanType="GE"><RangeColumns><ColumnReference Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Column="flag"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[@1],0)"><Identifier><ColumnReference Column="ConstExpr1002"><ScalarOperator><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="@1"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></ColumnReference></Identifier></ScalarOperator></RangeExpressions></StartRange></SeekKeys></SeekPredicateNew></SeekPredicates><Predicate><ScalarOperator ScalarString="([fiddle_7fae79d79d4c4817b35c2bfc6094765a].[dbo].[FlagTable].[flag]&amp;[@2])=CONVERT_IMPLICIT(int,[@3],0)"><Compare CompareOp="EQ"><ScalarOperator><Arithmetic Operation="BIT_AND"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Column="flag"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="@2"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="ConstExpr1003"><ScalarOperator><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="@3"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Predicate></IndexScan></RelOp><ParameterList><ColumnReference Column="@3" ParameterDataType="tinyint" ParameterCompiledValue="(4)"></ColumnReference><ColumnReference Column="@2" ParameterDataType="int" ParameterCompiledValue="(4)"></ColumnReference><ColumnReference Column="@1" ParameterDataType="tinyint" ParameterCompiledValue="(4)"></ColumnReference></ParameterList></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>

UPDATE dbo.FlagTable SET flag = flag &~ 4 WHERE flag & 4 = 4;

Microsoft SQL Server 2005 XML Showplan

<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.518" Build="13.0.6404.1"><BatchSequence><Batch><Statements><StmtSimple StatementText="UPDATE dbo.FlagTable SET flag = flag &amp;~ 4 WHERE flag &amp; 4 = 4" StatementId="1" StatementCompId="1" StatementType="UPDATE" RetrievedFromCache="false" StatementSubTreeCost="4.39971" StatementEstRows="2500" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x9A82048D976C7EDC" QueryPlanHash="0x5E041293D19FB347" CardinalityEstimationModelVersion="130" ParameterizedText="(@1 int,@2 int,@3 tinyint)UPDATE [dbo].[FlagTable] set [flag] = [flag]&amp;~@1  WHERE ([flag]&amp;@2)=@3"><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 NonParallelPlanReason="NoParallelPlansInDesktopOrExpressEdition" CachedPlanSize="40" CompileTime="0" CompileCPU="0" CompileMemory="304"><MemoryGrantInfo SerialRequiredMemory="512" SerialDesiredMemory="800"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="1258238" EstimatedPagesCached="78639" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="818400"></OptimizerHardwareDependentProperties><TraceFlags IsCompileTime="1"><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><RelOp NodeId="1" PhysicalOp="Clustered Index Update" LogicalOp="Update" EstimateRows="2500" EstimateIO="4.25919" EstimateCPU="0.005" AvgRowSize="9" EstimatedTotalSubtreeCost="4.39971" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList></OutputList><Update WithOrderedPrefetch="1" DMLRequestSort="1"><Object Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Index="[PK__FlagTabl__3213E83FFFA0D4D8]" IndexKind="Clustered" Storage="RowStore"></Object><Object Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Index="[ix_flag]" IndexKind="NonClustered" Storage="RowStore"></Object><SetPredicate><ScalarOperator ScalarString="[fiddle_7fae79d79d4c4817b35c2bfc6094765a].[dbo].[FlagTable].[flag] = [Expr1002]"><ScalarExpressionList><ScalarOperator><MultipleAssign><Assign><ColumnReference Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Column="flag"></ColumnReference><ScalarOperator><Identifier><ColumnReference Column="Expr1002"></ColumnReference></Identifier></ScalarOperator></Assign></MultipleAssign></ScalarOperator></ScalarExpressionList></ScalarOperator></SetPredicate><RelOp NodeId="2" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="2500" EstimateIO="0" EstimateCPU="0.00025" AvgRowSize="19" EstimatedTotalSubtreeCost="0.135517" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Column="id"></ColumnReference><ColumnReference Column="Expr1002"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference><ColumnReference Column="Expr1010"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1009"></ColumnReference><ScalarOperator ScalarString="[Expr1009]"><Identifier><ColumnReference Column="Expr1009"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="4" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="2500" EstimateIO="0" EstimateCPU="0.00025" AvgRowSize="19" EstimatedTotalSubtreeCost="0.135517" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Column="id"></ColumnReference><ColumnReference Column="Expr1002"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1009"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1005] THEN (0) ELSE (1) END"><IF><Condition><ScalarOperator><Identifier><ColumnReference Column="Expr1005"></ColumnReference></Identifier></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="5" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="2500" EstimateIO="0" EstimateCPU="0.00025" AvgRowSize="16" EstimatedTotalSubtreeCost="0.135267" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Column="id"></ColumnReference><ColumnReference Column="Expr1002"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1002"></ColumnReference><ScalarOperator ScalarString="[fiddle_7fae79d79d4c4817b35c2bfc6094765a].[dbo].[FlagTable].[flag]&amp;~[@1]"><Arithmetic Operation="BIT_AND"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Column="flag"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="ConstExpr1007"><ScalarOperator><Arithmetic Operation="BIT_NOT"><ScalarOperator><Identifier><ColumnReference Column="@1"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1005"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [fiddle_7fae79d79d4c4817b35c2bfc6094765a].[dbo].[FlagTable].[flag] = ([fiddle_7fae79d79d4c4817b35c2bfc6094765a].[dbo].[FlagTable].[flag]&amp;~[@1]) THEN (1) ELSE (0) END"><IF><Condition><ScalarOperator><Compare CompareOp="BINARY IS"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Column="flag"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Arithmetic Operation="BIT_AND"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Column="flag"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="ConstExpr1007"><ScalarOperator><Arithmetic Operation="BIT_NOT"><ScalarOperator><Identifier><ColumnReference Column="@1"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="6" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="2500" EstimateIO="0.0112613" EstimateCPU="0.0441221" AvgRowSize="15" EstimatedTotalSubtreeCost="0.135017" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Column="id"></ColumnReference><ColumnReference Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Column="flag"></ColumnReference></OutputList><MemoryFractions Input="1" Output="1"></MemoryFractions><Sort Distinct="0"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Column="id"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="7" PhysicalOp="Index Scan" LogicalOp="Index Scan" EstimateRows="2500" EstimatedRowsRead="25000" EstimateIO="0.0349769" EstimateCPU="0.027657" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0626339" TableCardinality="25000" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Column="id"></ColumnReference><ColumnReference Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Column="flag"></ColumnReference></OutputList><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Column="id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Column="flag"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Index="[ix_flag]" IndexKind="NonClustered" Storage="RowStore"></Object><Predicate><ScalarOperator ScalarString="([fiddle_7fae79d79d4c4817b35c2bfc6094765a].[dbo].[FlagTable].[flag]&amp;(4))=(4)"><Compare CompareOp="EQ"><ScalarOperator><Arithmetic Operation="BIT_AND"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Column="flag"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(4)"></Const></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(4)"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></IndexScan></RelOp></Sort></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp></Update></RelOp><ParameterList><ColumnReference Column="@1" ParameterDataType="int" ParameterCompiledValue="(4)"></ColumnReference><ColumnReference Column="@3" ParameterDataType="tinyint" ParameterCompiledValue="(4)"></ColumnReference><ColumnReference Column="@2" ParameterDataType="int" ParameterCompiledValue="(4)"></ColumnReference></ParameterList></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>

UPDATE dbo.FlagTable SET flag = flag &~ 4 WHERE flag >= 4 AND flag & 4 = 4;

Microsoft SQL Server 2005 XML Showplan

<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.518" Build="13.0.6404.1"><BatchSequence><Batch><Statements><StmtSimple StatementText="UPDATE dbo.FlagTable SET flag = flag &amp;~ 4 WHERE flag &gt;= 4 AND flag &amp; 4 = 4" StatementId="1" StatementCompId="1" StatementType="UPDATE" RetrievedFromCache="false" StatementSubTreeCost="2.93601" StatementEstRows="1674.91" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x717AE70CDCAF7CE9" QueryPlanHash="0xA2F6AC0A611F2AAC" CardinalityEstimationModelVersion="130" ParameterizedText="(@1 int,@2 tinyint,@3 int,@4 tinyint)UPDATE [dbo].[FlagTable] set [flag] = [flag]&amp;~@1  WHERE [flag]&gt;=@2 AND ([flag]&amp;@3)=@4"><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 NonParallelPlanReason="NoParallelPlansInDesktopOrExpressEdition" CachedPlanSize="40" CompileTime="0" CompileCPU="0" CompileMemory="368"><MemoryGrantInfo SerialRequiredMemory="512" SerialDesiredMemory="720"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="1258238" EstimatedPagesCached="78639" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="818400"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2023-10-25T17:34:34.42" ModificationCount="0" SamplingPercent="32.064" Statistics="[ix_flag]" Table="[FlagTable]" Schema="[dbo]" Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]"></StatisticsInfo></OptimizerStatsUsage><TraceFlags IsCompileTime="1"><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><RelOp NodeId="1" PhysicalOp="Clustered Index Update" LogicalOp="Update" EstimateRows="1674.91" EstimateIO="2.85565" EstimateCPU="0.00334982" AvgRowSize="9" EstimatedTotalSubtreeCost="2.93601" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList></OutputList><Update WithOrderedPrefetch="1" DMLRequestSort="1"><Object Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Index="[PK__FlagTabl__3213E83FFFA0D4D8]" IndexKind="Clustered" Storage="RowStore"></Object><Object Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Index="[ix_flag]" IndexKind="NonClustered" Storage="RowStore"></Object><SetPredicate><ScalarOperator ScalarString="[fiddle_7fae79d79d4c4817b35c2bfc6094765a].[dbo].[FlagTable].[flag] = [Expr1002]"><ScalarExpressionList><ScalarOperator><MultipleAssign><Assign><ColumnReference Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Column="flag"></ColumnReference><ScalarOperator><Identifier><ColumnReference Column="Expr1002"></ColumnReference></Identifier></ScalarOperator></Assign></MultipleAssign></ScalarOperator></ScalarExpressionList></ScalarOperator></SetPredicate><RelOp NodeId="2" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1674.91" EstimateIO="0" EstimateCPU="0.000167491" AvgRowSize="19" EstimatedTotalSubtreeCost="0.0770097" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Column="id"></ColumnReference><ColumnReference Column="Expr1002"></ColumnReference><ColumnReference Column="Expr1010"></ColumnReference><ColumnReference Column="Expr1011"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1010"></ColumnReference><ScalarOperator ScalarString="[Expr1010]"><Identifier><ColumnReference Column="Expr1010"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="4" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1674.91" EstimateIO="0" EstimateCPU="0.000167491" AvgRowSize="19" EstimatedTotalSubtreeCost="0.0770097" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Column="id"></ColumnReference><ColumnReference Column="Expr1002"></ColumnReference><ColumnReference Column="Expr1010"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1010"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1005] THEN (0) ELSE (1) END"><IF><Condition><ScalarOperator><Identifier><ColumnReference Column="Expr1005"></ColumnReference></Identifier></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="5" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1674.91" EstimateIO="0" EstimateCPU="0.000167491" AvgRowSize="16" EstimatedTotalSubtreeCost="0.0768422" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Column="id"></ColumnReference><ColumnReference Column="Expr1002"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1002"></ColumnReference><ScalarOperator ScalarString="[fiddle_7fae79d79d4c4817b35c2bfc6094765a].[dbo].[FlagTable].[flag]&amp;~[@1]"><Arithmetic Operation="BIT_AND"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Column="flag"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="ConstExpr1008"><ScalarOperator><Arithmetic Operation="BIT_NOT"><ScalarOperator><Identifier><ColumnReference Column="@1"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1005"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [fiddle_7fae79d79d4c4817b35c2bfc6094765a].[dbo].[FlagTable].[flag] = ([fiddle_7fae79d79d4c4817b35c2bfc6094765a].[dbo].[FlagTable].[flag]&amp;~[@1]) THEN (1) ELSE (0) END"><IF><Condition><ScalarOperator><Compare CompareOp="BINARY IS"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Column="flag"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Arithmetic Operation="BIT_AND"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Column="flag"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="ConstExpr1008"><ScalarOperator><Arithmetic Operation="BIT_NOT"><ScalarOperator><Identifier><ColumnReference Column="@1"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="6" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="1674.91" EstimateIO="0.0112613" EstimateCPU="0.0280834" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0766747" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Column="id"></ColumnReference><ColumnReference Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Column="flag"></ColumnReference></OutputList><MemoryFractions Input="1" Output="1"></MemoryFractions><Sort Distinct="0"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Column="id"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="7" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="1674.91" EstimatedRowsRead="11221.3" EstimateIO="0.0171991" EstimateCPU="0.0125004" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0296995" TableCardinality="25000" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Column="id"></ColumnReference><ColumnReference Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Column="flag"></ColumnReference></OutputList><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Column="id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Column="flag"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Index="[ix_flag]" IndexKind="NonClustered" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><StartRange ScanType="GE"><RangeColumns><ColumnReference Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Column="flag"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="(4)"><Const ConstValue="(4)"></Const></ScalarOperator></RangeExpressions></StartRange></SeekKeys></SeekPredicateNew></SeekPredicates><Predicate><ScalarOperator ScalarString="([fiddle_7fae79d79d4c4817b35c2bfc6094765a].[dbo].[FlagTable].[flag]&amp;(4))=(4)"><Compare CompareOp="EQ"><ScalarOperator><Arithmetic Operation="BIT_AND"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_7fae79d79d4c4817b35c2bfc6094765a]" Schema="[dbo]" Table="[FlagTable]" Column="flag"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(4)"></Const></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(4)"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></IndexScan></RelOp></Sort></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp></Update></RelOp><ParameterList><ColumnReference Column="@1" ParameterDataType="int" ParameterCompiledValue="(4)"></ColumnReference><ColumnReference Column="@4" ParameterDataType="tinyint" ParameterCompiledValue="(4)"></ColumnReference><ColumnReference Column="@3" ParameterDataType="int" ParameterCompiledValue="(4)"></ColumnReference><ColumnReference Column="@2" ParameterDataType="tinyint" ParameterCompiledValue="(4)"></ColumnReference></ParameterList></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>