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
Ответ на
are views typically any faster/slower than equivilent joins? (Brian Tarbox)
Список
Дерево обсуждения
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
Дата: