cockroachdb / cockroachdb/cockroach
sql: investigate caching the right-side plan for an apply join
Open
C-investigation
T-sql-queries
- Dominant language
- Go
- Stars
- 32.5k
- Forks
- 4.1k
- PR merge metrics
- PR metrics pending
Description
Apply joins are notoriously inefficient. One of the sources of inefficiency is the need to completely re-optimize the right side of the join for each row. We should investigate whether caching and re-using the plan (i.e., avoiding running exploration each time) would help improve the efficiency.
Jira issue: CRDB-22545
Contributor guide
Assessment
This issue has not been assessed yet.