Subject Re: [firebird-support] NO Optimizated VIEW with UNION inside
Author Dmitry Yemanov
"skander_sp" <skander_sp@...> wrote:
> But I need to use a VIEW with a UNION ALL inside, and cheching I see
> that NO OPTIMIZATION was improved here, and the SELECT with WHERE on
> this VIEW was MUCH MUCH MUCH slow (just like the WHERE "filter" was
> aplied LATTER to the UNION.

You're right. And this has been improved in FB 2.0.