Add IssueLink migration index
Part of changes outlined in #224457 (closed)
Description
Create an index on (project_id, report_type, encode(project_fingerprint, 'hex'::text))
trigram. This will allow us to migrate Vulnerabilities::Finding
objects which have associated Vulnerabilities::Feedback
entries with no Vulnerabilities::IssueLinks
.
Implementation plan
-
database Create a migration with CREATE INDEX CONCURRENTLY issue_links_migration_idx ON vulnerability_occurrences (project_id, report_type, encode(project_fingerprint, 'hex'::text));