if we have a big table having size 300 with 2 billion record in it.
How many splits are recommended to be done on this table?
Is there any max number for table splitting?
Read somewhere that recommendation is to have table split in such a way that it should not contain more than 10 million records per split.
Required expert inputs here.