Re: Index on a view??

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(dot)Kraaijeveld(at)Askesis(dot)nl
> web: www.askesis.nl
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org