Update IndexEntity tables used in sorting to include index_name and index_value in their resourceUuid index #2758
Labels
effort:medium
Medium effort - 3 to 5 days
P2
Medium priority issue
type:enhancement
New feature or request
Is your feature request related to a problem? Please describe.
Update sort index tables as described here to add column
index_name
to theresourceUuid
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 hereDescribe the solution you'd like
Add
index_name
andindex_value
columns to theresourceUuid
index in the sorting index tablesDescribe 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
The text was updated successfully, but these errors were encountered: