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: 65153
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: cached objects in buffer
Next Topic: 10g performance tuning (how can I practice?)
Goto Forum:

Current Time: Tue Aug 22 08:04:14 CDT 2017

Total time taken to generate the page: 0.05029 seconds