Re: More pain and sufferring with Tropashko's materialized path...

Hello Vadim,

"Vadim Tropashko" <vadimtro_at_yahoo.com> wrote in message news:22d2e427.0310201144.126d45ab_at_posting.google.com...
> boston103_at_hotmail.com (VC) wrote in message news:<31e0625e.0310181132.61cecc11_at_posting.google.com>...
> > vadimtro_at_yahoo.com (Vadim Tropashko) wrote in message news:<22d2e427.0309171245.534732eb@posting.google.com>...

1.3292E+36 1.3292E+36
> >
> > ERROR:
> > ORA-06502: PL/SQL: numeric or value error: number precision too large
> > ORA-06512: at "STARGUS.CHILD_NUMER", line 5
> > ORA-06512: at "STARGUS.PATH_NUMER", line 19
> > ORA-06512: at line 1
> >
> > ... only after 120 rows.
> >
>
> This is correct, the coding numbers are growing exponentially.
> Therefore, any fixed precision ariphmetics would break at some point.
> This is why the new "dense" integer coding schema.

Would you be kind enough to provide more detail about the new dense encoding schema ?

Thanks.

Rgds. Received on Tue Oct 21 2003 - 01:18:27 CEST