Re: oracle 9204

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Thu, 11 Nov 2004 21:43:43 -0800
Message-ID: <1100238147.233567@yasure>

Oradba Linux wrote:

> 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.

How exactly would you propose to range partition based a sequence?

In other words ... what you are writing here is mutually exclusive
in normal usage. You can hash partition based on a sequence but not
range partition. And the type of partitioning chosen depends on the

purpose.

I would suggest you hit http://tahiti.oracle.com and read the concept docs on partitioning. Then reask your question when you better know what it is you are trying to accomplish.

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

Received on Thu Nov 11 2004 - 23:43:43 CST