Re: optimising a create table as select
Just to clarify the best practice is not to incrementally commit
START TRANSACTION;
Insert into historical_readings_new select * from historical_readings
Where t2.id > 6847513903;
Commit;
or which I could break this up into separate transactions based on the ID.
Thanks
Dan
Subject
Written By
Posted
Re: optimising a create table as select
May 19, 2014 10:14AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.