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?  (Rod Taylor <rbt@rbt.ca>)
Re: are views typically any faster/slower than equivilent joins?  (Rod Taylor <rbt@rbt.ca>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: why Sequencial Scan when selecting on primary key of table?
Следующее
От: Rod Taylor
Дата:
Сообщение: Re: are views typically any faster/slower than equivilent joins?