The heuristic by which we assign a bonus to productive index scans when multiplanned together with distinct scans is too permissive. On a large collection, we see an idnex scan prioritized when we shouldn't. We should update the formula to strongly favor distinct scans except if the benefit of an index scan is overwhelming.