Duplicate Indexes
These indexes exist, but aren’t needed. Remove them for faster writes.
rails generate migration remove_unneeded_indexes
And paste
remove_index :execution_annotation_tags, name: "IDX_c1519757391996eb06064f0e7c", column: :annotationId remove_index :project_relation, name: "IDX_61448d56d61802b5dfde5cdb00", column: :projectId remove_index :workflows_tags, name: "idx_workflows_tags_workflow_id", column: :workflowId
| Details |
|---|
On execution_annotation_tags
IDX_c1519757391996eb06064f0e7c (annotationId)is covered by PK_979ec03d31294cca484be65d11f (annotationId, tagId) |
On project_relation
IDX_61448d56d61802b5dfde5cdb00 (projectId)is covered by PK_1caaa312a5d7184a003be0f0cb6 (projectId, userId) |
On workflows_tags
idx_workflows_tags_workflow_id (workflowId)is covered by pk_workflows_tags (workflowId, tagId) |