OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Records Deletion

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Records Deletion [message #64456]

Mon, 31 January 2005 01:49

raghukalyan
Messages: 44
Registered: May 2004

Member

hi ,

I am having a table which is having 118200000 records .I want to delete the records using a correlated delete.I have done this ..but it is taking lot of time.First i used NOT IN clause in my query later uses not exists but there is no difference ...
Is there any other way to solve my problem ???

Hoping for a quick response.

Regards,
Raghukalyan.G

Report message to a moderator

Re: Records Deletion [message #64461 is a reply to message #64456]

Mon, 31 January 2005 04:47

VJ
Messages: 24
Registered: June 2002

Junior Member

It will certainly take a longer time...the faster and better option will be to create a new table by selecting only required rows and then truncate the source table and then bring the data back ..

-V

Report message to a moderator

Re: Records Deletion [message #64465 is a reply to message #64456]

Mon, 31 January 2005 05:22

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

there are many dependent factors.
presence of Index, skewness of data , availablity of statistics etc.
First analyze the table and index.
try again.
If it is not working,
Use CTAS to create a staging table ( with nologging option).do the business in stageing table.
Insert into original table ( with nologging option).

Report message to a moderator

Previous Topic:	Need Queries / PL - SQL blocks for the follwing.
Next Topic:	error_log in Apache directory

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 04:24:29 CDT 2024