are views typically any faster/slower than equivilent joins?

Поиск
Список
Период
Сортировка
От Brian Tarbox
Тема are views typically any faster/slower than equivilent joins?
Дата
Msg-id 001801c327e9$3c01a5b0$01000001@trouble
обсуждение исходный текст
Ответ на Re: why Sequencial Scan when selecting on primary key of table?  (Andrew Sullivan <andrew@libertyrms.info>)
Ответы Re: are views typically any faster/slower than equivilent joins?
Re: are views typically any faster/slower than equivilent joins?
Список pgsql-performance
I am working with a highly normalized database.  Most of my meaningful
queries involve joins from a primary table to 4-6 secondary tables.

Would my query performance be significantly faster/slower using a View as
opposed to a prepared query using join?

(Assume all join fields are ints, say 10,000 records in main table and a few
dozen records in each of the secondary tables).

Thank you.

Brian Tarbox


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