Home » RDBMS Server » Server Administration » impact of deleting rows on table (10.2.0.2)
impact of deleting rows on table [message #379269] Mon, 05 January 2009 15:07 Go to next message
varunvir
Messages: 363
Registered: November 2007
Senior Member
Hi Experts,
I have one table having millions of rows which is used for reporting purpose.
I created new table with same structure.
Now If I move the data older than 2 years to new table and
then delete the moved data from old table,will it increase the
query performance.If it wont,What is the appropriate solution
to enhance the performance on the table conaining millions of
rows.
Regards,
Varun Punj,
Re: impact of deleting rows on table [message #379272 is a reply to message #379269] Mon, 05 January 2009 15:49 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>will it increase the query performance.
I hate to say, but it depends on the query.Smile
Infact, just deleting will not reset HWM.
If you are worried about fragmentation, search about that in this forum. First list down what makes you think the table is fragmented.
Or
You can look into partitioning the table and deal with it.
It all depends on your data.

>>What is the appropriate solution to enhance the performance on the table conaining millions of rows.

This kind of question usually invites all sorts of sarcastic responses.

Define performance in a metric.
See how your table is performing, with respect to this metric.
Then look into code you are using and proceed.

To find a solution, first you have to identify the problem.
First Isolate the code/module whatever.






[Updated on: Mon, 05 January 2009 16:01]

Report message to a moderator

Previous Topic: user/dba_segments refresh issue
Next Topic: v$session issue
Goto Forum:
  


Current Time: Sun Dec 04 00:19:27 CST 2016

Total time taken to generate the page: 0.10504 seconds