| Subject | Re: [firebird-support] NO Optimizated VIEW with UNION inside |
|---|---|
| Author | Dmitry Yemanov |
| Post date | 2006-07-31T13:58:22Z |
"skander_sp" <skander_sp@...> wrote:
Dmitry
>You're right. And this has been improved in FB 2.0.
> 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.
Dmitry