Need your suggestion on below
We are having 10 production database tables with millions of records(
biggest one is 450 million records... highly transaction databases).. some
tables are already partitioned( now we have to increase the number of
partitions up to 1024 partitions) and few are UN-partitioned... All this
tables have referential integrity between them and some other tables which
are not in this 10 tables.. can you please advice me what is best practice
to increasing number of partitions or creating the partitions for existing
tables... Totally new to partitions..
Your suggestions will be much helpful?