Re: Partitioned table or several smaller tables?

From: Mark Bole <makbo_at_pacbell.net>
Date: Fri, 13 Aug 2004 13:32:10 GMT
Message-ID: <up3Tc.4112$sg2.3423@newssvr27.news.prodigy.com>

John wrote:

> Hi group,
>
> Say I have 3 tables with same structure and differnet data, one
> current the other 2 historical. I only occasionally need to access the
> historical data. Would you put 3 of them into a single partitioned
> table? Why? Thanks for sharing!
>
> John

How much data per table, what growth rate?

Partitioning is a great tool but at some additional cost, both licensing and maintenance. For example, to get the full benefit of partitioning for making backups, individual partitions should be in separate tablespaces (so you can back them up at different times).

For small, slow-growing tables, might not be worth it.

--Mark Bole Received on Fri Aug 13 2004 - 08:32:10 CDT