Re: Advantages of loading sorted data into large oracle tables

I was involved in a DW project - the accepted "best practices" of this IT consulting firm was to use Syncsort to pre-agregate ang load tables that would be used as a basis for MV (on prebuilt table)

The (untested) idea being that sysncsort was faster and more powerful than Oracle.

It wasn't by far.

Joe O'Brien

"Daniel Morgan" <damorgan_at_exesolutions.com> wrote in message news:3D0356E8.8F5D4957_at_exesolutions.com...
>
>
> Amit Ghosh wrote:
>
> > It is generally recommended that data be sorted on the primary key
before
> > loading into large tables ( partitions). At a minimum the advantage of
this
> > would be the ability to create indexes fast ( using the nosort option).
> > Since external sort programs such as syncsort are considerable more
> > effiecient than the sorting algorithms used by Oracle this would lead to
a
> > more efficient load process.
> >
>
> I keep hearing this about syncsort and it leads me to ask a question that
has
> been on my mind for awhile.
>
> Is this true? And if so, why doesn't Oracle just incorporate the syncsort
> algorithms into the engine?
>
> I couldn't be more than a week or two's worth of work.
>
> Any comments from those in the know?
>
> Daniel Morgan
>
Received on Mon Jun 10 2002 - 14:44:47 CDT