Re: [GENERAL] inherits index

2006-01-02 Thread Scott Ribe
My understanding is that you will need to set up the indexes on the child table in order to do any good for queries on the child table. Also, you have foreign key (an other, like primary key, I think) constraints are not inherited and have to be repeated on each table. Think of it like this: table

[GENERAL] inherits index

2006-01-02 Thread Matthew Peter
I have a parent table that is inherited by a couple others... Would it be best to set up an index on the children tables column that is inherited by the parent, or should I index the parent column that is inherited by the children? The children tables are the ones called frequently, not the par