| From: | hubert depesz lubaczewski <depesz(at)depesz(dot)pl> |
|---|---|
| To: | pgSQL <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Time penalty on VIEWS on VIEWS |
| Date: | 2000-11-05 11:50:03 |
| Message-ID: | 20001105125003.D27532@gruby |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Hi,
My situation: VIEW A is grouping information from 2 tables (B,C). I have to
make another VIEW with additional WHERE statement compared in VIEW A. I can
make this as a VIEW groupping tables B and C, or makeing VIEW of VIEW A.
I know that second sollution is more flexible but there should be some kind of
time penalty. I'm wondering how much it is.
regards,
depesz
--
hubert depesz lubaczewski
------------------------------------------------------------------------
najwspanialszą rzeczą jaką dało nam nowoczesne społeczeństwo,
jest niesamowita wręcz łatwość unikania kontaktów z nim ...
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jean-Christophe Boggio | 2000-11-05 18:03:28 | Help with GROUP BY |
| Previous Message | hubert depesz lubaczewski | 2000-11-05 11:44:36 | Question about ordering views |