Do Views offer any performance advantage?

Поиск
Список
Период
Сортировка
От Robert John Shepherd
Тема Do Views offer any performance advantage?
Дата
Msg-id 001f01c30366$93427720$f3b0313e@LAIKA
обсуждение исходный текст
Ответы Re: Do Views offer any performance advantage?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
Hi all,

Whilst I often use views for convenience, is there any performance
advantage at all in using a view rather than running the same query
directly on the tables themselves?

Is it quicker to run a full complex query rather than run a much simpler
query on a view? (Hope that makes sense)


Yours Unwhettedly,
Robert John Shepherd.

Editor
DVD REVIEWER
The UK's BIGGEST Online DVD Magazine
http://www.dvd.reviewer.co.uk

For a copy of my Public PGP key, email: pgp@robertsworld.org.uk


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

Предыдущее
От: Will LaShell
Дата:
Сообщение: Re: for help!
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: [GENERAL] Yet Another (Simple) Case of Index not used