Hi All,
I may be asking a silly question.
I am trying to insert records from one table to another table.
INSERT INTO BACKUP
SELECT * FROM A;
DELETE FROM A;
The first insert statement is running forever. My record count in table A is 0.5 million.
I understand my table record count is high. But I need to optimize this as it is hanging my session.
Any suggestions on this please.
Thanks in advance