I have one table (TABLE A) which updates with milions of records every day. Now Every day we clear the data of this TABLE A; but before clear the data from TABLE A we get all data from TABLE A and move it into another table TABLE B due to
some purpose and we are using
INSERT INTO TABLE B (col1,col2,.......colN) values (SELECT col1,col2,..........colN from TABLE A)
This approch is not giving us a best performance as we are selecting all data from TABLE A and then inserting into TABLE B in one shot and i have millions of rows in my TABLE A (sometimes 16 millions).
Can anyone suggest any other approch to do so that i can get best performance ?
View Complete Post