Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 3BA1F9FB296 for ; Fri, 3 Nov 2006 15:17:48 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 55527-01 for ; Fri, 3 Nov 2006 15:17:42 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 164D89F9858 for ; Fri, 3 Nov 2006 15:17:41 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from smtp-out.google.com (smtp-out.google.com [216.239.45.12]) by svr4.postgresql.org (Postfix) with ESMTP id 29A095AF8A3 for ; Fri, 3 Nov 2006 19:17:41 +0000 (GMT) Received: from zps78.corp.google.com (zps78.corp.google.com [172.25.146.78]) by smtp-out.google.com with ESMTP id kA3JHYCD015805 for ; Fri, 3 Nov 2006 11:17:34 -0800 DomainKey-Signature: a=rsa-sha1; s=beta; d=google.com; c=nofws; q=dns; h=received:message-id:date:from:to:subject:mime-version:content-type; b=C6nWWyZQnBTeNjD3RoEWEOklNPeRaj3BSVQEPYvNmML+NyOf8A7cz+6qnOj2aiD4K l/LaMvv9l7jUqbZHNKBlg== Received: from ug-out-1314.google.com (ugeo4.prod.google.com [10.66.166.4]) by zps78.corp.google.com with ESMTP id kA3JHV8s025294 for ; Fri, 3 Nov 2006 11:17:32 -0800 Received: by ug-out-1314.google.com with SMTP id o4so439691uge for ; Fri, 03 Nov 2006 11:17:31 -0800 (PST) Received: by 10.78.180.18 with SMTP id c18mr3348958huf.1162581450788; Fri, 03 Nov 2006 11:17:30 -0800 (PST) Received: by 10.78.140.8 with HTTP; Fri, 3 Nov 2006 11:17:30 -0800 (PST) Message-ID: <3ddac38d0611031117v742c5c84p3264c894709b559d@mail.gmail.com> Date: Fri, 3 Nov 2006 11:17:30 -0800 From: "Dylan Lorimer" To: pgsql-sql@postgresql.org Subject: Index + View Question MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_22147_3552922.1162581450712" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/43 X-Sequence-Number: 26695 ------=_Part_22147_3552922.1162581450712 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi, If I've got several tables, each with their own indexes. I also have a view that aggregates several of these tables. My question is, as novice-like as it may sound, do I need to create new indexes on the view or do the indexes from the orig. tables apply somehow when I select data from the view? Cheers, Dylan ------=_Part_22147_3552922.1162581450712 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi,

If I've got several tables, each with their own indexes. I also have a view that aggregates several of these tables. My question is, as novice-like as it may sound, do I need to create new indexes on the view or do the indexes from the orig. tables apply somehow when I select data from the view?

Cheers,
Dylan
------=_Part_22147_3552922.1162581450712--