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.
