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

[Melvin Davidson <melvin6925@xxxxxxxxx>]

On Tue, Nov 8, 2016 at 1:33 PM, David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:

On Tue, Nov 8, 2016 at 11:08 AM, Edmundo Robles <edmundo@xxxxxxxxxxxx> 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.