Droping index before bulk loading

[ksk]

Hi,

The performance of bulk loader will increase if the destination table has no index so how to drop the index before bulk loading

Thanks

[ray.wurlod]

How about a DROP INDEX statement (perhaps embedded in a stored procedure) executed from the "Before SQL" or "Open Command"?

[ksk]

How about a DROP INDEX statement (perhaps embedded in a stored procedure) executed from the "Before SQL" or "Open Command"? ...

Is there is any other way without using jobs ?

[Sainath.Srinivasan]

How about a DROP INDEX statement (perhaps embedded in a stored procedure) executed from the "Before SQL" or "Open Command"? ...

Is there is any other way without using jobs ?

Don't have the index in the first place ?

Is that an interview question ?

What types of index do you have ? How many rows do you load ? Did you try loading without the index ? Is DataStage initiated via any third party tool ?

[ksk]

How about a DROP INDEX statement (perhaps embedded in a stored procedure) executed from the "Before SQL" or "Open Command"? ...

Is there is any other way without using jobs ?

Don't have the index in the first place ?

Is that an interview question ?

What types of index do you have ? How many rows do you load ? Did you try loading without the index ? Is DataStage initiated via any third party tool ?

b tree index, 1 million rows,ya its possible to do with datastage job as ray said but looking out for some other way like using scripts mean while am not using any third party tool

[ray.wurlod]

Just login to the database and drop the index!

[chulett]

And while bulk loader performance may be improved, don't forget to factor in the time it will take to rebuild the dropped index.