Indexes and inheritance

From: "Pierre Thibaudeau" <pierdeux(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Indexes and inheritance
Date: 2006-03-24 05:42:36
Message-ID: 74b035bb0603232142g2dcbe0ceu@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I have a "daughter" table that inherits from a "mother" table. The mother
table has an index on column A. Would there be any point on creating an
index on column A of the daughter? If so, in what circumstances?

(Using PostgreSQL 8.1.3.)

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Alan Hodgson 2006-03-24 17:32:37 Re: Indexes and inheritance
Previous Message Sean Davis 2006-03-24 02:58:15 Re: Bytea and perl