Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: CLUSTER TABLES

Re: CLUSTER TABLES

From: Susanne <laloca_at_warum.net>
Date: Wed, 08 Jan 2003 23:11:29 +0100
Message-ID: <188p1vsfltni3kc8t721ffuuh6oqiukga1@4ax.com>


can cluster tables be partitioned in 9.2 ?

thanks,

Susanne

On Fri, 27 Dec 2002 02:57:20 GMT, "Jim Kennedy" <kennedy-down_with_spammers_at_attbi.com> wrote:

>size of the primary key of the parent + ((size of the primary key of the
>children)* # of children) -((size of the primary key of the parent)* # of
>children)
>
>eg
>parent is employee where the primary key is ssn (varchar2(9))
>child is pay where the primary key is ssn (varchar2(9)) and date of payment
>(date which is 7)
>so if on average you have 300 children records then
>9 + (300 * (9+7))- (300 * 9) or
>9+ (300 * 7) = 2,109
>
>Jim
>"Albert Punsola" <apunsola_at_hotmail.com> wrote in message
>news:aufikr$6td$1_at_nsnmpen2-gest.nuria.telefonica-data.net...
>> Hello ,
>>
>> someone knows to help me?
>> someone knows how to calculate SIZE parameter when cluster object is
>> calculate? someone knows the formula?
>>
>>
>> thanks,
>>
>> Albert Punsola
>>
>>
>>
>
Received on Wed Jan 08 2003 - 16:11:29 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US