Snowflake, Sql, Data Science, Data Engineering, Optimization.
orders_10 add primary key (o_orderkey) ; alter table lineitem_10 add constraint lineitem_fkey_orders foreign key (l_orderkey) references orders_10 (o_orderkey) ; And that could be enough, but it turns out it’s not. Run the query again, and you’ll find the same execution graph: The execution graph