Re: How should I partition this table?

[Ron Bergin]

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.