Re: view or index to optimize performance

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Cc: Klein Balázs <Balazs(dot)Klein(at)axelero(dot)hu>
Subject: Re: view or index to optimize performance
Date: 2005-12-21 21:42:54
Message-ID: 200512212242.55099.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Klein Balázs 2005-12-21 21:49:29 Re: view or index to optimize performance
Previous Message Peter Eisentraut 2005-12-21 21:39:58 Re: Indices for select count(*)?