Re: [GENERAL] Must I create an index for child table if master table have one?

*To clarify, if you are talking about partitioning, then you almost certainly want to create a similar index on the child table.* *If you are referring to a Foreign Key Constraint, then it is also good idea to make that index, but not necessary.* On Tue, Nov 8, 2016 at 1:46 PM, Melvin Davidson

Re: [GENERAL] Must I create an index for child table if master table have one?

On Tue, Nov 8, 2016 at 1:33 PM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Tue, Nov 8, 2016 at 11:08 AM, Edmundo Robles > wrote: > >> Hi! >> >> i have a simple question, if the master table have an index, must i >> have create the same index in a child

Re: [GENERAL] Must I create an index for child table if master table have one?

On Tue, Nov 8, 2016 at 11:08 AM, Edmundo Robles wrote: > Hi! > > i have a simple question, if the master table have an index, must i > have create the same index in a child table? > what is the best practice for indexes in table partition ? > Indexes are

[GENERAL] Must I create an index for child table if master table have one?

Hi! i have a simple question, if the master table have an index, must i have create the same index in a child table? what is the best practice for indexes in table partition ?