Page 1 of 1
indexes
Posted: Wed Sep 12, 2007 3:45 am
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.
Posted: Wed Sep 12, 2007 5:24 am
by Raghavendra
Can you please let us know what you want to do?
Posted: Wed Sep 12, 2007 5:38 am
by Maveric
You made a statement. You need to ask a question to get a reply.
Posted: Wed Sep 12, 2007 6:08 am
by ray.wurlod
Get the DBA to create the indices.
Re: indexes
Posted: Wed Sep 12, 2007 7:18 am
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.