Hi All,
Please help on this :

I want to drop the indexes of a table while loading the data into table as load is taking too much time in building the indexes. Is this possible..please revert asap its very urgent.


Regards,
Harsh Verma

if the load is in progress, you cannot.

this is true in case of db2. don't know what database you are talking about as you haven't mentioned.

You'll probably have to (re)build the indexes anyhow after the load finishes, that is: the "create index" will do that.
So it's not necessarily a good idea to drop indexes before starting the load.
(It could be, sure; but all depends on a lot of other aspects.)

if it is not an index enforcing PK or unique constraints.