Skip to content

opt: plan lookup anti-, semi-, and left joins on indexes with virtual columns #75873

Closed
#76697
Closed
opt: plan lookup anti-, semi-, and left joins on indexes with virtual columns#75873
#76697
Assignees
mgartner
Labels
C-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)T-sql-queriesSQL Queries Team
@mgartner

Description

@mgartner
mgartner
opened on Feb 2, 2022

We don't currently plan lookup anti-, semi-, and left joins on indexes with virtual columns:

cockroach/pkg/sql/opt/xform/rules/join.opt

Lines 215 to 216 in 5fd739b

# TODO(mgartner): Generate lookup joins with virtual columns for semi- and
# anti-joins. This may also be possible for left joins, but could be tricky.

Planning anti- and semi-joins will depend on #75872, because decorrelation rules end up making projections of virtual column expressions with column IDs that do not match virtual column IDs in table metadata.

Metadata

Metadata

Assignees

Labels

C-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)T-sql-queriesSQL Queries Team

Type

No type

Projects

SQL Queries

Status

Done

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions