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.