2006/3/24, Alan Hodgson <ahodgson(at)simkin(dot)ca>:
>
> On March 23, 2006 09:42 pm, "Pierre Thibaudeau" <pierdeux(at)gmail(dot)com>
> wrote:
> > 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?
>
> Indexes are not inherited, so in fact you have to create the index on
> column A of the daughter if you want the expected behaviour.
Ah, thank you.
So I suppose, the new index on the daughter is akin to a partial index on
the mother, although one that couldn't be used while searching the mother...