Home » RDBMS Server » Performance Tuning » Deletion on an partition table is very slow
Deletion on an partition table is very slow [message #252316] Wed, 18 July 2007 10:45 Go to next message
balaji1010
Messages: 35
Registered: March 2006
Location: London
Member

Hi all,

I have critical problem on production database.

SQL query is performing delete on an paritioned table.

can anyone let me know what could be core problem with this.

earlier query use to take 1 hr but now its taking more than 3 hrs.

size of the table is only 9gb

can any one help.

thanx in advance
Re: Deletion on an partition table is very slow [message #252323 is a reply to message #252316] Wed, 18 July 2007 11:07 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Read the stickies and post the appropriate informations.

Regards
Michel
Re: Deletion on an partition table is very slow [message #252374 is a reply to message #252316] Wed, 18 July 2007 13:12 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
balaji1010 wrote on Wed, 18 July 2007 09:45
Hi all,

I have critical problem on production database.

SQL query is performing delete on an paritioned table.

can anyone let me know what could be core problem with this.

earlier query use to take 1 hr but now its taking more than 3 hrs.

size of the table is only 9gb

can any one help.

thanx in advance




Where's your querry??
Previous Topic: Time Differnce in Execution with / without Hint
Next Topic: Real Application Testing --> Database Replay
Goto Forum:
  


Current Time: Tue Dec 06 14:00:28 CST 2016

Total time taken to generate the page: 0.05916 seconds