On Mon, Jul 6, 2020 at 5:37 AM Robins Tharakan <tharakan@gmail.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.
Чтобы сделать работу с сайтом удобнее, мы используем cookie и аналитический сервис «Яндекс.Метрика». Продолжая пользоваться сайтом, вы соглашаетесь с их использованием.