| Subject | Re: [firebird-support] Re: select with subselects in columns or in joins? (also MERGE n SORT in plans) |
|---|---|
| Author | Alexandre Benson Smith |
| Post date | 2009-09-26T21:50:51Z |
Svein Erling wrote:
COALESCE, IIF and CASE would make "double scans"
see you !
--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br
> Hi!IIRC that's because of COALESCE
>
> I've no idea why things are duplicated in your first plan,
COALESCE, IIF and CASE would make "double scans"
see you !
--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br