cockroachdb / cockroachdb/cockroach
sql: a way to show all statement hints or all pinned plans
Open
A-plan-management
A-statement-hint
C-enhancement
O-support
P-3
T-sql-queries
- Dominant language
- Go
- Stars
- 32.5k
- Forks
- 4.1k
- PR merge metrics
- PR metrics pending
Description
`SHOW STATEMENT HINTS` currently takes a statement fingerprint and shows the external statement hints for that fingerprint. We might want to extend this to show all statement hints.
Jira issue: CRDB-66265
Epic: CRDB-66266
Contributor guide
Research direction
Begin at the existing SHOW STATEMENT HINTS SQL entry point and trace how a statement fingerprint selects external statement hints. Clarify whether the feature should list all statement hints, all pinned plans, or both, then define the expected output and verify it with SQL-level tests.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- go, sql
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Quiet
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100