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

Reply via email to