Home » RDBMS Server » Performance Tuning » Takes more time - DELETE.
Takes more time - DELETE. [message #258381] Sat, 11 August 2007 06:54 Go to next message
Messages: 66
Registered: July 2006
The following delete takes more time to execute.

DELETE FROM credential_on
WHERE credential_on_id IN 
        (SELECT credential_on_id
         FROM credential_on_appl
         WHERE appn_num <= ANY (SELECT appn_num
                                FROM masterdriver)

Is there a way to tune this statement.


[Updated on: Sat, 11 August 2007 09:17] by Moderator

Report message to a moderator

Re: Takes more time - DELETE. [message #258395 is a reply to message #258381] Sat, 11 August 2007 09:19 Go to previous messageGo to next message
Michel Cadot
Messages: 63917
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
First read Performance Tuning Sticky and provide the requested information.

Re: Takes more time - DELETE. [message #258871 is a reply to message #258395] Mon, 13 August 2007 12:30 Go to previous message
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
check IN vs Exists
Previous Topic: Different Explain in Different Instances.
Next Topic: how to find out the I/O and CPU bottleneks
Goto Forum:

Current Time: Mon Oct 24 22:28:19 CDT 2016

Total time taken to generate the page: 0.12935 seconds