Postgres Pro
Downloads
Home   >   mailing lists

Re: cost of CREATE VIEW ... AS SELECT DISTINCT - Mailing list pgsql-sql

From Bruno Wolff III
Subject Re: cost of CREATE VIEW ... AS SELECT DISTINCT
Date
Msg-id 20050329150710.GB32031@wolff.to
Whole thread Raw
In response to Re: cost of CREATE VIEW ... AS SELECT DISTINCT  (T E Schmitz <mailreg@numerixtechnology.de>)
List pgsql-sql
Tree view 
On Tue, Mar 29, 2005 at 15:12:24 +0100, T E Schmitz <mailreg@numerixtechnology.de> wrote:
> 
> Shall do.
> But am I correct in assuming that I should place an index on the group 
> by (TRANSAKTION.ORIGIN) column?

This will mainly help when joining the view to another table. This would
also allow using an index scan instead of a sort in for DISTINCT which
may be faster in some cases.

pgsql-sql by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: cost of CREATE VIEW ... AS SELECT DISTINCT
Next
From: Tom Lane
Date:
Subject: Re: cost of CREATE VIEW ... AS SELECT DISTINCT