Re: Why export has conventional path?

If you have a table which has 100,000 records and there are 20 indexes on this table.
which one is faster.
ignore the indexes and insert the records directly in to the table. or
for each records which you insert update the indexes.

Tom
Alan <alan_psb_at_yahoo.com> wrote in message news:38EEBFB5.41EBE0CF_at_yahoo.com...
> Hello all,
>
> I have a simple export question.
>
> I know that using export by direct path mode is faster than using
> the conventional path. I want to ask, why export not use the direct mode
> as the default mode (or even delete the conventional mode)? Is there any
> reason why export still has the converntional mode? What is the risk of
> using direct mode during export?
>
> Thanks,
> Alan
>
Received on Mon Apr 10 2000 - 00:00:00 CDT