Re: Question about partitioning...

From: Andy <enzoweb_at_hotmail.com>
Date: 12 Aug 2002 15:43:44 -0700
Message-ID: <8d4033cd.0208121443.1f2c665c@posting.google.com>

I have a different question regarding partitioning -

The application has "period" tables, and I said that they were good candidates for partitioning. Someone said "Why" and I said "er, um, actually that's a good question."

So, could someone tell me if it would be useful to use partitions in this case, or to leave them alone?

The application has tables called (for example): TRANSACTIONS and BALANCES. Every month these tables are copied to period tables called TRANSACTIONS0207, BALANCES0207 and then truncated, ready to be populated with the current month's data. So, we have tables going back to TRANSACTIONS9901.

Since all these tables are separate entities and have their own indexes, would there be any advantages in just allowing TRANSACTIONS and BALANCES to contain everything and partition them? The BALANCES table has about 400,000 rows, the TRANSACTION table 700,000. Received on Mon Aug 12 2002 - 17:43:44 CDT