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
  1. Increase warehouse size before checking the join
  2. Remove the customer condition entirely
  3. The intended result grain and whether join keys or right-side uniqueness need correction
  4. Add DISTINCT to every selected column without examining the data

Comments — 0