Re: Drop or disable index?

Hello!
You can't disable indexes, only drop.
But you may reduce load time using option sqlldr -- direct=y.

Best regards.
Yaroslav

"Calvin King" <cking_at_sandia.gov> ???????/???????? ? ???????? ?????????: news:3AB106B9.D80E77B7_at_sandia.gov...
> I have a fairly large database with several indexes. When loading large
> chunks of new data using SQL*Loader, the process is very slow because of
> these indexes. I could drop the indexes and recreate them after
> finishing my loading. However, I would be losing all the indexes that I
> had taken time to create in the first place.
>
> If, instead, I disable the indexes during the loading process, is it
> possible afterwards to append to the existing indexes.
>
> Hope my question is clear...
>
> Thanks, in advance, for any ideas/suggestions.
>
> Calvin King
Received on Thu Mar 15 2001 - 13:06:25 CST