RE: [SQL] Joining bug????

Поиск
Список
Период
Сортировка
От Jackson, DeJuan
Тема RE: [SQL] Joining bug????
Дата
Msg-id F10BB1FAF801D111829B0060971D839F4AD59E@cpsmail
обсуждение исходный текст
Ответы Re: [SQL] Joining bug????  (jwieck@debis.com (Jan Wieck))
Список pgsql-sql
> > try making a view.  from what others have said, views save the query
> plan
> > and have usually, at least for me, been _alot_ faster than normal
> queries.
>
>     Views don't save query plans. They are parsetree templates in
>     query rewrite rules.
>
So, could you explain what counts for the speed increase.  Is the parse
stage really that costly?
    -DEJ

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [SQL] Operator <> for lseg,lseg bug
Следующее
От: Daniel Facciolo Pires
Дата:
Сообщение: automatic increment field type