DSXchange

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

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

ray.wurlod wrote: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 ?

ksk wrote:

ray.wurlod wrote: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 ?

Sainath.Srinivasan wrote:

ksk wrote:

ray.wurlod wrote: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

Just login to the database and drop the index!

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