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
marlon_loyolite
Messages: 66
Registered: July 2006
Member
Hi
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.

Regards,
XJD

[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: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
First read Performance Tuning Sticky and provide the requested information.

Regards
Michel
Re: Takes more time - DELETE. [message #258871 is a reply to message #258395] Mon, 13 August 2007 12:30 Go to previous message
DreamzZ
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: Tue Nov 26 22:33:22 CST 2024