Home » RDBMS Server » Performance Tuning » Deletion records - Performance  () 1 Vote
Deletion records - Performance [message #298462] Wed, 06 February 2008 02:52 Go to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
Hi,
I have 140 million records in the table and i deleted 30 million records from the table.
So i would like to know will it cause the performance degrade?

Thanks in advance.
Re: Deletion records - Performance [message #298464 is a reply to message #298462] Wed, 06 February 2008 02:56 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
76 posts and you ask a question in this manner? (and in the wrong forum too)
Absolutely no useful information whatsoever in order to even guess at an answer.
Read the posting guidelines. Please.
Re: Deletion records - Performance [message #298467 is a reply to message #298462] Wed, 06 February 2008 03:04 Go to previous messageGo to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
It is right that i should have post this topic in performance Tuning.
But my question is understadable.
I just want to know that after deletion of the near about 20%rows from the table will it cause performance problem for any select, insert, delete operations.
Dont you understand it?
Re: Deletion records - Performance [message #298468 is a reply to message #298467] Wed, 06 February 2008 03:05 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
I understand the question fine. Don't you understand my reply?
Re: Deletion records - Performance [message #298471 is a reply to message #298462] Wed, 06 February 2008 03:09 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Search on AskTom there is a whole thread on this topic (something like "delete million rows").

Regards
Michel
Re: Deletion records - Performance [message #298474 is a reply to message #298462] Wed, 06 February 2008 03:12 Go to previous message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
Thanks Michel,

Quote:

I understand the question fine. Don't you understand my reply?


I understand the reply fine. Don't answer for any question if you don't know anything.Thanks.
Previous Topic: DB deadlock issue
Next Topic: RBO to CBO migration
Goto Forum:
  


Current Time: Tue Dec 06 06:32:46 CST 2016

Total time taken to generate the page: 0.28335 seconds