Subject Re: select with subselects in columns or in joins? (also MERGE n SORT in plans)
Author emb_blaster
>
> IIRC that's because of COALESCE
>
> COALESCE, IIF and CASE would make "double scans"
>
> see you !
> --
> Alexandre Benson Smith

Hi!
you remember where can I read more about this? I tried, but didn't find it using messages search :´¬(

TIA, SY