Home » SQL & PL/SQL » SQL & PL/SQL » Parallel threads on Deletes
Parallel threads on Deletes [message #247380] Mon, 25 June 2007 13:37 Go to next message
concorde800
Messages: 52
Registered: May 2007
Member
I wanted to know if deletes (Delete DML statement) can run on parallel threads. If not how can they be optimized for better query processing.

Can we use hints on the delete statement like we would on insert, update statements.

Thank you.
Re: Parallel threads on Deletes [message #247396 is a reply to message #247380] Mon, 25 June 2007 14:49 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Just try it.

Regards
Michel
Previous Topic: How to pass data file name as a parameter to the control file ?
Next Topic: Default values
Goto Forum:
  


Current Time: Thu Dec 05 08:21:10 CST 2024