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 -~----------~----~----~----~------~----~------~--~---