*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 <melvin6...@gmail.com> wrote: > > > 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 <edmu...@sw-argos.com> >> 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 self-contained within the physical table on which they are >> defined. The index on the master contains no rows that are present in the >> child table. >> >> David J. >> >> > >Indexes are self-contained within the physical table on which they are > defined > *IOW, yes. * > > -- > *Melvin Davidson* > I reserve the right to fantasize. Whether or not you > wish to share my fantasy is entirely up to you. > -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.
