QuestionQ102
VerifiedData Operations and SupportA company operates a data-processing pipeline that runs multiple SQL queries sequentially against an Amazon Redshift cluster. The company merges with another company. The original company changes a query that aggregates sales-revenue data so that it joins sales tables from both companies. The first company’s sales table is named Table S1. The second company’s sales table is named Table S2. Table S1 has 10 billion records. Table S2 has 900 million records.
The query becomes slow after the change. A data engineer must improve query performance.
Which solutions meet these requirements?
Choose two
Community Discussion