Re: view or index to optimize performance - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: view or index to optimize performance
Date
Msg-id 200512212242.55099.peter_e@gmx.net
Whole thread Raw
In response to view or index to optimize performance  (Klein Balázs <Balazs.Klein@axelero.hu>)
Responses Re: view or index to optimize performance
List 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 by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Indices for select count(*)?
Next
From: Klein Balázs
Date:
Subject: Re: view or index to optimize performance