| impact of deleting rows on table [message #379269] |
Mon, 05 January 2009 15:07  |
varunvir
Messages: 389
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  |
 |
Mahesh Rajendran
Messages: 10707
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.
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
