cockroachdb / cockroachdb/cockroach

Create a metric to track the number of queries with an index join over time

Open
#107,544 1 comment 0 reactions 0 assignees View on GitHub
C-enhancement T-sql-queries
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

It's difficult to quickly determine whether workload performance is tuned over time. Customer workloads can easily change and/or table schema can be altered which can cause regressions to creep and degrade performance as plans shift requiring an index join. Index joins can indicate a suboptimal indexing strategy. This issue tracks creating a high-level metric similar to our full table scan metric for index joins.

Jira issue: CRDB-30103

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.