>The bit column has very low selectivity (only 2 cases for not nullable columns). So, having this as a parameter will not help. Also, if we always looking for success = 1 it may help to have filtered index with that criterion.

Ok, I'll verify for direct assignation to the boolean. As far as the conditions, they are variables as this is a generic method which handles a variety of select commands.