This website uses cookies to ensure you get the best experience.
Learn more.
A query is slow because a join multiplies each order by every matching historical address for its customer. What should the analyst investigate first?
Published
- Increase warehouse size before checking the join
- Remove the customer condition entirely
- The intended result grain and whether join keys or right-side uniqueness need correction
- Add DISTINCT to every selected column without examining the data
Comments — 0
Sign in to comment