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.
--
Alan