Re: Indexes and inheritance

On March 23, 2006 09:42 pm, "Pierre Thibaudeau" <pierdeux@gmail.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.

--
Alan