Re: Indexes and inheritance
| От | Pierre Thibaudeau |
|---|---|
| Тема | Re: Indexes and inheritance |
| Дата | |
| Msg-id | 74b035bb0603241106w4be5ccc5j@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Indexes and inheritance (Alan Hodgson <ahodgson@simkin.ca>) |
| Ответы |
Re: Indexes and inheritance
|
| Список | pgsql-novice |
2006/3/24, Alan Hodgson <ahodgson@simkin.ca>:
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...
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...
В списке pgsql-novice по дате отправления: