Re: How should I partition this table?
Everything you're saying makes sense and I appreciate the input. I'll be sending you the sample selects after making this post.
I discovered that their queries were, as I suspected, more complex than the developers lead me to believe.
I have not yet implemented your prior suggestions, but I will. Prior to those latest recommendations of yours, I started the process of altering the partitions on the largest table (i.e., INVITMD) on the test server. I then ran a test using one of the sample queries that I'll be sending you. It took just over 16 seconds on the production box and less than 1 second on the test box. Part of the difference in results is due to better system specs on the test box, but I think the majority of it was due to the partitioning.
Subject
Views
Written By
Posted
3629
April 26, 2013 09:18AM
1903
April 27, 2013 09:58PM
1714
April 28, 2013 11:29AM
1677
April 29, 2013 08:10AM
1672
April 30, 2013 08:39AM
1776
May 01, 2013 11:45PM
1647
May 02, 2013 08:17AM
1548
May 02, 2013 11:55AM
1615
May 03, 2013 09:00AM
Re: How should I partition this table?
1665
May 03, 2013 09:32AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.