cockroachdb / cockroachdb/cockroach
Schema insights redesign to help users prioritize critical recommendations
Open
A-check-on-console
A-sql-observability
C-enhancement
T-observability
ui-design-needed
- Dominant language
- Go
- Stars
- 32.5k
- Forks
- 4.1k
- PR merge metrics
- PR metrics pending
Description
We show all index recommendations on the Schema insights page. There can be duplicates or similar recommendations. We should redesign the schema insights page to scale two user flows that allow users to prioritize critical recommendations:
1. Missing Indexes
2. Unused indes
For each user flow, we should provide 'weight' or contextual information to help users decide and prioritize which recommendations to apply first.
Note: the design can also improve the performance (quality) of these pages depending on the information we return to users.
Jira issue: CRDB-25098
Epic: CRDB-32130
Contributor guide
Assessment
This issue has not been assessed yet.