From: imad <immaad@gmail.com>
To: Dylan Lorimer <edylan@google.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Index + View Question
Date: Sat, 4 Nov 2006 00:48:27 +0500
Message-ID: <1f30b80c0611031148q3e2af041r9b8ab1e5ac704b0e@mail.gmail.com> (raw)
In-Reply-To: <3ddac38d0611031117v742c5c84p3264c894709b559d@mail.gmail.com>
References: <3ddac38d0611031117v742c5c84p3264c894709b559d@mail.gmail.com>
When you select from views, you are infact selecting from the
underlying tables. Indexes created on those tables are used
ultimately.
--Imad
www.EnterpriseDB.com
On 11/4/06, Dylan Lorimer <edylan@google.com> wrote:
> 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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: immaad@gmail.com, edylan@google.com
Subject: Re: Index + View Question
In-Reply-To: <1f30b80c0611031148q3e2af041r9b8ab1e5ac704b0e@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox