Re: loading first or create index first?

When using sqlloader in direct path, the index is put in direct path. If there is a problem with the
load, the index will be left in direct path. Loading in direct path bypasses the index, so it makes
no difference whether the index is created first or not, unless there is a requirement to not have
the index left in direct path status. When the load is done, it will re-enable the index (unless there
is a problem), just like you would if you created the index after the load.

Terry Ball
Sr. DBA, CSG Systems

steve_young_at_my-dejanews.com wrote:

> When I do a loading using sqlldr direct load, should I load the data first or
> create index first? If I create the indexes first, will the indexes put in
> 'direct path' state like data? Which will give the best performance?
>
> Thanks in advance.
>
> Steve
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Tue Dec 08 1998 - 00:00:00 CST