Re: CLUSTER TABLES

From: Jim Kennedy <kennedy-down_with_spammers_at_attbi.com>
Date: Fri, 27 Dec 2002 02:57:20 GMT
Message-ID: <kkPO9.522475$NH2.35439@sccrnsc01>

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 Thu Dec 26 2002 - 20:57:20 CST