Is your feature request related to a problem? Please describe.
Update sort index tables as described here to add column index_name to the resourceUuid column index since it's used as part of join to the sorting tables here, to improve performance on queries that involve sorts.
index_value column could also be added to the index to make it a covering index when used here

Describe the solution you'd like
Add index_name and index_value columns to the resourceUuid index in the sorting index tables

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context
Add any other context or screenshots about the feature request here.

Would you like to work on the issue?
Yes