Re: UNION ALL

2019-08-16 Thread Mark Pasterkamp
ight in its cost. With kind regards, Mark On Thu, 15 Aug 2019 at 21:22, Ibrar Ahmed wrote: > > > On Fri, Aug 16, 2019 at 12:16 AM <066ce...@free.fr> wrote: > >> Generally speaking, when executing UNION ; a DISTINCT is run afterward on >> the resultset. >> >&g

UNION ALL

2019-08-15 Thread Mark Pasterkamp
Dear all, I was wondering if someone could help me understands what a union all actually does. For my thesis I am using Apache Calcite to rewrite queries into using materialized views which I then give to a Postgres database. For some queries, this means that they will be rewritten in a UNION ALL