Hi all,
we have a index on segment_0 column but wanted to check if sql server will use that index efficiently because of the use of bitwise operator ? please see the query below .
SELECTCOUNT(MemberID)FROMdbo.MemberSegmentWHERESiteID = 23622320151 AND Segment_0 = Segment_0|CAST(2048 ASBIGINT)
OPTION (MAXDOP 8)
<u5:p> thanks</u5:p>
siddharth<u5:p></u5:p>