Re: Simple IN vs IN values performace

[Oleksandr Voytsekhovskyy <young.inbox@xxxxxxxxx>]

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 <mlewis@xxxxxxxxxxx> написал(а):

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.