An index on a column with two values

• A

  Yes, because any column used in a WHERE clause should be indexed

• B

  No, because a boolean column cannot be indexed usefully in any case at all

• C

  Only for finding the rare value; for the common one a scan is cheaper

• D

  Yes, because the index makes counting active rows instant