Re: are views typically any faster/slower than equivilent joins?

Поиск
Список
Период
Сортировка
Искать
От
Rod Taylor
Тема
Re: are views typically any faster/slower than equivilent joins?
Дата
Msg-id
1054440355.11968.90.camel@jester
Ответ на
Список
Дерево обсуждения
Enabling and Disabling Sequencial Scan Yusuf <yusuf0478@netscape.net>
Re: Enabling and Disabling Sequencial Scan "scott.marlowe" <scott.marlowe@ihs.com>
Re: Enabling and Disabling Sequencial Scan Robert Creager <Robert_Creager@LogicalChaos.org>
Re: Enabling and Disabling Sequencial Scan "scott.marlowe" <scott.marlowe@ihs.com>
Re: Enabling and Disabling Sequencial Scan "scott.marlowe" <scott.marlowe@ihs.com>
> Would my query performance be significantly faster/slower using a View as
> opposed to a prepared query using join?

I missed this part.  Views and prepared queries are not the same time. 
Use of a view still needs to be optimized.

Prepared queries will run the optimization portion on the entire query
including the view segments of it.  Think of a view as a MACRO. 
Depending on the context of what surrounds it, the view may be executed
very differently.

-- 
Rod Taylor 

PGP Key: http://www.rbt.ca/rbtpub.asc
В списке pgsql-performance по дате отправления
От: Brian Tarbox
Дата:
От: Rod Taylor
Дата:
FAQ