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.