This is probably a really stupid question, but is there going to be much benefit in indexing a boolean field in a database table?
Given a common situation, like "soft-delete" records which are flagged as inactive, and hence most queries include WHERE deleted = 0
, would it help to have that field indexed on its own, or should it be combined with the other commonly-searched fields in a different index?