Re: oracle 9204

From: Oradba Linux <oradba_linux_at_comcast.net>
Date: Tue, 09 Nov 2004 05:11:51 GMT
Message-ID: <rkYjd.383961$D%.57466@attbi_s51>

DA Morgan wrote:
> 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?

Partitioning for both. It will be a range partition. Why would range partition not be of value. Received on Mon Nov 08 2004 - 23:11:51 CST