Re: oracle 9204

Oradba Linux wrote:

> Our DB is primarily used as an OLTP. We are planning to implement
> partitioning on some of the tables.We have to decide on the partitioning
> key. Can partitioning key be the sequence which is the primary key for
> the non-partitioned table? Are there any pros/cons with this approach?
> Have you been able to avoid global indexes in an OLTP DB ?

What kind of partioning and why?
Range partitioning? Not likely to be of value. List partitioning? Definitely not.
Hash partitioning?

Are you partitioning for performance of maintainability?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)