Adding index for component search on Occurrences table
What does this MR do and why?
Implementation of index for: #442407 (comment 2113140223)
Our last attempt at building component search for SBOM occurrences encountered issues that has forced us to pivot approach. This index will replace the GIN index added in the last milestone.
MR acceptance checklist
Please evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.