Drop or disable index?

From: Calvin King <cking_at_sandia.gov>
Date: Thu, 15 Mar 2001 11:15:21 -0700
Message-ID: <3AB106B9.D80E77B7@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 - 12:15:21 CST