By Creating indexes and reference IDs.
Why should I not commit after every record when updating a large table Committing after every record does not hurt but its much efficient to commit after a batch of records like 5000 - 7000.
Do i need to write in PL/SQL or is it possible in SQL query?