| Deletion records - Performance [message #298462] |
Wed, 06 February 2008 02:52  |
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  |
pablolee
Messages: 2882
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 |
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 #298474 is a reply to message #298462] |
Wed, 06 February 2008 03:12 |
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.
|
|
|
|
) 1 Vote
] 
Blog
Search
Help
Members
Register
Login
Home
