Greetings,
i have tested both options ANY with string + parsing and simple array - and there are cases when execution time 100+ times worse than IN
On Tue, Feb 23, 2021 at 12:23 AM David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:
On Monday, February 22, 2021, Oleksandr Voytsekhovskyy <av@xxxxxxxxx> wrote:What is the right way to pass long INT values list to IN filterDon’t.Pass in a delimited string, then parse that string into an array and use “= any(array)”.This has the primary benefit of making the input a single parameter.David J.
