Received: from gw.heart.com.au (mail.hcs.com.au [203.12.235.237]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f354FH846387 for ; Thu, 5 Apr 2001 00:15:18 -0400 (EDT) (envelope-from keith@heart.com.au) Received: from tardis.heart.com.au (IDENT:root@tardis.heart.com.au [192.168.0.42]) by gw.heart.com.au (8.9.3/8.9.3) with ESMTP id OAA14057 for ; Thu, 5 Apr 2001 14:26:12 +1000 Received: from heart.com.au ([192.168.0.65]) by tardis.heart.com.au (8.9.3/8.8.7) with ESMTP id OAA32676 for ; Thu, 5 Apr 2001 14:15:09 +1000 Message-ID: <3ACBF22F.33AA9C36@heart.com.au> Date: Thu, 05 Apr 2001 14:18:55 +1000 From: Keith Gray X-Mailer: Mozilla 4.74 [en] (Win98; U) X-Accept-Language: en MIME-Version: 1.0 To: PostgreSQL Subject: Index on View ? Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200104/72 X-Sequence-Number: 2412 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