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 <melvin6925@xxxxxxxxx> wrote:
IOW, yes.On Tue, Nov 8, 2016 at 1:33 PM, David G. Johnston <david.g.johnston@xxxxxxxxx> 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
--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.![]()
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
