Re: Union strange explain

Поиск
Список
Период
Сортировка
От Gaetano Mendola
Тема Re: Union strange explain
Дата
Msg-id 005001c2240d$23d176e0$070afea9@GMENDOLA2
обсуждение исходный текст
Ответ на Re: Union strange explain  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Ответы Re: Union strange explain
Список pgsql-admin
Stephan  wrote:
> number of rows returned).  I think there was some question about
> whether it was safe to do that optimization (ie,
> is select * from (a union [all] b) where condition
> always the same as
>  select * from a where condition union [all]
>  select * from b where condition
> )

Yes but with a View the condition is always extern.
I'm understanding that I don't have any possibility to
optimize that view, I'm wrong ?


Ciao
Gaetano




В списке pgsql-admin по дате отправления:

Предыдущее
От: Heni Lolov
Дата:
Сообщение: Re: Permissions in PgSQL 7.2.1
Следующее
От: John Moore
Дата:
Сообщение: Re: Performance impact of record sizes