Deleting large number of rows Quickly in Oracle Db [message #346952] |
Wed, 10 September 2008 03:36  |
sudheer0886
Messages: 7 Registered: September 2008
|
Junior Member |
|
|
Hi,
I have one issue in the project like I need to delete a large number of (2 million) tuples from a table of 5 million based on some criteria.The criteria(condition) is fetched from one base table,based on the fetched data tuple is deleted.similarly I have to delete from 30 similar tables.
Like "Delete from employees where id IN(select id from empinfo where empinid=100)"
I tried some options
-Writing all the queries in a file and running the script
-Using a cursor (creating a index table) and deleting particular tuple from the table
Both giving me a large response time.
Can I use NOLOGGING option with DELETE to achieve my response time..??
Main concern here is time. I need to delete in very quick time.
So I need a optimised and efficient solution for the issue.
Thanks In Anticipation.
|
|
|
|
|
|
|