Re: view or index to optimize performance

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: view or index to optimize performance
Дата
Msg-id 200512212242.55099.peter_e@gmx.net
обсуждение исходный текст
Ответ на view or index to optimize performance  (Klein Balázs <Balazs.Klein@axelero.hu>)
Ответы Re: view or index to optimize performance
Список pgsql-general
Am Mittwoch, 21. Dezember 2005 21:27 schrieb Klein Balázs:
> Or should I instead create a view that contains only the biodata and select
> from that? But will postgres use the indexes than? Would that be a better
> approach?

Whether the query is executed by a view or typed in in its full form by hand
is completely irrelevant to the question whether indexes are used or should
be created.  Views do not optimize anything.

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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: Indices for select count(*)?
Следующее
От: Klein Balázs
Дата:
Сообщение: Re: view or index to optimize performance