Async remove the tmp index for p_ci_builds.trigger_request_id

Tianwen Chenrequested to merge
502767-rm-tmp-index into master

What does this MR do and why?

Since the BackfillPCiPipelinesTriggerId has been finalized at 20250416232410, it's ok to remove the tmp index of p_ci_builds.trigger_request_id used by BackfillPCiPipelinesTriggerId.

References

Screenshots or screen recordings

Before After

How to set up and validate locally

MR acceptance checklist

Evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

Related to #502767 (closed)

Edited by Tianwen Chen

Merge request reports