-
Notifications
You must be signed in to change notification settings - Fork 8.3k
Pushdown JOIN USING/ON subquery into IN section for indexed columns #8062
Copy link
Copy link
Closed
Labels
comp-joinsJOINs end-to-end (planning hooks + runtime join operators/algorithms). Single bucket to avoid pla...JOINs end-to-end (planning hooks + runtime join operators/algorithms). Single bucket to avoid pla...comp-query-optimizerQuery plan optimization: physical plan steps, plan-level rewrites and optimizations (QueryPlan pa...Query plan optimization: physical plan steps, plan-level rewrites and optimizations (QueryPlan pa...featureperformance
Description
A.id - presented in table index
size of table A is bigger then size of table B
Slow query:
SELECT id, name FROM A
JOIN (SELECT id, name FROM B) USING idFast query:
SELECT id, name FROM A
JOIN (SELECT id, name FROM B) USING id
WHERE id IN (SELECT id FROM B)It's possible to pushdown join subquery into table A filter.
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
comp-joinsJOINs end-to-end (planning hooks + runtime join operators/algorithms). Single bucket to avoid pla...JOINs end-to-end (planning hooks + runtime join operators/algorithms). Single bucket to avoid pla...comp-query-optimizerQuery plan optimization: physical plan steps, plan-level rewrites and optimizations (QueryPlan pa...Query plan optimization: physical plan steps, plan-level rewrites and optimizations (QueryPlan pa...featureperformance