Dear Experts ,
I have the following scenario.
On a given day I have to insert 3-4 million rows of data to a table .For performance reasons I would like to purge this data and move to another history db.
The OLTP part I would like to do from one DB and the GUI queries I would like to do from a different DB replica .
Could you please help me with some pointers for the same .
with thanks and regards
mahesh