Reduce the number of vulnerability management indexes on the main gitlab.com database

Supporting Reduce the number of tuples updated for tables ... (&13616 - closed), this issue tracks identification and removal of indices on

From https://gitlab.com/gitlab-com/gitlab-OKRs/-/work_items/7863#note_1929192435, these are the indices that have been identified:

Other indices have been identified as being possibly redundant in #456959 (comment 1945703212), we may consider double checking for further redundancy reported in there.

Index	Issue	Status
index_vuln_findings_on_uuid_including_vuln_id_1	Evaluate and Remove index `index_vuln_findings_... (#471148 - closed) • Brian Williams • 18.0
index_vulnerability_occurrences_on_uuid_1	Evaluate and Remove index `index_vulnerability_... (#471147 - closed) • Brian Williams • 18.0
tmp_index_vulnerability_occurrences_id_and_latest_pipeline_id	Evaluate and Remove index `tmp_index_vulnerabil... (#471149 - closed) • Michael Becker • Backlog	#471527 (closed)
security_findings_confidence_idx	Evaluate and Remove index `security_findings_co... (#471150 - closed) • Unassigned • 17.2	✅
index_vulnerability_occurrences_on_project_fingerprint	Evaluate and Remove index `index_vulnerability_... (#471151 - closed) • Unassigned • 17.2	✅
index_sbom_occurrences_on_component_version_id	Evaluate and Remove index `index_sbom_occurrenc... (#471152 - closed) • Brian Williams • 17.4
index_vulnerability_occurrences_for_issue_links_migration	Remove `index_vulnerability_occurrences_for_iss... (#471153 - closed) • Michael Becker • 17.2 • On track
index_vulnerability_occurrences_deduplication	Attempt to remove `index_vulnerability_occurre... (#471154 - closed) • Fabien Catteau • 17.4
index_vulnerability_reads_on_namespace_type_severity_id	Remove indices with namespace_id on vulnerabili... (#470937 - closed) • Brian Williams • 17.4
index_vulnerability_reads_common_finder_query_w_namespace_id	Remove indices with namespace_id on vulnerabili... (#470937 - closed) • Brian Williams • 17.4
index_vuln_reads_on_namespace_id_state_severity_and_vuln_id	Remove indices with namespace_id on vulnerabili... (#470937 - closed) • Brian Williams • 17.4