Received: from www-uk-05.digiserve.com ([195.97.231.11]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f358uc891153 for ; Thu, 5 Apr 2001 04:56:38 -0400 (EDT) (envelope-from dev@archonet.com) Received: from mainbox.archonet.com (mwynhau.demon.co.uk [193.237.186.96]) by www-uk-05.digiserve.com (8.9.1/8.9.1) with ESMTP id JAA21558; Thu, 5 Apr 2001 09:57:26 +0100 (BST) Received: from client (client.archonet.com [192.168.1.16]) by mainbox.archonet.com (Postfix) with SMTP id DE9692A3AB; Thu, 5 Apr 2001 09:46:03 +0100 (BST) Message-ID: <012a01c0bdac$d7864760$1001a8c0@archonet.com> From: "Richard Huxton" To: "Keith Gray" , "PostgreSQL" References: <3ACBF22F.33AA9C36@heart.com.au> Subject: Re: Index on View ? Date: Thu, 5 Apr 2001 09:45:59 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200104/75 X-Sequence-Number: 2415 From: "Keith Gray" > 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. I don't think so - the view is basically just a select rule that rewrites queries based on it. Indexes on underlying tables should be used though. Difficult to suggest what indices you might need without knowing the view/tables/queries involved. - Richard Huxton