My table has an non-clustered index: IX_columnA_columnB
CREATE INDEX IX_columnA_columnB ON table (columnA, columnB)
INCLUDE (xxx)
My query has filter on both columnA and columnB
On execution plan, the optimizer use seek predicate on both them, but I see columnB appears again in predicate
I don't know this case. Anybody can help? Thanks so much