On Mon, Jul 6, 2020 at 5:37 AM Robins Tharakan <tharakan(at)gmail(dot)com> wrote:
> This need came up while reviewing generated SQL, where the need was to
> return true when
> at least one of two lists had a row.
>
Generated SQL... yep. That will happen. Manual SQL may be more work, but
often has significant reward.
If you can change how the SQL is generated, I would expect that EXISTS
would likely be more performant in your case, even if you need to do UNION
ALL between the two current queries that potentially return true.