Re: loading first or create index first?

steve young_at_my-dejanews.com wrote in message <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?

Obviously, first load the data, then create indexes. Sorry to say that, but read the (...) manual a bit more carefully. To achieve the best performance
consider using unrecoverable option while indexing.

Piotr

--
Piotr Kolodziej pkol_at_otago.gda.pl
Just my private opinion.