I don't know what does the documentation say. (eg at otn.oracle.com)
Jim
--
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family. Remove the negative part, keep the minus sign. You can figure
it out.
"Susanne" <laloca_at_warum.net> wrote in message
news:188p1vsfltni3kc8t721ffuuh6oqiukga1_at_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 - 20:58:51 CST
