Subject Re: [firebird-support] Re: select with subselects in columns or in joins? (also MERGE n SORT in plans)
Author Alexandre Benson Smith
Svein Erling wrote:
> Hi!
> I've no idea why things are duplicated in your first plan,

IIRC that's because of COALESCE

COALESCE, IIF and CASE would make "double scans"

see you !

Alexandre Benson Smith
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil