Postgres Pro
Downloads
Home   >   mailing lists

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

From T E Schmitz
Subject cost of CREATE VIEW ... AS SELECT DISTINCT
Date
Msg-id 42487A6D.6020506@numerixtechnology.de
Whole thread Raw
Responses Re: cost of CREATE VIEW ... AS SELECT DISTINCT  (Scott Marlowe <smarlowe@g2switchworks.com>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Postgres 7.3 migrate to 8.0 date problems.
Next
From: Scott Marlowe
Date:
Subject: Re: cost of CREATE VIEW ... AS SELECT DISTINCT