Index on View ?

From: Keith Gray <keith(at)heart(dot)com(dot)au>
To: PostgreSQL <pgsql-sql(at)postgresql(dot)org>
Subject: Index on View ?
Date: 2001-04-05 04:18:55
Message-ID: 3ACBF22F.33AA9C36@heart.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Is it possible (feasible) to create an index on a view.

We have a large table and a defined sub-set (view)
from this table, would it be possible to keep an index
of the sub-set.

Keith

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Peter Galbavy 2001-04-05 07:29:10 Re: performance of functions - or rather lack of it
Previous Message Joel Burton 2001-04-05 01:59:51 [Tip] Using list-aggregates for faster batching