An Amazon Athena query is lagging in performance aws video
data-engineer video for an Amazon Athena query is lagging in performance. The query has a join on two tables using the equality condition. You have been hired
Answer
Full Certification Question
An Amazon Athena query is lagging in performance. The query has a join on two tables using the equality condition. You have been hired as an AWS Certified Data Engineer Associate to optimize the query. Upon analysis, you have noticed that one of the tables is large with millions of rows of data and the other table is small. What do you recommend to address the given requirement?