Re: Index on a view??
От | Jeff Davis |
---|---|
Тема | Re: Index on a view?? |
Дата | |
Msg-id | 1104954944.2886.17.camel@jeff обсуждение исходный текст |
Ответ на | Index on a view?? ("Joost Kraaijeveld" <J.Kraaijeveld@Askesis.nl>) |
Список | pgsql-general |
No, you can only create an index on the underlying tables. A view is a virtual realtion, not a physical one, so what would the index point to? Any functionality you need you should be able to get with functional indexes. Perhaps if/when postgresql gets materialized views an index on a view might be useful. Regards, Jeff Davis On Wed, 2005-01-05 at 20:15 +0100, Joost Kraaijeveld wrote: > Hi all, > > Is it possible to create an index on a view? > > Groeten, > > Joost Kraaijeveld > Askesis B.V. > Molukkenstraat 14 > 6524NB Nijmegen > tel: 024-3888063 / 06-51855277 > fax: 024-3608416 > e-mail: J.Kraaijeveld@Askesis.nl > web: www.askesis.nl > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
В списке pgsql-general по дате отправления: