Re: loading first or create index first?

From: victor <victor_at_PERCOMBANK.KIEV.UA>
Date: 1998/12/08
Message-ID: <01be22a1$d9675720$6b14abcc@victor>#1/1

steve_young_at_my-dejanews.com wrote in article <74igov$48u$1_at_nnrp1.dejanews.com>...
> 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

may be load first without any constraints and after it make primary key and so on Received on Tue Dec 08 1998 - 00:00:00 CST