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

Report message to a moderator

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: 68664
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Read the stickies and post the appropriate informations.

Regards
Michel

Report message to a moderator

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??

Report message to a moderator

Previous Topic: Time Differnce in Execution with / without Hint
Next Topic: Real Application Testing --> Database Replay
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jun 24 08:00:26 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.