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
Messages: 52
Registered: May 2007
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: 63908
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Just try it.

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

Current Time: Fri Oct 21 06:24:40 CDT 2016

Total time taken to generate the page: 0.12407 seconds