indexes
Moderators: chulett, rschirm, roy
indexes
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.
-
- Participant
- Posts: 147
- Joined: Sat Apr 30, 2005 1:23 am
- Location: Bangalore,India
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: indexes
True, that. Well, except maybe for the 'greatly' part.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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers