Index Not Utilized for IN Operator with Literals - Performance Regression Fixes

Index not used for IN operator with literals, performance regression introduced around v19.3. This fixes #10574. #12062 (nvartolomei).