Not daily ,monthly 5 lakhs we are inserting into it with the insert statement.

Daily we need to pull the records from that 20Million table.

Table is keep on increasing like this.now we want to split the table.

No idea how to do that.

How is that if we split vertically?(based on ID's and foreign keys)

But dalily we need all the columns data.