Add async index on merge_request_diff_commits_b5377a7a34

What does this MR do and why?

We originally added this index in !156090 (merged), however it was discovered that we actually needed to use prepare_partitioned_async_index instead of prepare_async_index, so that original indexing was removed (!167102 (merged))

Related to #464108 (closed)