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