The main table is linked with many child tables using foreign key. And need to add the list partition in the main table but i want all child table will also be linked with this partitioned table. There are many indexes already defined. How can i do that?
Will there be any impact on the indexes?