OraFAQ Forum: Performance Tuning » fastest way for delete cascade

Home » RDBMS Server » Performance Tuning » fastest way for delete cascade

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

fastest way for delete cascade [message #229339]

Fri, 06 April 2007 15:36

laiko
Messages: 10
Registered: February 2007

Junior Member

I have a hierarchy of tables which have huge data volume. Can you please advise me on what can be the fastest way to delete from the parent table all the way to its child tables? Thank you in advance.

Report message to a moderator

Re: fastest way for delete cascade [message #229370 is a reply to message #229339]

Sat, 07 April 2007 01:08

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Maybe using "ON DELETE CASCADE" clause on foreign keys?

Regards
Michel

Report message to a moderator

Re: fastest way for delete cascade [message #229384 is a reply to message #229370]

Sat, 07 April 2007 02:46

laiko
Messages: 10
Registered: February 2007

Junior Member

Thanks, Michel, but I'm so sorry, I missed to mention that I am already using 'ON DELETE CASCADE'. What I would like to know is that is there any faster alternative??

Report message to a moderator

Re: fastest way for delete cascade [message #229386 is a reply to message #229384]

Sat, 07 April 2007 02:51

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

I don't see any above all if you want to do it safely and concurrently. I mean if other sessions work at the same time.

Regards
Michel

Report message to a moderator

Previous Topic:	Selecting different columns behave differently.
Next Topic:	about materialized views

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 16 09:14:44 CDT 2024