Home » RDBMS Server » Performance Tuning » fastest way for delete cascade
fastest way for delete cascade [message #229339] Fri, 06 April 2007 15:36 Go to next message
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.
Re: fastest way for delete cascade [message #229370 is a reply to message #229339] Sat, 07 April 2007 01:08 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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

Regards
Michel
Re: fastest way for delete cascade [message #229384 is a reply to message #229370] Sat, 07 April 2007 02:46 Go to previous messageGo to next message
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??
Re: fastest way for delete cascade [message #229386 is a reply to message #229384] Sat, 07 April 2007 02:51 Go to previous message
Michel Cadot
Messages: 64103
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
Previous Topic: Selecting different columns behave differently.
Next Topic: about materialized views
Goto Forum:
  


Current Time: Sun Dec 04 10:54:41 CST 2016

Total time taken to generate the page: 0.10488 seconds