Re: Oracle partitioning

How good a tool table partitioning may be depends on a lot of information that only you have access to such as how many different customers can be expected to be supported in one application and how similar will each customer's quantity of data be?

If some customers have an order of magnitude more data than others than from a physical partition management (space) point of view partitioning by time then customer might work out better than customer/time.

Remember that you have use of traditional views, system contexts, database event triggers, and RLS to use in 'partitioning' the data for access purposes and you are going to want to select the best set of tools up front if at all possible.

Also remember that even though it seems to be installed in EE automatically table partitioning is a paid extra and in not included in the base product.

HTH -- Mark D Powell -- Received on Mon Aug 22 2005 - 14:04:47 CDT