Add health status sorting indexes for issues table

What does this MR do and why?

This change creates new indexes to support health status sorting on issue lists, now using the work_item_types table to filter by issue_type

Indexes were already scheduled to be created over the weekend in .com with !123860 (merged) (more info and query plans in the MR)

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

• I have evaluated the MR acceptance checklist for this MR.

Related to #411673 (closed)