delete in chunks rather deleting in one go. -Sonty
On Aug 21, 4:17 pm, sakthi <ihimi...@gmail.com> wrote: > Hi Experts, > > I m have problem with sql delete statement. > > When the no. of records is less in my table , its getting deleted > successfully with in a minute. > > But if my table have 10 lac records , and i m tried to delete some of > 60000 records based on query condition,it is taking more then 3 hours > to perform this operation. > I m using oracle 10.2 g verion > > Please guide me to do the correct thing.... > > Thanks in advance, > Sakthi --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
