indexes

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
dlkkrao
Participant
Posts: 37
Joined: Wed Apr 20, 2005 4:26 am
Location: mumbai-india
Contact:
Contact dlkkrao

indexes

Post by dlkkrao »

A number of columns used to process the dimensions (such as src_key columns) do not have indexes. Since lookups use these columns extensively, adding indexes will greatly speed up loading performance.
Top
Raghavendra
Participant
Posts: 147
Joined: Sat Apr 30, 2005 1:23 am
Location: Bangalore,India

Post by Raghavendra »

Can you please let us know what you want to do?
Top
Maveric
Participant
Posts: 388
Joined: Tue Mar 13, 2007 1:28 am

Post by Maveric »

You made a statement. You need to ask a question to get a reply.
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

Get the DBA to create the indices.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Re: indexes

Post by chulett »

dlkkrao wrote:A number of columns used to process the dimensions (such as src_key columns) do not have indexes. Since lookups use these columns extensively, adding indexes will greatly speed up loading performance.
True, that. Well, except maybe for the 'greatly' part.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”