Re: Creating index on a view?
От | Patrick Fiche |
---|---|
Тема | Re: Creating index on a view? |
Дата | |
Msg-id | 034701c4d211$362cd000$2e01a8c0@pc3648pfi обсуждение исходный текст |
Ответ на | Re: Creating index on a view? (Peter Eisentraut <peter_e@gmx.net>) |
Список | pgsql-general |
Some time ago, an excellent tutorial on materialized views with PostgreSQL was pointed at this address.... http://jonathangardner.net/PostgreSQL/materialized_views/matviews.html Patrick > -------------------------------------------------------------------------- ----------------- > Patrick Fiche > email : patrick.fiche@aqsacom.com > tél : 01 69 29 36 18 > -------------------------------------------------------------------------- ----------------- > > > -----Original Message----- From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org]On Behalf Of Peter Eisentraut Sent: mercredi 24 novembre 2004 11:15 To: Net Virtual Mailing Lists Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Creating index on a view? Net Virtual Mailing Lists wrote: > My question is regarding creating an index on a view, or perhaps > another way to accomplish this. Views are just macro expansions of queries (in a manner of speaking). To make queries on views use indexes, you create the indexes on the underlying tables in the same way as if you had typed in the expanded view query yourself. (In your example, you'd just need the usual indexes on the primary keys.) If what you want is that the creation of an index on a view automatically materializes that view (don't other database systems do that?), then you will have to implement that manually in PostgreSQL, with triggers and a bunch of code. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org Protected by Polesoft Lockspam http://www.polesoft.com/refer.html
В списке pgsql-general по дате отправления: