On Sun, Nov 23, 2025 at 9:39 AM Tomas Vondra <[email protected]> wrote: > > 1. I do not think I believe the premise that the dimension tables > > typically won't have restriction clauses. ISTM that a typical > > query might be like > > > > select sum(o.total_price) from > > orders o > > join customers c on c.id = o.c_id > > join products p on p.id = o.p_id > > where c.customer_name = 'Wile E Coyote' > > and p.product_name = 'Rocket Skates'; > > > > Good question. I don't have a great evidence such joins to dimensions > (without additional restrictions) are a common case. It's partially a > guess and partially based on my past experience.
In my experience, restriction clauses on dimension tables are very common. -- Robert Haas EDB: http://www.enterprisedb.com
