Greetings, Didn’t get your ideas with materialized CTE or a subquery with OFFSET 0
Could you please show simple example? > 23 февр. 2021 г., в 04:33, Michael Lewis <mle...@entrata.com> написал(а): > > Insert the values into a TEMPORARY TABLE, then join that to your main table? > > In my experience, this is very performant but needs an analyze command after > populating the temp table to ensure there are statistics so the plan doesn't > go awry. Otherwise, I'm not sure it is different from a materialized CTE or a > subquery with OFFSET 0 at the end.
