cost of CREATE VIEW ... AS SELECT DISTINCT

From: T E Schmitz <mailreg(at)numerixtechnology(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Subject: cost of CREATE VIEW ... AS SELECT DISTINCT
Date: 2005-03-28 21:43:09
Message-ID: 42487A6D.6020506@numerixtechnology.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello,
How expensive would it be to maintain the following VIEW:

CREATE VIEW origin AS SELECT DISTINCT origin FROM transaktion

if there is in index on transaktion.origin; the table transaktion has
thousands of records and there are only a few distinct origin?

--

Regards/Gruß,

Tarlika Elisabeth Schmitz

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Scott Marlowe 2005-03-28 22:04:23 Re: cost of CREATE VIEW ... AS SELECT DISTINCT
Previous Message Scott Marlowe 2005-03-28 20:48:07 Re: Postgres 7.3 migrate to 8.0 date problems.