cost of CREATE VIEW ... AS SELECT DISTINCT

Поиск
Список
Период
Сортировка
От T E Schmitz
Тема cost of CREATE VIEW ... AS SELECT DISTINCT
Дата
Msg-id 42487A6D.6020506@numerixtechnology.de
обсуждение исходный текст
Ответы Re: cost of CREATE VIEW ... AS SELECT DISTINCT  (Scott Marlowe <smarlowe@g2switchworks.com>)
Список 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


В списке pgsql-sql по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: Postgres 7.3 migrate to 8.0 date problems.
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: cost of CREATE VIEW ... AS SELECT DISTINCT