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
Droping index before bulk loading
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
ksk wrote:Is there is any other way without using jobs ?ray.wurlod wrote:How about a DROP INDEX statement (perhaps embedded in a stored procedure) executed from the "Before SQL" or "Open Command"? ...
![Idea :idea:](./images/smilies/icon_idea.gif)
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 toolSainath.Srinivasan wrote:ksk wrote:Is there is any other way without using jobs ?ray.wurlod wrote:How about a DROP INDEX statement (perhaps embedded in a stored procedure) executed from the "Before SQL" or "Open Command"? ...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 ?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: