Hi Sakthi, please provide complete query. Have u created index on table from which u want deleting records.
On Fri, Aug 21, 2009 at 4:47 PM, sakthi <[email protected]> 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 > > > > > -- Thanks & Regards Vikrant Adhyapak 09987018794 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
