We currently have indexes scattered across various parts of our database. It would be beneficial to review and clean up these indexes to determine their necessity. Specifically, we need to identify which fields should be indexed and which existing indexes can be removed or optimized.
e.g. https://github.com/clowder-framework/clowder2/blob/main/backend/app/models/datasets.py#L55
We currently have indexes scattered across various parts of our database. It would be beneficial to review and clean up these indexes to determine their necessity. Specifically, we need to identify which fields should be indexed and which existing indexes can be removed or optimized.
e.g. https://github.com/clowder-framework/clowder2/blob/main/backend/app/models/datasets.py#L55